Re: [phplib] active_session question From: Ronald A. McCormick Jr. (ramccor <email protected>)
Date: 07/20/00

I upgraded to 7.2c and it was working fine until I upgraded from MySQL
3.20.x to 3.22.21 at which point I was getting the message regularly.
There was a work around suggested in early June which I applied to
ct_sql.inc The code that was included in 7.2c looks likee it should have
worked to me, but this snippet was the one that worked. (I do have to
agree with the comments when it was originally sent to the list. It is a
hack, but it works for me)

--- ct_sql.DIST Thu Jul 20 01:52:40 2000
+++ ct_sql.inc Thu Jul 20 02:29:48 2000
@@ -97,6 +97,19 @@
 
     $this->db->query($uquery);
 
+ if ( $this->db->affected_rows() == 0 ) {
+ $now = date("YmdHis", time()) + 1;
+ $uquery = sprintf("update %s set val='%s', changed='%s' where
+ sid='%s' and name='%s'",
+ $this->database_table,
+ $str,
+ $now,
+ $id,
+ $name);
+
+ $this->db->query($uquery);
+ }
+

On 19 Jul 2000, Kristian Koehntopp wrote:

> In netuse.lists.phplib you write:
> >I get this error message on a regular basis.
>
> This problem is supposed to be solved with the change to ct_sql.inc in
> Version 7.2c. Which version are you running?
>
> Kristian
>
>
> ---------------------------------------------------------------------
> 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>