Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error When Add New Item
05-02-2016, 10:46 PM,
Error When Add New Item
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 "


Attached Files Thumbnail(s)
05-03-2016, 05:51 AM,
RE: Error When Add New Item
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 ( 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)


Forum Jump:

Users browsing this thread: 1 Guest(s)