Incorrect datetime value
4 posts by 4 authors in: Forums > CMS Builder
Last Post: June 24, 2010 (RSS)
By Moonworks - June 24, 2009
There was an error changing the MySQL Column, the error was:
Incorrect datetime value: '' for column 'next_date' at row 1
I'm trying to make a field available for date only, but as soon as I select this option from the drop-down menu, it won't let me save, even if I don't change the default options.
Re: [Moonworks] Incorrect datetime value
By ross - June 25, 2009
Thanks for posting!
I'll need to take a closer look at this one for you. Could you send me an email through consulting@interactivetools.com with FTP details to your server and a link to this post?
Thanks!
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/
Re: [ross] Incorrect datetime value
By zakcoop - June 24, 2010
MySQL Error: Incorrect datetime value: '2010-06-31 20:45:00' for column 'event_date_and_time' at row 1
All I did was set up a date/time field using the built-in options, so I'm not sure what would be causing this.
Help - please [:(]
Re: [zakcoop] Incorrect datetime value
By Chris - June 24, 2010 - edited: June 24, 2010
I'm not sure what happened with the previous issue, but please fill out a second level support request and we'll figure this one out for you.
[url http://www.interactivetools.com/support/]http://www.interactivetools.com/support/[/url]
Chris