Appnitro Software Forums » MachForm 2

Query failed on update

Started 1 year ago by rmagnuson | 10 posts |


  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 1 year 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 1 year ago #

  3. rmagnuson
    Member

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

    -Rafe Magnuson

    Posted 1 year 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 1 year 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 1 year 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 1 year ago #

  7. mohdaffandidinkamar
    Member

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

    - FND

    Posted 1 year 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 1 year 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 1 year 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 1 year ago #

RSS feed for this topic

Reply