From: tinko at siol dot com
Operating system: SLES9 64 bit
PHP version: 4.3.11
PHP Bug Type: ODBC related
Bug description: 64 bit linux + php + IBM DB2
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 bug report at http://bugs.php.net/?id=32800&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32800&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=32800&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=32800&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=32800&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=32800&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=32800&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=32800&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=32800&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=32800&r=support
Expected behavior: http://bugs.php.net/fix.php?id=32800&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=32800&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=32800&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=32800&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32800&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=32800&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=32800&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=32800&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=32800&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=32800&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=32800&r=mysqlcfg
