[phplib] Session errors, but only on one of two setups From: Peter Howard (pjh <email protected>)
Date: 07/16/00

Dear all

I am having a problem tracing down a session error. I am developing on my
"home" setup, and do not see the problem here. I only see it on my "target"
system. There are spec differences.

Home 

----

MySQL 3.22.32
PHP 3.0.15+ (Either .15 or .16)
PHPLIB 7.2B

Target
------

MySQL 3.23.8-alpha
PHP 3.0.?  (Not sure)
PHPLIB 7.2B

The error occurs with authenticated sesisons. (My session setup is based on
the examples in the manual) As far as I have traced it, the session is
registered in the DB before the login screen comes up.  I type in a valid
username+password, which authenticate sucessfully.  However, on the Target
system, an attempt is then made to register the same session again, which
produces an error like:

Database error: Invalid SQL: insert into ACTIVE_SESSIONS ( sid,
name, val, changed ) values
('bf44b49a98969697379ba7e0f3812751','nlSession','bmV0dGVsbFNlc3Npb246JHRoaXM
tPmluID0gJzEnOyAkdGhpcy0cHQgPSBhcnJheSgpOyAkdGhpcy0cHRbJ2F1dGgnXSA9ICcxJzsgJ
HRoaXMtPnB0WydjaGFsbGVuZ2UnXSA9ICcxJzsgJHRoaXMtPnB0Wyd1c2VyX25hbWUnXSA9ICcxJ
zsgJHRoaXMtPnB0WydpZCddID0gJzEnOyAkdGhpcy0cHRbJ2luZm8nXSA9ICcxJzsgJHRoaXMtPn
B0WyduZXdfaW5mbyddID0g
>JzEnOyAkR0xPQkFMU1snYXV0aCddID0gbmV3IG5ldHRlbGxBdXRoOyAkR0xPQkFMU1snYXV0aCd
dLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0YXV0aFsndWlkJ10gPSAnMzM1Njcn
OyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydwZXJtJ10gPSAnY29tcGFueSc7ICRHTE9CQUxTWydh
dXRoJ10tPmF1dGhbJ2V4cCddID0gJzk2MzE5NDcxMic7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhb
J3JlZnJlc2gnXSA9ICc5NjMxOTM4MTInOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWyd1bmFtZSdd
ID0gJ0FDQzMnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnMDgwNTdhYjQzZTYxOTczNWJhYzE2
NmY3NzQ0YzUwZjcnOyAkR0xPQkFMU1sndXNlcl9uYW1lJ10gPSAnQUNDMyc7ICRHTE9CQUxTWydp
ZCddID0gJyc7ICRHTE9CQUxTWydpbmZvJ10gPSAnJzsgJEdMT0JBTFNbJ25ld19pbmZvJ10gPSAn
Jzsg','20000710115012'

MySQL Error: 1062 (Duplicate entry
nlSession-bf44b49a98969697379ba7e0f3812751' for key 1)
Session halted.

Any suggestions?

Thanks

PJH

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>