I’ve upgraded to mySQL 5.0, and it’s gone pretty smoothly except that on
DateTime.now doesn’t seem to return a value that mySQL likes any more,
as seen in the following exception:
Incorrect datetime value: ‘2005-11-20T15:33:12-0800’ for column
‘logged_at’ at row 1: UPDATE notes SET due_on
= ‘2005-11-20’,
created_at
= ‘2005-11-20 15:33:12’, deleted
= 0, user_name
=
‘steve’, labels
= NULL, job_name
= NULL, domain_controller
= NULL,
domain_id
= NULL, contact_name
= NULL, customer_id
= NULL,
logged_at
= ‘2005-11-20T15:33:12-0800’, user_id
= 2, is_log
= 0,
contact_id
= NULL, vendor_id
= NULL, job_id
= NULL, subject
=
‘test’, customer_name
= NULL WHERE id = 8
what is that strange datetime value, anyway? the
one it’s trying to store looks like this:
‘2005-11-20T15:33:12-0800’
the DateTime that Rails generates automatically for updated_at looks
like this:
‘2005-11-20 15:33:12’
Does anyone know what’s going on here?
I’ve searched and have come up with zilch so far.