Interbase DB module problems
| From: | Ludovico Magnocavallo | 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