I had already tried that, actually. Produces the same error. I should have mentioned that as well, sorry!
The version is 5.1.34 thanks for the help, btw! Martin On Fri, Sep 4, 2009 at 11:14 AM, John Daisley<j...@butterflysystems.co.uk> wrote: > Is your table innodb? If so i think the 'STRICT_TRANS_TABLES' sql_mode 'may' > be causing the problem. > > Try inserting the value as.... > > '2008-03-09 02:56:34.737' > > Do you get the same error? > > What mysql version is your server? > > > > Regards > > John Daisley > Mobile +44(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 <proem...@gmail.com> > 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 > > On Fri, Sep 4, 2009 at 10:24 AM, John > Daisley<j...@butterflysystems.co.uk> 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 >> >> John Daisley >> Mobile +44(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. >> >> >> > > > [The entire original message is not included] > -- --- This is a signature. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
