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
People
Owner: Nobody in particular
Requestors: dekimsey [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 4.40
Fixed in: (no value)

History Show all quoted text
  Fri Feb 27 09:14:36 2009 dekimsey [...] gmail.com - Ticket created
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.
  Mon Mar 09 00:44:11 2009 RSAVAGE [...] cpan.org - Correspondence added
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).
  Mon Mar 09 00:44:12 2009 The RT System itself - Status changed from 'new' to 'open'
  Mon Mar 09 00:45:29 2009 RSAVAGE [...] cpan.org - Correspondence added
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.
  Mon Mar 09 00:45:30 2009 RSAVAGE [...] cpan.org - Status changed from 'open' to 'resolved'