To be completed by the original poster:
2.3.4 upgrading from 1.8.13
Ubuntu 18.04 LTS
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: 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: Invalid datetime format error at the crux of the issue? If so, how do I fix it?
Thanks in advance!