#32800 [Fbk->Opn]: 64 bit linux + php + IBM DB2

ID: 32800 User updated by: tinko at siol dot com Reported By: tinko at siol dot com -Status: Feedback +Status: Open Bug Type: ODBC related Operating System: SLES9 64 bit PHP Version: 4.3.11 New Comment: I simply changed 'long int' to 'SDWORD' in php_odbc_includes.h like it was said in bug #32830. I had this problem for a long time, and now is solved. It is a problem only on 64 bit platform... Tinko Thanks again.... Previous Comments: ------------------------------------------------------------------------ [2005-05-08 21:58:37] sniper@php.net Exactly what did you do? (there was no feedback on the other report..) ------------------------------------------------------------------------ [2005-05-03 10:26:18] tinko at siol dot com Problem solved with Your answer. Thank You very much. Tinko ------------------------------------------------------------------------ [2005-04-27 16:13:40] sniper@php.net Might be related to bug #32830 ------------------------------------------------------------------------ [2005-04-22 11:38:50] tinko at siol dot com Description: ------------ Hello! Kinda desperate here, since I've read all about php + db2 + apache, so is there a soul to help me? I'm running SLES 9 (also SLES8 - the problem is the same) under z/VM on z900 (1IFL) in 64 bit mode/version. I successfuly installed IBM DB2 8.1 ESE (64 bit) with latest FixPacks. DB2 runs fine, I can connect to DB2 on z/OS... I've compiled (many versions) of php (with -m64) with IBM-DB2 included ... everything by the manual, and everything works fine - apache+php connect, insert, odbc_result_all, but when trying to do odbc_result with fetching i get the number of rows with no values... After running query for several times I get emalloc errors in apache log... (I've tried many different shapes of queries...allways the same result) I've also tried to do the same configuration on 32 bit linux on intel ...same php, db2, queries etc.... - everything works perfect and fast. So, i think there must be a 64 bit issue... Any1 has any ideas? Please, please help Thank You very much in advance, Tinko Reproduce code: --------------- I found this... In file included from /home/db2inst1/sqllib/include/sqlcli1.h:42, from /ins/php-4.3.11/ext/odbc/php_odbc_includes.h:176, from /ins/php-4.3.11/ext/odbc/php_odbc.c:37: /home/db2inst1/sqllib/include/sqlcli.h:772:1: warning: "ODBCVER" redefined In file included from /ins/php-4.3.11/ext/odbc/php_odbc.c:37: /ins/php-4.3.11/ext/odbc/php_odbc_includes.h:28:1: warning: this is the location of the previous definition /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `safe_odbc_disconnect': /ins/php-4.3.11/ext/odbc/php_odbc.c:201: warning: passing arg 1 of `SQLDisconnect' makes integer from pointer without a cast /ins/php-4.3.11/ext/odbc/php_odbc.c:204: warning: passing arg 1 of `SQLTransact' makes integer from pointer without a cast /ins/php-4.3.11/ext/odbc/php_odbc.c:204: warning: passing arg 2 of `SQLTransact' makes integer from pointer without a cast /ins/php-4.3.11/ext/odbc/php_odbc.c:205: warning: passing arg 1 of `SQLDisconnect' makes integer from pointer without a cast /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `_close_odbc_conn': /ins/php-4.3.11/ext/odbc/php_odbc.c:231: warning: passing arg 1 of `safe_odbc_disconnect' makes pointer from integer without a cast /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `_close_odbc_pconn': /ins/php-4.3.11/ext/odbc/php_odbc.c:259: warning: passing arg 1 of `safe_odbc_disconnect' makes pointer from integer without a cast /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `odbc_bindcols': /ins/php-4.3.11/ext/odbc/php_odbc.c:676: warning: passing arg 6 of `SQLBindCol' from incompatible pointer type /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `zif_odbc_execute': /ins/php-4.3.11/ext/odbc/php_odbc.c:1042: warning: cast to pointer from integer of different size /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `zif_odbc_data_source': /ins/php-4.3.11/ext/odbc/php_odbc.c:1223: warning: passing arg 2 of `odbc_sql_error' makes integer from pointer without a cast /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `php_odbc_fetch_hash': /ins/php-4.3.11/ext/odbc/php_odbc.c:1434: warning: passing arg 6 of `SQLGetData' from incompatible pointer type /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `zif_odbc_fetch_into': /ins/php-4.3.11/ext/odbc/php_odbc.c:1594: warning: passing arg 6 of `SQLGetData' from incompatible pointer type /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `zif_odbc_result': /ins/php-4.3.11/ext/odbc/php_odbc.c:1825: warning: passing arg 6 of `SQLGetData' from incompatible pointer type /ins/php-4.3.11/ext/odbc/php_odbc.c:1868: warning: passing arg 6 of `SQLGetData' from incompatible pointer type /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `zif_odbc_result_all': /ins/php-4.3.11/ext/odbc/php_odbc.c:1972: warning: passing arg 6 of `SQLGetData' from incompatible pointer type /ins/php-4.3.11/ext/odbc/php_odbc.c: In function `odbc_do_connect': /ins/php-4.3.11/ext/odbc/php_odbc.c:2302: warning: cast from pointer to integer of different size ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=32800&edit=1