12.0.5 update fails on oc_calendar_repeat ROW_FORMAT = DYNAMIC

ℹ️ Support
1

Nextcloud version 12.0.5
Operating system and version: Ubuntu 16.04
mysql 5.7.21

The issue you are facing:
After I updated to 12.0.5 via the admin interface, nothing works anymore.

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:
I just updated from the admin web ui.

While upgrading from 11.0.6 to 12.0.5 I get

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE `oc_calendar_repeat` ROW_FORMAT = DYNAMIC;': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'startdate'

image
image992×158 11.2 KB

How to fix?

2

The following worked to remediate:
DROP TABLE oc_calendar_repeat;
Then run:
occ upgrade
Then recreate the table:

use owncloud;
CREATE TABLE `oc_calendar_repeat` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `eventid` int(10) unsigned NOT NULL DEFAULT '0',
      `calid` int(10) unsigned NOT NULL DEFAULT '0',
      `startdate` datetime DEFAULT '0000-00-00 00:00:00',
      `enddate` datetime DEFAULT '0000-00-00 00:00:00',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC