Interbase DB module problems

From: Date: Mon, 21 Jan 2002 17:56:09 +0000
Subject: Interbase DB module problems
Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-4021@lists.php.net to get a copy of this message
I am having problems with the DB::ibase module, and I'm wondering if anybody else has seen the same thing. On a perfectly functional DB connection to interbase, if I try to get a resultset from getAll() with fetchmode set to DB_FETCHMODE_ASSOC something gets stuck in a loop, and all I get is the following error message, repeated forever: Warning: InterBase: request synchronization error in /home/virtual/pear/DB/ibase.php on line 177 sample code: $q = "select first 5 url, name, tstamp from links where approved='Y' order by tstamp desc"; $vars = $db->getAll($q, null, DB_FETCHMODE_ASSOC); I tried a few things, but I can't find what's causing the bug. The only thing I noticed is, if I remove the cast to array from ibase.php (lines 176-178) if ($fetchmode & DB_FETCHMODE_ASSOC) { $ar = ibase_fetch_object($result); } instead of if ($fetchmode & DB_FETCHMODE_ASSOC) { $ar = (array)ibase_fetch_object($result); } everything works well, apart from the fact I get stdObjects where I need hashes. I am running the latest pear CVS with php 4.1.1 compiled from sources on a (more or less fully patched) RH 6.2 system. I have tried the same code against Firebord 0.94 and 1.0 beta2 on the same machine, with the same results. Is it a php interbase module bug? Thanks for any help in researching this bug Ludo

« previous php.pear.dev (#4021) next »