https://www.machform.com/forums/ MachForm Community Forums Topic: Query failed on update en Sat, 19 Sep 2026 20:21:38 +0000 https://www.machform.com/forums/topic/query-failed-on-update#post-11708 Mon, 28 Mar 2011 12:38:06 +0000 Saghalie 11708@https://www.machform.com/forums/ <p>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.</p> <p>With strict mode disabled, invalid dates such as '2004-04-31' are converted to '0000-00-00' and a warning is generated.</p> <p>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.</p> <p>Regards,</p> <p>Saghalie<br /> <a href="http://www.kcmhosting.com" rel="nofollow">http://www.kcmhosting.com</a> </p> https://www.machform.com/forums/topic/query-failed-on-update#post-11704 Sun, 27 Mar 2011 23:32:05 +0000 mohdaffandidinkamar 11704@https://www.machform.com/forums/ <p>... and how am I going to check on that? Or how can change the date setting? Is it in MySQL setting? </p> https://www.machform.com/forums/topic/query-failed-on-update#post-11680 Fri, 25 Mar 2011 13:19:11 +0000 Saghalie 11680@https://www.machform.com/forums/ <p>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).</p> <p>Saghalie<br /> <a href="http://www.kcmhosting.com" rel="nofollow">http://www.kcmhosting.com</a> </p> https://www.machform.com/forums/topic/query-failed-on-update#post-11655 Tue, 22 Mar 2011 08:46:59 +0000 mohdaffandidinkamar 11655@https://www.machform.com/forums/ <p>Thanks Saghalie, but I've check the time setting and its set fine.</p> <p>- FND </p> https://www.machform.com/forums/topic/query-failed-on-update#post-11652 Mon, 21 Mar 2011 09:28:54 +0000 Saghalie 11652@https://www.machform.com/forums/ <p>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.</p> <p>Check your settings.</p> <p>Regards,</p> <p>Saghalie<br /> <a href="http://www.kcmhosting.com" rel="nofollow">http://www.kcmhosting.com</a> </p> https://www.machform.com/forums/topic/query-failed-on-update#post-11648 Sun, 20 Mar 2011 00:22:50 +0000 mohdaffandidinkamar 11648@https://www.machform.com/forums/ <p>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"</p> <p>- FND </p> https://www.machform.com/forums/topic/query-failed-on-update#post-11632 Fri, 18 Mar 2011 16:44:40 +0000 mohdaffandidinkamar 11632@https://www.machform.com/forums/ <p>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.</p> <p>Is there any other work around on this? </p> https://www.machform.com/forums/topic/query-failed-on-update#post-11496 Sat, 26 Feb 2011 01:11:02 +0000 rmagnuson 11496@https://www.machform.com/forums/ <p>Thanks Yuniar, strict mode was indeed the problem. It seems to be saving properly now.</p> <p>-Rafe Magnuson </p> https://www.machform.com/forums/topic/query-failed-on-update#post-11491 Fri, 25 Feb 2011 19:34:00 +0000 yuniar 11491@https://www.machform.com/forums/ <p>One possible cause is the MySQL on your server is running under strict mode.<br /> You can find the solution for this here:<br /> <a href="http://www.appnitro.com/forums/topic/mail-error?replies=4#post-1572" rel="nofollow">http://www.appnitro.com/forums/topic/mail-error?replies=4#post-1572</a></p> <p>Otherwise, if the MySQL is not running under strict mode, there must be something else.<br /> We'll need to check it directly for this.</p> <p>Please contact us directly if you need direct assistance on this.<br /> You can use the contact page below </p> https://www.machform.com/forums/topic/query-failed-on-update#post-11484 Fri, 25 Feb 2011 09:08:16 +0000 rmagnuson 11484@https://www.machform.com/forums/ <p>Getting the following when submitting an edit to an entry:</p> <p>Query failed: Incorrect date value: '' for column 'element_8' at row 1</p> <p>I see there have been similar posts in the forum but nothing specific to the date field being empty. </p>