|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2003-04-07 14:21 UTC] 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
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Sat Dec 21 16:01:28 2024 UTC |
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, JerryMaybe I don't explain me well ... 1) the compile failure exists for ALL Firebird users, it's our test for libgds in ./configure that is not correct . If we don't fix it you couldn't compile php with Firebird anymore .... this is why I turn your bug in compile error. So right now let's solve the compile error ok? 2) Open a NEW bug for ibase_fetch_row (and without pear 100%). I need to reproduce the error you 're talking about for ibase_fetch_row but from your information I can't. All tests I 've done work good.