tlacaelelrl — 2012-05-01T17:34:57-04:00 — #1
I am trying to run a query and am getting this error #1067 - Invalid default value for 'created' and this is the line where the error occurs
created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
Can someone point me what I am doing wrong
tlacaelelrl — 2012-05-01T18:02:35-04:00 — #2
Well I figured what the problem was, accepted values start at 1000-01-01
r937 — 2012-05-01T21:21:29-04:00 — #3
why would you want a "created" column to default to 0000-00-00?
it shouldn't be that hard to assign the current date and time to it
what do you actually need here? can i see your INSERT statement?
tlacaelelrl — 2012-05-02T01:22:11-04:00 — #4
I don't have the insert statement but it will insert current date time, that was not my problem, my problem was when adding the tables to the database but it is done, thank you.