To be completed by the original poster:
CMS Version
2.3.4 upgrading from 1.8.13
Installation Method
Docker
Operating System
Ubuntu 18.04 LTS
Issue
I attempted to perform a Xibo CMS upgrade from 1.8.13 to 2.3.4 using the same method we’ve used in the past for jumping through patch versions. This time, the upgrade seemed to succeed running docker-compose -f cms_remote-mysql.yml up -d
but when I navigated to the web interface, it says:
The CMS is temporarily off-line as an upgrade is in progress. Please check with your system administrator for updates or refresh your page in a few minutes.
I took a look at the cms-web log. Everything seems to be working OK, up until then end:
cms-web_1 | == 20180131114114 OldUpgradeStep133Migration: migrating
cms-web_1 | == 20180131114114 OldUpgradeStep133Migration: migrated 0.0028s
cms-web_1 |
cms-web_1 | == 20180131114118 OldUpgradeStep134Migration: migrating
cms-web_1 | == 20180131114118 OldUpgradeStep134Migration: migrated 0.0028s
cms-web_1 |
cms-web_1 | == 20180131114123 OldUpgradeStep135Migration: migrating
cms-web_1 | == 20180131114123 OldUpgradeStep135Migration: migrated 0.0021s
cms-web_1 |
cms-web_1 | == 20180131122645 OneRegionPerPlaylistMigration: migrating
cms-web_1 |
cms-web_1 | In PdoAdapter.php line 134:
cms-web_1 |
cms-web_1 | SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0
cms-web_1 | 000-00-00 00:00:00' for column 'createdDt' at row 1
cms-web_1 |
cms-web_1 |
cms-web_1 | migrate [-c|--configuration CONFIGURATION] [-p|--parser PARSER] [-e|--environment ENVIRONMENT] [-t|--target TARGET] [-d|--date DATE] [-x|--dry-run]
cms-web_1 |
cms-web_1 | Importing ca-certs
cms-web_1 | cp: can't stat '/var/www/cms/ca-certs/*.pem': No such file or directory
cms-web_1 | cp: can't stat '/var/www/cms/ca-certs/*.crt': No such file or directory
cms-web_1 | WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping
cms-web_1 | Setting up Quickchart
cms-web_1 | Configuring Maintenance
cms-web_1 | Removing web/install/index.php from production container
cms-web_1 | Starting cron
cms-web_1 | Starting webserver
cms-web_1 | AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 172.25.0.4. Set the 'ServerName' directive globally to suppress this message
Is the SQLSTATE[22007]: Invalid datetime format error at the crux of the issue? If so, how do I fix it?
Thanks in advance!