#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

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