Skip Menu |

This queue is for tickets about the CGI-Session CPAN distribution.

Report information
The Basics
Id: 43704
Status: resolved
Priority: 0/
Queue: CGI-Session

Owner: Nobody in particular
Requestors: dekimsey [...]

Bug Information
Severity: Normal
Broken in: 4.40
Fixed in: (no value)

Subject: driver::mysql's store fails when using foreign constraints on a session table
Download (untitled) / with headers
text/plain 237b
If the session table has foreign key constraints in the database, the store subroutine fails as it uses the sql "REPLACE INTO" which actually performs a delete internally. It'd probably be better to use "UPDATE TABLE" syntax instead.
Download (untitled) / with headers
text/plain 395b
Hi dekimsey The source code you are looking at is obsolete. Here's a part of the Changes file: 4.33 - Monday, July 7, 2008 * FIX: Patch CGI::Session::Driver::mysql to replace 'REPLACE INTO ...' with 'INSERT INTO ... ON DUPLICATE KEY UPDATE ...'. See RT#37069. You could not be having this problem with V 4.40 as you reported. I'll change the status of this to Not a bug (i.e. resolved).
Download (untitled) / with headers
text/plain 137b
The version of the source code used by dekimsey was older that V 4.33, when this problem was fixed, so it can't be a problem with V 4.40.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to