[phplib] Trouble migrating to PHP4; duplicate session id? From: Matthew Leingang (leingang <email protected>)
Date: 09/25/00

Hi PHPlibbers,

My host just upgraded me to a new server with PHP4 and MYSQL
3.23.something. Yippee! That's the good news. The bad news is that now
I get an error on one of the pages, _though_not_all_the_time_.

<b>Database error:</b> Invalid SQL: insert into active_sessions ( sid,
name, val, changed ) values ('f627ab8a7d4ff2133fad7df77c2727f2',
'DKE_Session',
'REtFX1Nlc3Npb246JHRoaXMtPmluID0gJzEnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhpcy=
0+cHRbJ2F1dGgnXSA9ICcxJzsgJHRoaXMtPnB0WydxJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ=
10gPSBuZXcgREtFX0RlZmF1bHRfQXV0aDsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aCA9IGFycmF5=
KCk7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3VpZCddID0gJzU0NTUyMmYyZDFmZjcxYTJjNzE=
4MjdjMDk1YjhhOTcwJzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSddID0gJ3VzZXIsYW=
x1bW51cyxhZG1pbixhdXRob3InOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICc5N=
jk2NjIwNTgnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydyZWZyZXNoJ10gPSAnOTY5NjU5NTY3=
JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndW5hbWUnXSA9ICdsZWluZ2FuZyc7ICRHTE9CQUx=
TWydxJ10gPSBuZXcgREtFX1NxbF9RdWVyeTsgJEdMT0JBTFNbJ3EnXS0+Y29uZGl0aW9ucyA9IC=
cxJzsgJEdMT0JBTFNbJ3EnXS0+aW5wdXRfc2l6ZSA9ICcyMCc7ICRHTE9CQUxTWydxJ10tPmluc=
HV0X21heCA9ICc4MCc7ICRHTE9CQUxTWydxJ10tPm1ldGhvZCA9ICdwb3N0JzsgJEdMT0JBTFNb=
J3EnXS0+bGFuZyA9ICdlbic7ICRHTE9CQUxTWydxJ10tPnRyYW5zbGF0ZSA9ICdvbic7ICRHTE9=
CQUxTWydxJ10tPmNvbnRhaW5lciA9ICdvbic7ICRHTE9CQUxTWydxJ10tPnZhcmlhYmxlID0gJ2=
9uJzsgJEdMT0JBTFNbJ3EnXS0+c2VsZWN0Ym94ID0gJ29uJzsg',
'20000922181918')<br>
<b>MySQL Error</b>: 1062 (Duplicate entry
'DKE_Session-f627ab8a7d4ff2133fad7df77c2727f2' for key 1)<br>
Session halted.

I haven't had this problem before. All I did was copy all my files--both
the scripts and the database--from one server to another. So I have to
think that this is an incompatibility of my PHPLIB version (7.2b) with
PHP4. =20

I seem to remember there being a common problem like this when migrating
and a quick solution being put on the mailing list. But the mailing list
archive is not searchable now, so I can only ask again. Please help me!
My host wants to delete my old account as soon as possible!

Thanks in Advance,
Matt

----------------------------------------------------------------
Matthew Leingang http://www.math.rutgers.edu/
Rutgers University leingang <email protected>
Department of Mathematics "This signature needs no quote."

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