Forum
Perch Update Errors 3.13 to 3.14
I have just upgraded Perch and got the following errors
ALTER TABLE perch2_content_regions
ADD regionPublishRoles
VARCHAR(255) NOT NULL DEFAULT '*' AFTER regionEditRoles
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'regionUpdated' at row 3
Do I accept and continue or is there something I can do about them. My site is still working.
That looks like bad data. Do you have dates set to
0000-00-00 00:00:00
?Yes in the content_region table (created in 2014) 7 of the 30 entries refer to regions which haven't been used for years - these entries all have very different data to the other rows including zero dates and entries such as Undefined Content.
Should I just delete these rows from the database manually?
Probably safer to change the date values to something roughly right.