#23099 [Fbk->Opn]: Problems at $result->fetchRow() on some tables

ID: 23099 User updated by: hasihola at cs dot tu-berlin dot de Reported By: hasihola at cs dot tu-berlin dot de -Status: Feedback +Status: Open Bug Type: InterBase related Operating System: Linux 2.4.7-10 PHP Version: 4.3.1 New Comment: Hi, I just D/L the php4-STABLE, but it doesn't even make through Configure, the errors are : checking for InterBase support... yes checking for isc_detach_database in -lgds... no configure: error: libgds not found! Check config.log for more information. ---------------------------------------------------- Config log: configure:37594: gcc -o conftest -g -O2 -L/opt/interbase/lib -lgds conftest.c -lgds -lresolv -lm -ldl -lnsl 1>&5 /opt/interbase/lib/libgds.so: undefined reference to `crypt' collect2: ld returned 1 exit status configure: failed program was: #line 37583 "configure" #include "confdefs.h" /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char isc_detach_database(); int main() { isc_detach_database() ; return 0; } ----------------------------------- I've tried this with 2 stable versions of Firebird: FirebirdSS-1.0.0.796-0 FirebirdSS-1.0.2.908-1 I can't switch to BETA versions of Firebird Thanks much, Jerry Previous Comments: ------------------------------------------------------------------------ [2003-04-08 20:02:39] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2003-04-08 10:05:36] mj@php.net So it's a Interbase problem then. ------------------------------------------------------------------------ [2003-04-08 09:55:49] kancil at ww dot tu-berlin dot de I Don't Think that this is PEAR related, I Tried the newest PEAR packages on PHP 4.3.1 but it don't solve the problem, i even tried to not use PEAR, but instead the normal interbase functions. But if i do SELECT COUNT (*) with the same 'where' expression it results in N row's, but if i try to fetch it, it doesn't have any content. ------------------------------------------------------------------------ [2003-04-07 14:21:52] hasihola at cs dot tu-berlin dot de I just found that my scripts that are running without problems on php 4.2.3, got problem with some Tables on 4.3.1 (Interbase DB). I'm doing select on a Table, but it returns no data here my test : - (After Connecting) - $result = $conn->query($sql); if (DB::isError($result)){ echo "SELECT failed"; } // it passes till here if ( !($row = $result->fetchRow()) ){ echo "Table is filled but no results !!!"; // How could it be ? } This problem wasn't there in php 4.2.3, if I donwgrade the php then the problem vanishes. Here is my table : TERMIN_NR (TERMINNR) SMALLINT Not Null CHECK (VALUE > 0) LEHRVERANSTALTUNGS_NR (LVNR) SMALLINT Not Null CHECK (VALUE > 0) SEMESTER (SEMESTER) CHAR(2) Not Null DEFAULT 'WS' CHECK (VALUE IN ('WS', 'SS')) ANFANGS_DATUM DATE Not Null ENDE_DATUM DATE Not Null PRUEFDATUM DATE Not Null PRUEFTERMIN TIME Not Null PRUEFUNGSART (PRUEFUNGSART) VARCHAR(18) Not Null DEFAULT 'Klausur' CHECK (VALUE IN ('Klausur','Prüfung', 'Rücksprache', 'Mündliche Prüfung')) BETREUER (MITARBEITERNR) SMALLINT Not Null CHECK (VALUE > 0) ANMERKUNG VARCHAR(150) Nullable DEFAULT NULL TERMIN_NUMMER INTEGER Nullable DEFAULT 0 CONSTRAINT INTEG_55: Foreign key (LEHRVERANSTALTUNGS_NR) References LEHRVERANSTALTUNG (LEHRVERANSTALTUNGS_NR) CONSTRAINT INTEG_56: Foreign key (BETREUER) References LEHRSTUHL_MITARBEITER (MITARBEITER_NR) CONSTRAINT INTEG_47: Primary key (TERMIN_NR) Triggers on Table ZEITRAUM: SET_TERMIN_NR, Sequence: 0, Type: BEFORE INSERT, Active I tried to figure out what's wrong, but no positive results !!! thank's much Jerry H ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23099&edit=1