MachForm Community Forums » MachForm 2

1. rmagnuson
   Member

   Getting the following when submitting an edit to an entry:

   Query failed: Incorrect date value: '' for column 'element_8' at row 1

   I see there have been similar posts in the forum but nothing specific to the date field being empty.

   Posted 14 years ago #
2. 

   yuniar

   One possible cause is the MySQL on your server is running under strict mode.
   You can find the solution for this here:
   http://www.appnitro.com/forums/topic/mail-error?replies=4#post-1572

   Otherwise, if the MySQL is not running under strict mode, there must be something else.
   We'll need to check it directly for this.

   Please contact us directly if you need direct assistance on this.
   You can use the contact page below

   ---

   MachForm Founder

   Posted 14 years ago #

3. rmagnuson
   Member

   Thanks Yuniar, strict mode was indeed the problem. It seems to be saving properly now.

   -Rafe Magnuson

   Posted 14 years ago #

4. mohdaffandidinkamar
   Member

   My site is hosted on shared server so the provider can't disable strict mode just for my account as the server has common ini file for all the accounts.

   Is there any other work around on this?

   Posted 14 years ago #

5. mohdaffandidinkamar
   Member

   And I've tried redownload the new package and update email_settings.php file as suggested. Doesn't work. My exact problem is "Query failed: Incorrect date value: '' for column 'element_5' at row 1"

   - FND

   Posted 14 years ago #

6. Saghalie
   Pro Member

   That has to do with your server time settings. You're either "in the future" ie. your clock is set to some time in the future maybe 4/20/2012 (or something like that), or you're 'in the past' ie. your clock is set to some time in the past maybe 1 January 1900.

   Check your settings.

   Regards,

   Saghalie
   http://www.kcmhosting.com

   Posted 14 years ago #

7. mohdaffandidinkamar
   Member

   Thanks Saghalie, but I've check the time setting and its set fine.

   - FND

   Posted 14 years ago #

8. Saghalie
   Pro Member

   Hmmm, maybe the configuration settings has a date setting not compatible with your date format? i.e. date settings in the configuration is Month/Day/Year and your system is set for Year/Month/Day (or something like that).

   Saghalie
   http://www.kcmhosting.com

   Posted 14 years ago #

9. mohdaffandidinkamar
   Member

   ... and how am I going to check on that? Or how can change the date setting? Is it in MySQL setting?

   Posted 14 years ago #

10. Saghalie
    Pro Member

    I was just reading through the other posts and noticed that strict mode is enabled. Try and get your ISP to run the MySQL server with the 'Allow Invalid Dates' switch.

    With strict mode disabled, invalid dates such as '2004-04-31' are converted to '0000-00-00' and a warning is generated.

    Otherwise, you might have to get some special help from Yuniar, send an email to their support and they can help you more than I.

    Regards,

    Saghalie
    http://www.kcmhosting.com

    Posted 14 years ago #

RSS feed for this topic

Reply

You must log in to post.