[Phplib-trackers] [ phplib-Patches-467598 ] Session: INSERT -> REPLACE INTO

[<no...@so...>]

Patches item #467598, was opened at 2001-10-03 12:23
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=403613&aid=467598&group_id=31885

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Jens S. Benecke (jensb)
Assigned to: Nobody/Anonymous (nobody)
Summary: Session: INSERT -> REPLACE INTO 

Initial Comment:
Hi,

here's another trivial patch - sometimes there are 
duplicate session IDs (i had two in two days) and the 
first is long invalid (not used any more). So instead 
of having a SQL error lets just replace the session - 
it's a hack, but for me it has produced no error in 
almost a year (well, since phplib 7.2 was released ;)

It's trivial, just change the "insert into" in the 
ac_store function (in session.inc) to "replace into":

---------------------------------------------------
$iquery = sprintf("replace into %s ( sid, name, val, 
changed ) values ('%s', '%s', '%s', '%s')",
---------------------------------------------------


-- Jens



----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=403613&aid=467598&group_id=31885