MySQL TimeStamp error

2009-12-21 Thread Stefan Richter
Some of you may have encountered the following error with date/time fields in MySQL: Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 7 to TIMESTAMP. This is usually resolved by adding the following to the advanced Datasource settings under 'Connection

Re: MySQL TimeStamp error

2009-12-21 Thread James Holmes
Which month is the zero'th month? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/12/21 Stefan Richter ste...@flashcomguru.com: Some of you may have encountered the following error with date/time fields in MySQL: Error Executing Database Query.

Re: MySQL TimeStamp error

2009-12-21 Thread Dave Watts
Some of you may have encountered the following error with date/time fields in MySQL: Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 7 to TIMESTAMP. This is usually resolved by adding the following to the advanced Datasource settings under