webERP Forum

Full Version: Error When Add New Item
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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]
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/...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
Reference URL's