Re: [phplib] Problem with sessions, MySQL insert error. From: francis bouchard (fbouchard <email protected>)
Date: 08/07/00

I made those modifications and still have the problem. Although, I am
running on access and ODBC.

This error seems to come from the fact that the record does not get unlocked
from the update statement.

Any updates ???

thanks,
Francis

----- Original Message -----
From: Peter Howard <pjh <email protected>>
To: francis bouchard <fbouchard <email protected>>; Jacob Bower
<jake.b <email protected>>; <phplib <email protected>>
Sent: Thursday, August 03, 2000 2:07 PM
Subject: RE: [phplib] Problem with sessions, MySQL insert error.

> This error did the rounds (again) last week on the list. 7.2c was
supposed
> to
> fix this, but I (like you) still had the problem. But only with MySQL
3.23,
> not MySQL 3.22.
>
> I made the following two changes to ct_sql.inc in the 7.2c distribution:
>
> line 113: from
> && $this->db->f(1) == 0
> to
> && $this->db->nf() == 0
>
> This by itself, instead of fixing it, stopped logging in working at all!
> changing line 85 from:
> $squery = sprintf("select count(*) from %s where val='%s' and
> changed='%s' and sid=
> '%s' and name='%s'",
>
> to
>
> $squery = sprintf("select * from %s where val='%s' and changed='%s'
and
> sid=
> '%s' and name='%s'",
>
> as well as the line 113 change fixed the problem completely. I have no
idea
> why the line 113 change (which seemed correct to me by itself) stuffed up
so
> badly, and why count(*) doesn't seem to return any rows - at least in
MySQL
> 3.23.8
>
> Anyone else have any insights into that behaviour?
>
> PJH
>

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