webERP Forum
Error When Add New Item - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Installation Issues (/forumdisplay.php?fid=13)
+--- Thread: Error When Add New Item (/showthread.php?tid=2744)



Error When Add New Item - alan.cheong - 05-02-2016 10:46 PM

Hi everyone,
kindly advise if anyone face the error when insert new item after a new installation.

The error as following :

" Incorrect date value: '0000-00-00' for column 'lastcostupdate' at row 1 "

[/php]


RE: Error When Add New Item - falkoner - 05-03-2016 05:51 AM

I think this is due to a problem that I have brought up many times over the last decade or more. Mysql runs in many different modes and I have suggested many times that we should standardise on a particular mode.

One of these modes is NO_ZERO_DATE (https://dev.mysql.com/doc/refman/5.5/en/sql-mode.html#sqlmode_no_zero_date) which prohibits the use of 0000-00-00 as a date. I am going to guess that this is how your mysql server is set up. The solution depends on how much control you have on your server (eg is it hosted by a third party or not)

Tim