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

Report information
The Basics
Id:
43704
Status:
resolved
Priority:
Low/Low
Queue:

People
Owner:
Nobody in particular
Requestors:
dekimsey [...] gmail.com
Cc:
AdminCc:

BugTracker
Severity:
Normal
Broken in:
4.40
Fixed in:
(no value)



Subject: driver::mysql's store fails when using foreign constraints on a session table
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.
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).
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 runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.