PHP breaks on Oracle PK constraints.

Mike Coughlan mcoughlan@gothambroadband.com
Wed, 16 Jan 2002 14:37:35 -0500


Ok, I spoke too soon. We seem to have other problems that may be Oracle
specific.

Liam, I noticed you saw a similar error in past posts. Please let me know if
you found a fix.

When I log in or set a pref for the first time, all is OK.

When I log out and log in again, or when I reset a pref, I get this error
message - but can click through to effect Oracle:

   Warning: Undefined offset: 1 in /usr/local/lib/php/DB/common.php on line
139

The php.error log says it all - the original INSERT is not failing
gracefully.

[16-Jan-2002 14:02:09] oci8 about to OCIExecute INSERT INTO HORDE_PREFS
(PREF_UID, PREF_SCOPE, PREF_NAME, PREF_VALUE)
VALUES('test@gothambroadband.com', 'imp', 'last_login', '1011207729')
[16-Jan-2002 14:02:09] PHP Warning:  Undefined offset:  1 in
/usr/local/lib/php/DB/common.php on line 139
[16-Jan-2002 14:02:09] oci8 about to OCIExecute UPDATE HORDE_PREFS SET
PREF_VALUE = '1011207729' WHERE PREF_UID = 'test@gothambroadband.com' AND
PREF_NAME = 'last_login' AND PREF_SCOPE = 'imp'
[16-Jan-2002 14:02:09] oci8 OCIExecuted well with 1

Maybe the latest PEAR will help?


_________________________
Mike Coughlan

GOTHAM BROADBAND
3 West 18th Street
NYC 10011
USA

Tel: +1.212.206.9620 ext 310
Fax: +1.212.206.9612
email: mcoughlan@gothambroadband.com