php,  phpmyadmin

#1067 – Invalid default value for ‘time’ – solution

when altering the database table error displays – 1067 – Invalid default value for ‘time’

Solution is : There might be a datetime field with Null and default value 0000-00-00 00:00:00.

change the datetime field Null uncheck and default value None

change the date time field default value to none and uncheck NULL

Thus you can alter the database now for other field add, remove and further operations.

Leave a Reply

Your email address will not be published. Required fields are marked *