#1374: Exception in AgaviMysqlSessionStorage::sessionWrite() if no data modified
on update
---------------------+------------------------------------------------------
Reporter: david | Owner: david
Type: defect | Status: new
Priority: normal | Milestone: 1.0.5
Component: storage | Version: 1.0.4
Severity: normal | Keywords:
Has_patch: 0 |
---------------------+------------------------------------------------------
Also see #1361, where it's explained a bit more:
This happens whenever no data in the session was changed, and the write
occurs within the same second as the previous update or insert. Then, the
ID, data and time will all be identical to what is already in the
database, causing MySQL to report no updated rows. The session handler
then assumes that the record for this session does not exist and attempts
an insert, which causes an error since the ID column is a primary key (or
at least it should be).
Unlike for the other generic PDO storage, we can utilize {{{INSERT … ON
DUPLICATE KEY UPDATE …}}} here.
--
Ticket URL: <http://trac.agavi.org/ticket/1374>
Agavi <http://www.agavi.org/>
An MVC Framework for PHP5
_______________________________________________
Agavi Tickets Mailing List
[email protected]
http://lists.agavi.org/mailman/listinfo/tickets
