MantisBT - ATutor
View Issue Details
0003330ATutorUpgradingpublic2008-03-13 07:312008-08-21 08:56
harris 
harris 
normalmajoralways
closedfixed 
 
1.6.1 
SVN
0003330: Timestamp updated during UTF8 conversion
http://www.atutor.ca/forums/view.php?fid=3;pid=13090;f=40 [^]
No tags attached.
Issue History
2008-03-13 07:31harrisNew Issue
2008-03-13 07:31harrisAffects version => SVN
2008-03-13 07:33harrisNote Added: 0002803
2008-03-13 08:31harrisNote Added: 0002804
2008-03-13 08:50harrisSeverityminor => major
2008-03-13 08:50harrisStatusnew => assigned
2008-03-13 08:50harrisAssigned To => harris
2008-03-13 08:51harrisStatusassigned => resolved
2008-03-13 08:51harrisFixed in Version => 1.6.1
2008-03-13 08:51harrisResolutionopen => fixed
2008-03-13 08:51harrisNote Added: 0002805
2008-08-21 08:56gregStatusresolved => closed

Notes
(0002803)
harris   
2008-03-13 07:33   
The cause lies in the table column attribute: 'ON UPDATE CURRENT_TIMESTAMP'

Each successful 'update' (by successful, it means the SQL returns Affected: >0 after an update) will trigger that clause, and update the timestamp to CURRENT_TIMESTAMP (aka NOW()).

ps. Triggers also in REPLACE.
(0002804)
harris   
2008-03-13 08:31   
update ... SET timestamp=old_timestamp during conversion
(0002805)
harris   
2008-03-13 08:51   
7338