From: Operating system: Linux ReadHat 5.3 x86_64 PHP version: 5.3.8 Package: Sybase-ct (ctlib) related Bug Type: Bug Bug description:Use ctlib 15.5 64bits failed
Description: ------------ Y want to use PHP 5.2.17 with lib DB 1.7.14 for Oracle (11.2) and Sybase (15.5) in a 64 bits environnement. All work for Oracle. Red Hat Enterprise Linux Server release 5.3 (Tikanga) Linux linnt27.tlt 2.6.18-128.el5 #1 SMP Wed Dec 17 11:41:38 EST 2008 x86_64 x86_64 x86_64 GNU/Linux Sybase CTISQL Utility/15.5/P-EBF17747 ESD #4/DRV.15.5.1/Linux Intel/Linux 2.6.9-55.ELsmp x86_64/BUILD1550-006/OPT/Sun Apr 18 01:03:56 2010 For Sybase i haved the knowed problem to take 64bits libraries ... So i have manually modified the Makefile to put the good libraries, compilation and installation work (make and make install), but have errors when i want to execute sybase query ! Used config command: cd $HOME/php-5.2.17 ./configure --prefix=/home/oracle/php5.2.17 --with-apxs2=/home/oracle/apache/bin/apxs \ --disable-short-tags --with-zlib --enable-calendar --enable-ftp --with-gd --with-freetype-dir \ --with-iconv --with-gettext --with-jpeg-dir=/usr/lib --with-png-dir --enable-mbstring --enable-pcntl \ --enable-soap --enable-zip --with-pear --enable-bcmath --without-sqlite --without-pdo-sqlite \ --enable-sigchild --with-libdir=lib64 --enable-gd-native-ttf --enable-xmlwriter --without-readline --with-gd --with-xpm-dir --enable-exif \ --with-oci8=$ORACLE_HOME --with-pdo-oci=$ORACLE_HOME \ --with-sybase-ct=$SYBASE/$SYBASE_OCS Manually modify Makefile to put: CFLAGS = $(CFLAGS_CLEAN) -DSYB_LP64 EXTRA_LIBS = -lcrypt -lz -lsybcs64 -lsybct64 -lsybcomn64 -lsybintl64 -lsybtcl64 ... So, when i test connexion with the test.php script i have this error: Fail to connect: Erreur: DB Error: no database selected DB Error: no database selected So, if i change my dsn to "sybase://indsyb_maj:psswd@DBSYBIND", the connection work but i have this error: Fatal error: Call to undefined method DB_Error::numRows() in /home/oracle/SQWareWeb/v2.0/test.php on line 41 So, if i comment the line that call $res->numRows(), i have: DB Error: unknown error What the good solution to compile PHP with Sybase 64bits ? I have to stand in PHP 5.2 ... Test script: --------------- <?php include('DB.php'); echo "<pre>"; $dsn = "sybase://indsyb_maj:psswd@DBSYBIND/syb_inddba"; $options = array('debug' => 2, 'portability' => DB_PORTABILITY_ALL); $db = DB::connect($dsn,$options); if (DB::isError($db)) { echo "dsn=$dsn\n"; echo "Fail to connect:\n"; echo "Erreur: ".$db->getMessage()."\n"; die ($db->getMessage()); } $query = "select distinct DataServer from tedt_Repository where Status!='OFF' order by 1"; $res = $db->query($query); echo "Numrows: ".$res->numRows()."\n"; if (DB::isError($res)) { die ($res->getMessage()); } while ($record = $res->fetchRow(DB_FETCHMODE_ASSOC)) { echo nl2br(print_r($record,true))."\n"; } $res->free(); $db->disconnect(); ?> -- Edit bug report at https://bugs.php.net/bug.php?id=55655&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=55655&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=55655&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=55655&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=55655&r=fixed Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=55655&r=needdocs Fixed in release: https://bugs.php.net/fix.php?id=55655&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=55655&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=55655&r=needscript Try newer version: https://bugs.php.net/fix.php?id=55655&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=55655&r=support Expected behavior: https://bugs.php.net/fix.php?id=55655&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=55655&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=55655&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=55655&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=55655&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=55655&r=dst IIS Stability: https://bugs.php.net/fix.php?id=55655&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=55655&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=55655&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=55655&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=55655&r=mysqlcfg