Xibo CMS for Docker upgrade 1.8 to 2.3: "SQLSTATE[22007]: Invalid datetime format"

To be completed by the original poster:

CMS Version

2.3.4 upgrading from 1.8.13

Installation Method


Operating System

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[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 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!

The Xibo Community site uses cookies. What are cookies?