RE: Fwd: Help with Timestamp invalid value error

2009-09-04 Thread Gavin Towey
ginal Message- > From: Proemial > Sent: Friday, September 04, 2009 3:39 PM > To: mysql@lists.mysql.com > Subject: Fwd: Help with Timestamp invalid value error > > Currently set to: > NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Re: Fwd: Help with Timestamp invalid value error

2009-09-04 Thread Proemial
(0)7812 451238 > Email j...@butterflysystems.co.uk > > Certified MySQL 5 Database Administrator (CMDBA) > Certified MySQL 5 Developer > Cognos BI Developer > > --- > Sent from HP IPAQ mobile device. > > > > -Original Message----- > From: Proemial

RE: Fwd: Help with Timestamp invalid value error

2009-09-04 Thread John Daisley
s.mysql.com Subject: Fwd: Help with Timestamp invalid value error Currently set to: NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION On Fri, Sep 4, 2009 at 10:24 AM, John Daisley wrote: > What is your sql_mode set to? > > I tried inserting that value int

Fwd: Help with Timestamp invalid value error

2009-09-04 Thread Proemial
Currently set to: NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION On Fri, Sep 4, 2009 at 10:24 AM, John Daisley wrote: > What is your sql_mode set to? > > I tried inserting that value into a timestamp column on our test server and > it works fine. > > Regards