[phplib] active_session question From: Ed Lazor (osmosis <email protected>)
Date: 07/18/00

I get this error message on a regular basis. I checked the mailing list
archive and found a lot of other people have had the problem - but, I don't
see any apparent solutions posted. I tried sending a note to the mailing
list about it and was told to remove the index - ie. make it not
unique. I've run into problems since with very odd problems, mainly having
to do with session variables picking up random values. Is this caused by
making the index un-unique?

Here's the error:

Database error: Invalid SQL: insert into active_sessions ( sid, name, val,
changed ) values ('723735686f03edb03932ea5880633f20', 'AF_Session',
'QUZfU2Vzc2lvbjokdGhpcy0+aW4gPSAnJzsgJHRoaXMtPnB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQUZfQXV0aDsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aCA9IGFycmF5KCk7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3VpZCddID0gJ25vYm9keSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWyd1bmFtZSddID0gJ25vYm9keSc7IA==',
'20000718150754')
MySQL Error: 1062 (Duplicate entry
'AF_Session-723735686f03edb03932ea5880633f20' for key 1)
Session halted.

Oh, one thing I found that did make the error message itself go away was
adding
         var $Halt_On_Error = "no";
to the local.inc file. Of course, I don't think that fixes the problem,
just hides it.

Any recommendations?

-Ed

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