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

From: hasihola at cs dot tu-berlin dot de Operating system: Linux 2.4.7-10 PHP version: 4.3.1 PHP Bug Type: PEAR related Bug description: Problems at $result->fetchRow() on some tables 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 bug report at http://bugs.php.net/?id=23099&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=23099&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=23099&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=23099&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=23099&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=23099&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=23099&r=support Expected behavior: http://bugs.php.net/fix.php?id=23099&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=23099&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=23099&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=23099&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=23099&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=23099&r=dst IIS Stability: http://bugs.php.net/fix.php?id=23099&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=23099&r=gnused