#19982 [Com]: select from multiple tables fail
ID: 19982 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: ODBC related Operating System: RedHat 6.2 PHP Version: 4.2.3 New Comment: Notes: '--with-informix' Imho it should be "-with-informix=yes". But if you make (make install) worked, that should be no problem. Why do you use a => $db = odbc_connect("$dsn", "$user", "$password"); if you could use a => $connect = ifx_connect("$database@IFX_SERVER", "$user", "$password"); ? To your problem: What happens if you run the statment: "Select codice,name,address, zipnum from clienti, ziptable where codice = zipcode and codice = '$codice'" in DBACCESS? Please give me examples for "codice", "zipcode" and "$codice". (Since JOIN here.) "This script fail..." I assume there is no error? Regards, Claus Previous Comments: [2002-10-21 02:37:10] [EMAIL PROTECTED] The SQL log [0] SQLAllocHandle handleType=1 [0] SQLAllocHandle: returning SQL_SUCCESS [0] SQLSetEnvAttr hEnv=DBD0001 Attribute=200 ValuePtr=2 StringLength=0 [0] SQLSetEnvAttr: returning SQL_SUCCESS [0] SQLAllocHandle hEnv=DBD0001 handleType=2 [0] SQLAllocHandle: returning SQL_SUCCESS [0] SQLConnect hDbc=DBD0002 szDSN=820012C cbDSN=-3 szUID=8200114 cbUID=-3 szPWD=82000FC cbPWD=-3 DSN=gaia;UID=gaeuro;PWD=erre1 connStr=[DSN] key=[DSN] data=[gaia] supplied=1 key=[DATABASE] data=[/usr/serv1/gaeuro/exe/dbgaia/gaia] supplied=0 key=[OPTIONS] data=[] supplied=0 key=[UID] data=[gaeuro] supplied=1 key=[READONLY] data=[] supplied=0 key=[HOST] data=[10.30.0.33] supplied=0 key=[PORT] data=[5000] supplied=0 key=[SVT] data=[Informix 7.2] supplied=0 key=[FBS] data=[99] supplied=0 key=[NLB] data=[Yes] supplied=0 key=[PROTO] data=[TCP/IP] supplied=0 key=[DLF] data=[] supplied=0 cn_dbpath=[/usr/serv1/gaeuro/exe/dbgaia/gaia] cn_dbopts=[] cn_readonly=0 cn_fetchSize=99 cn_dbhost=[10.30.0.33] cn_svtype=[Informix 7.2] cn_deferlongfetch=0 cn_needbind=1 cn_hasMoreRes=1 cn_hasParamOp=0 cn_hasScrlCurs=1 cn_hasDynMixCurs=0 cn_hasV2DAE=0 cn_spOutDeferFetch=0 cn_hasExecute2=0 autocommit=1 [0] SQLConnect: returning SQL_SUCCESS [0] SQLGetInfo hDbc=DBD0002 fInfoType=23 rgbInfoValue=81F6CA4 cbInfoValueMax=2 pcbInfoValue=0 [0] SQLGetInfo: returning SQL_SUCCESS [0] SQLGetInfo hDbc=DBD0002 fInfoType=24 rgbInfoValue=81F6CA6 cbInfoValueMax=2 pcbInfoValue=0 [0] SQLGetInfo: returning SQL_SUCCESS [0] SQLAllocHandle hDbc=DBD0002 handleType=3 [0] SQLAllocHandle: returning SQL_SUCCESS [0] SQLGetStmtAttr hStmt=DBD0003 Attribute=10010 ValuePtr=081F98C4 BufferLength=0 StringLengthPtr= [0] SQLGetStmtAttr: returning SQL_SUCCESS [0] SQLGetStmtAttr hStmt=DBD0003 Attribute=10011 ValuePtr=081F98EC BufferLength=0 StringLengthPtr= [0] SQLGetStmtAttr: returning SQL_SUCCESS [0] SQLGetStmtAttr hStmt=DBD0003 Attribute=10012 ValuePtr=081F9914 BufferLength=0 StringLengthPtr= [0] SQLGetStmtAttr: returning SQL_SUCCESS [0] SQLGetStmtAttr hStmt=DBD0003 Attribute=10013 ValuePtr=081F993C BufferLength=0 StringLengthPtr= [0] SQLGetStmtAttr: returning SQL_SUCCESS [0] SQLGetInfo hDbc=DBD0002 fInfoType=8 rgbInfoValue=BFFFDA1C cbInfoValueMax=4 pcbInfoValue=0 [0] SQLGetInfo: returning SQL_SUCCESS [0] SQLSetStmtAttr hStmt=DBD0003 Attribute=6 ValuePtr=0002 StringLength=0 [0] SQLSetStmtAttr: returning SQL_SUCCESS_WITH_INFO [0] SQLExecDirect hStmt=DBD0003 szSqlStr=81F9204 cbSqlStr=-3 [Select a_sigla_art, a_descr_art, sc_descr from art, sco where sc_cod_s_conto=a_cod_forn] [0] SQLExecDirect: returning SQL_SUCCESS [0] SQLNumResultCols hStmt=DBD0003 pccol=BFFFD9CA [0] SQLNumResultCols: returning SQL_SUCCESS [0] SQLNumResultCols hStmt=DBD0003 pccol=BFFFD9DA [0] SQLNumResultCols: returning SQL_SUCCESS [0] SQLColAttribute hStmt=DBD0003 icol=1 fDescType=1011 rgbDesc=081F995C cbDescMax=32 pcbDesc=BFFFD9FE pfDesc= [0] SQLColAttribute: returning SQL_SUCCESS [0] SQLColAttribute hStmt=DBD0003 icol=1 fDescType=2 rgbDesc= cbDescMax=0 pcbDesc= pfDesc=081F9984 [0] SQLColAttribute: returning SQL_SUCCESS [0] SQLColAttribute hStmt=DBD0003 icol=1 fDescType=6 rgbDesc= cbDescMax=0 pcbDesc= pfDesc=BFFFD9F8 [0] SQLColAttribute: returning SQL_SUCCESS [0] SQLBindCol hStmt=DBD0003 icol=1 fCType=1 rgbValue=81F8E3C cbValueMax=19 pcbValue=81F9980 [0] SQLBindCol: returning SQL_SUCCESS [0] SQLColAttribute hStmt=DBD0003 icol=2 fDescType=1011 rgbDesc=081F9988 cbDescMax=32 pcbDesc=BFFFD9FE pfDesc= [0] SQLColAttribute: returning SQL_SUCCESS [0] SQLColAttribute hStmt=DBD0003 icol=2 fDescType=2 rgbDesc= cbDescMax=0 pcbDesc= pfDesc=081F99B0 [0] SQLColAttribute: returning SQL_SUCCESS [0] SQLColAttribute hStmt=DBD0003 icol=2 fDescType=6 rgbDesc= cbDescMax=0 pcbDes
#19219 [Com]: Cannot build with-informix for Apache DSO
ID: 19219 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Informix related Operating System: HPUX 11.0 PHP Version: 4.2.2 New Comment: @sniper "this really is not PHP bug but libtool one." I don't know if it's a libtool bug or a bug within the IfxCSDK, but imho it's defenitly no bug within PHP, so I would close this bug. It could be an user error, too, because installing PHP with Ifx is tricky. We had to install two different IfxCSDK, to get it work. Regards, Claus Previous Comments: [2002-11-06 03:23:54] [EMAIL PROTECTED] I am not sure if I can offer help, but since I installed INFORMIX IDS on a HPUX once and I have a running PHP-INFORMIX enviroment on a standard INTEL server (Primergy I think). You say: "NOTE: As stated before, if I build a php without the informix module, all works as it should. If I build the informix configuration, the build completed, but with the following warnings:" To get this straight: "lib/esql -lixgls -lnsl_s -lV3 -lcl -lsec" -lixgls has something to do with "Global Language Support" something I only encountered with INFORMIX (perhaps I am wrong), in this case a GLS parameter (-lixgls) for ESQL Doesn't it make sense that "-lV3" is something within ESQL, too? So this problem could exist in your IfxCSDK. Which version do you use? I suppose it was released for HPUX 11.0? Best regards, Claus [2002-09-28 00:18:04] [EMAIL PROTECTED] FWIW...There are tons on references on comp.sys.hpux regarding "thread local storage". The all basically state that one must statically include the libcl.2 in the a.out. I must assume here that in our case here, a.out is lib4php.sl. However, I know very little about Make and makefiles. I dont have a clue as to what to edit to make this happen. [2002-09-26 23:43:04] [EMAIL PROTECTED] HELP! I'm dying here. If I don't get this running I may loose a consulting contract! Whats the process to get a developer to take a look here? [2002-09-09 19:50:31] [EMAIL PROTECTED] ANYONE ELSE UP TO THE CHALLENGE??? ...here is the contents of the ext dir of PHP for Informix [hpserv02] ls .deps Makefileifx.c ifx.lo libs.mk stub.c .libs Makefile.in ifx.dsp libinformix.la php_informix.h CREDITS config.m4 ifx.ec libphpifx.a setup.stub ..the .lib DIR contains.. [hpserv02] ls -al .libs -rw-rw-rw- 1 root sys 321104 Sep 9 19:55 libinformix.al lrwxrwxrwx 1 root sys 17 Sep 9 19:55 libinformix.la -> ../libinformix.la ALSO.. [hpserv02] [hpserv02] ls /usr/informix/lib esql iasft07b.sllibixasf.a libtasf.a netstub.a sqlexecd iasfs07a.sllibasf.a libixasf.sllibtasf.sl sqlexec sqlexecd.old iasfs07b.sllibasf.sl libnetstub.sl netlib.a sqlexec.old sqlrm [hpserv02] [hpserv02] ls /usr/informix/lib/esql checkapi.oigl4a303.sl isqlt07a.sl libgls.a libixgen.sl libixos.a libos.sl libtos.a esqlc iglxa303.sl isxas07a.sl libglx.a libixgls.a libixos.sllibsql.a libtos.sl esqlmfiosls07a.sl ixacursor.o libinfxxa.a libixgls.sl libixsql.alibsql.sl libtsql.a igens07a.sl ioslt07a.sl libgen.a libinfxxa.sl libixglx.a libixsql.sl libtgen.a libtsql.sl igent07a.sl isqls07a.sl libgen.sl libixgen.alibixglx.sl libos.a libtgen.sl [hpserv02] [2002-09-04 19:40:23] [EMAIL PROTECTED] I think libtool sucks. And I'm out of ideas. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19219 -- Edit this bug report at http://bugs.php.net/?id=19219&edit=1
#19219 [Com]: Cannot build with-informix for Apache DSO
ID: 19219 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Informix related Operating System: HPUX 11.0 PHP Version: 4.2.2 New Comment: I am not sure if I can offer help, but since I installed INFORMIX IDS on a HPUX once and I have a running PHP-INFORMIX enviroment on a standard INTEL server (Primergy I think). You say: "NOTE: As stated before, if I build a php without the informix module, all works as it should. If I build the informix configuration, the build completed, but with the following warnings:" To get this straight: "lib/esql -lixgls -lnsl_s -lV3 -lcl -lsec" -lixgls has something to do with "Global Language Support" something I only encountered with INFORMIX (perhaps I am wrong), in this case a GLS parameter (-lixgls) for ESQL Doesn't it make sense that "-lV3" is something within ESQL, too? So this problem could exist in your IfxCSDK. Which version do you use? I suppose it was released for HPUX 11.0? Best regards, Claus Previous Comments: [2002-09-28 00:18:04] [EMAIL PROTECTED] FWIW...There are tons on references on comp.sys.hpux regarding "thread local storage". The all basically state that one must statically include the libcl.2 in the a.out. I must assume here that in our case here, a.out is lib4php.sl. However, I know very little about Make and makefiles. I dont have a clue as to what to edit to make this happen. [2002-09-26 23:43:04] [EMAIL PROTECTED] HELP! I'm dying here. If I don't get this running I may loose a consulting contract! Whats the process to get a developer to take a look here? [2002-09-09 19:50:31] [EMAIL PROTECTED] ANYONE ELSE UP TO THE CHALLENGE??? ...here is the contents of the ext dir of PHP for Informix [hpserv02] ls .deps Makefileifx.c ifx.lo libs.mk stub.c .libs Makefile.in ifx.dsp libinformix.la php_informix.h CREDITS config.m4 ifx.ec libphpifx.a setup.stub ..the .lib DIR contains.. [hpserv02] ls -al .libs -rw-rw-rw- 1 root sys 321104 Sep 9 19:55 libinformix.al lrwxrwxrwx 1 root sys 17 Sep 9 19:55 libinformix.la -> ../libinformix.la ALSO.. [hpserv02] [hpserv02] ls /usr/informix/lib esql iasft07b.sllibixasf.a libtasf.a netstub.a sqlexecd iasfs07a.sllibasf.a libixasf.sllibtasf.sl sqlexec sqlexecd.old iasfs07b.sllibasf.sl libnetstub.sl netlib.a sqlexec.old sqlrm [hpserv02] [hpserv02] ls /usr/informix/lib/esql checkapi.oigl4a303.sl isqlt07a.sl libgls.a libixgen.sl libixos.a libos.sl libtos.a esqlc iglxa303.sl isxas07a.sl libglx.a libixgls.a libixos.sllibsql.a libtos.sl esqlmfiosls07a.sl ixacursor.o libinfxxa.a libixgls.sl libixsql.alibsql.sl libtsql.a igens07a.sl ioslt07a.sl libgen.a libinfxxa.sl libixglx.a libixsql.sl libtgen.a libtsql.sl igent07a.sl isqls07a.sl libgen.sl libixgen.alibixglx.sl libos.a libtgen.sl [hpserv02] [2002-09-04 19:40:23] [EMAIL PROTECTED] I think libtool sucks. And I'm out of ideas. [2002-09-04 17:37:33] [EMAIL PROTECTED] No such luck. The standard build with: ./configure --with-apxs=/usr/informix/apache/bin/apxs --with-mysql=no Resulted in . . *** Warning: This library needs some functionality provided by -lcrypt*** I have the capability to make that. *** Warning: libtool could not satisfy all declared inter-library*** dependencies of module libphp4. Therefore, libtool will create *** a static module, that should work as long as the dlopening *** application is linked with the -dlopen flag. Installing PHP SAPI module apxs:Error: file libs/libphp4.sl is not a DSO *** Error exit code 1 Stop. === the libs directory contained two libraries... libphp4.a libphp4.la I copied them to the apache modules dir and updated the httpd.conf to include themwhen starting get the error: [hpserv02] ./apachectl start /usr/lib/dld.sl: Bad magic number for shared library: /usr/local/apache/lib/modules/libphp4.la /usr/lib/dld.sl: Exec format error Syntax error on line 236 of /usr/local/apache/etc/httpd.conf: Cannot load /usr/local/apache/lib/modules/libphp4.la into server: Exec format error ./apachectl start: httpd could not be started - Since I cannot rebuild the Apache, I must have an Informix make file
#19416 [Com]: unproperly use of the ESQL Library?
ID: 19416 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Informix related Operating System: Linux PHP Version: 4.2.2 New Comment: We had the same problem here once, but in our case it was the programmers fault. He didn't know SQL to well and counted the rows using a WHILE loop instead of "SELECT COUNT(*) ...". It was a large database and when the script was used often our intranet site did not respond. I do not think, that is your problem, but could you post your - OS - INFORMIX RDBMS version (IDS, ODS, SE, ...) - SQL statement that causes the problem? I think this will help, because we encoutered problems on 7.31.UC7, which did not occur on IDS 9.2x.y. Thanks in advance! Claus Previous Comments: [2002-09-15 09:51:07] [EMAIL PROTECTED] When you do very much querys at the same time (or big querys with subquerys) Informix reports a Error -439 that means a SQL Query is currently running and you can`t do your query yet. Error 439 means: You attempted to call an SQL routine or attempted to execute an SQL statement within a signal handling function/routine or a callback function/procedure. Use only the sqldone() and sqlbreak() library functions inside your INFORMIX-ESQL/C callback function. Use only the ECO-SQD and ECO-SQB library routines inside your ESQL/COBOL callback procedure. In addition, if you want to unregister your callback function in INFORMIX-ESQL/C, you can invoke the sqlbreakcallback() callback registration function within your callback procedure. If you want to unregister your callback procedure in ESQL/COBOL, you can invoke the ECO-SQBCB callback registration routine within your callback procedure. ---snip--- so do you use a false ESQL Function? -- Edit this bug report at http://bugs.php.net/?id=19416&edit=1