#1067 - Invalid default value for 'created'

Hello everyone!

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

Well I figured what the problem was, accepted values start at 1000-01-01

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?

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.