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

[/php]


Attached Files Thumbnail(s)
   
Reply
05-03-2016, 05:51 AM,
#2
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 (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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)