Incorrect datetime value
4 posts by 4 authors in: Forums > CMS Builder
Last Post: June 24, 2010 (RSS)
By Moonworks - June 24, 2009
In the field editor, I keep getting an error message saying:
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.
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.
High quality residential training for writers, actors & Film Making - Click Here for further information
Re: [Moonworks] Incorrect datetime value
By ross - June 25, 2009
Hi there
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!
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/
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
Did this ever get resolved? I just installed the latest version of CMS builder and I'm getting the following error:
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 [:(]
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
Hi zakcoop,
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]
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]
All the best,
Chris
Chris