Forum

Thread tagged as: Question, Installation

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.

cow shed

cow shed 0 points

  • 3 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

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?

Drew McLellan

Drew McLellan 2638 points
Perch Support

Probably safer to change the date values to something roughly right.