Some how I have 2 columns with incorrect default values. Not sure how it got created in the first place as I imported the db from another source.
Problem now is, I cannot make any changes to the table cause MYSQL will complain:
MySQL said: Invalid default value for 'campaign_start_date'
if I tried adding a column.
But when I try changing the
DEFAULT VALUE to
campaign_start_date, it complains
campaign_end_date has an invalid default value.
So I'm stuck in a loop that doesn't allow me to make any changes to the table.
Is there anyway to fix this?