I’ve been waiting forever for a migration path from ownCloud to Nextcloud and finally with version 12.0.6 one opened… and very promptly failed.
The server is running on Ubuntu 16.04 server with mysql 5.7.
This is the error, as shown by the nextcloud web interface:
Set log level to debug
Turned on maintenance mode
Updating database schema
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE oc_filecache CHANGE
fileid INT AUTO_INCREMENT NOT NULL, CHANGE
parent INT DEFAULT 0 NOT NULL, CHANGE
mtime INT DEFAULT 0 NOT NULL, CHANGE
storage_mtime INT DEFAULT 0 NOT NULL’: SQLSTATE: Numeric value out of range: 1264 Out of range value for column ‘mtime’ at row 16
The error looks exactly like the one described here: https://github.com/nextcloud/server/issues/8143 only I’m not doing a database migration at all. It also looks like there’s no interest in fixing it before NC14.
Any ideas how I can make the migration happen?
Thank you very much for any assistance.