Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error When Add New Item
05-02-2016, 10:46 PM
Post: #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 File(s) Thumbnail(s)
   
Find all posts by this user
Quote this message in a reply
05-03-2016, 05:51 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)