MantisBT - ATutor
View Issue Details
0002798ATutor- no cat -public2006-10-30 11:002006-11-20 05:04
user2 
user2 
normalminoralways
closedfixed 
 
1.5.3.3 
SVN
0002798: timestamp
convert all datetime (and possibly some date) fields to timestamps.
No tags attached.
parent of 0000996closed user2 floating time stamp 
txt timestamps.txt (1,610) 2006-11-01 07:18
http://www.atutor.ca/atutor/mantis/file_download.php?file_id=25&type=bug
Issue History
2006-10-30 11:00user2New Issue
2006-10-30 11:00user2Affects version => SVN
2006-10-30 11:00user2Relationship addedparent of 0000996
2006-10-30 11:18user2Note Added: 0002232
2006-10-30 11:20user2Note Added: 0002233
2006-11-01 07:18user2File Added: timestamps.txt
2006-11-01 07:21user2Statusnew => resolved
2006-11-01 07:21user2Fixed in Version => 1.5.4
2006-11-01 07:21user2Resolutionopen => fixed
2006-11-01 07:21user2Assigned To => user2
2006-11-20 05:04user2Statusresolved => closed

Notes
(0002232)
user2   
2006-10-30 11:18   
from 4.1.1 on --sql-mode=MAXDB must be disabled (if enabled TIMESTAMP is identical to DATETIME) when the tables are created.

pre 4.1.2 all updates to a row will update the TIMESTAMP field, including initial inserts, unless a non-null value is specified.

from 4.1.2 on table field created with DEFAULT CURRENT_TIMESTAMP with no ON UPDATE results in the field not being updated when the row updates.

from 4.1.3 time zone can be specified per connection.
(0002233)
user2   
2006-10-30 11:20   
for all versions set the timestamp field to itself avoids updating.