Re: [phplib] Sessions error - urgent help required please! From: R.B. Scholtus (regiment <email protected>)
Date: 09/12/00

Yes - It's a very funny bug. If nothing changes in your session variables
record in active_sessions the number of affected rows will equal zero. So
ct_sql will insert a new row, causing the problem, because the row IS there
already.

Upgrade to phplib 7.2c and the problem is over.

Brian

----- Original Message -----
From: "Chris Cochella" <chris <email protected>>
To: "Mark Leavy" <MarkL <email protected>>
Cc: "phplist" <phplib <email protected>>
Sent: Tuesday, September 12, 2000 11:03 PM
Subject: Re: [phplib] Sessions error - urgent help required please!

> I am also experiencing this problem and need a fix.
>
> Anymore advice (php/phplib luminaries out there) is greatly appreciated.
>
> Thanks,
>
> Chris
> php4.0.0
> phplib7.2b
> redhat 6.1
> Apache 1.3.9 or so.
>
> Mark Leavy wrote:
>
> > Prolly not the right way to fix..and it's only temp but i usually find a
> > 'delete from active_sessions' does the trick.
> >
> > On Tue, 12 Sep 2000 15:32:18 -0400, Mike Green said:
> >
> > > I feel moved to reply to "Does anyone else have experience of this
problem...?"
> > > with the answer "Yes!" And I have seen the same question asked many
times. But
> > > have heard from no one as to how to fix it. So let me add my plea
again for
> > > help from someone ;-)
> > >
> > > Cheers!
> > >
> > > Mike
> > >
> > > Mikey wrote:
> > >
> > > > Hi there,
> > > >
> > > > I have implemented sessions using phplib7.2b on a RedHat 6.2 box
running
> > > > Apache 1.3.12 with php4.0.pl2 installed as a module.
> > > >
> > > > Lately, my clients (but not myself) have been getting the following
error
> > > > when trying to access the site:
> > > >
> > > > Database error: Invalid SQL: insert into site_sessions ( sid, name,
val,
> > > > changed ) values ('df5f9cfe1186902cd397f5ce156d8da9',
'SITESESSION',
> > > >
'U0lURVNFU1NJT046JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGlzLT5
> > > >
wdFsnbGFuZyddID0gJzEnOyAkdGhpcy0+cHRbJ2F1dGgnXSA9ICcxJzsgJEdMT0JBTFNbJ2xhbmc
> > > >
nXSA9ICdFTic7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgRXhoaV9BdXRoX1NpdGU7ICRHTE9CQUx
> > > >
TWydhdXRoJ10tPmF1dGggPSBhcnJheSgpOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWyd1aWQnXSA
> > > >
9ICdmb3JtJzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSddID0gJyc7ICRHTE9CQUxTWyd
> > > >
hdXRoJ10tPmF1dGhbJ2V4cCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXR
> > > >
oWydyZWZyZXNoJ10gPSAnMjE0NzQ4MzY0Nyc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3VuYW1
> > > > lJ10gPSAnJzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsnZXJyb3InXSA9ICczJzsg',
> > > > '20000913173604')
> > > > MySQL Error: 1062 (Duplicate entry
> > > > 'SITESESSION-df5f9cfe1186902cd397f5ce156d8da9' for key 1)
> > > > Session halted.
> > > >
> > > > Does anyone else have experience of this problem, or is there
something
> > > > really simple thatb I am missing?
> > > >
> > > > Many thanks,
> > > >
> > > > Mikey
> > > >
> > >
> ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> > > > For additional commands, e-mail: phplib-help <email protected>
> > >
> > > --
> > > Mike Green
> > > webmaster <email protected>
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> > > For additional commands, e-mail: phplib-help <email protected>
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> > For additional commands, e-mail: phplib-help <email protected>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected>

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