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

ID: 23099 Updated by: sniper@php.net Reported By: hasihola at cs dot tu-berlin dot de -Status: Open +Status: Feedback Bug Type: InterBase related Operating System: Linux 2.4.7-10 PHP Version: 4.3.1 New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [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