Xibo CMS stuck in off-line/upgrade mode when upgrading from 3.3.7 to 4.0.1

[flx123]

CMS Version

4.0.1

Installation Method

Docker

Operating System

Ubuntu 22.04

Issue

Xibo CMS stuck in off-line/upgrade mode when upgrading from 3.3.7 to 4.0.1

Related to the last line from logs cms-web, below? If so, I do I fix?

xibocms-cms-web-1 | We will upgrade it, take a backup
xibocms-cms-web-1 | mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces
xibocms-cms-web-1 | Running database migrations
xibocms-cms-web-1 | Phinx by CakePHP - https://phinx.org.
xibocms-cms-web-1 |
xibocms-cms-web-1 | using config file /var/www/cms/phinx.php
xibocms-cms-web-1 | using config parser php
xibocms-cms-web-1 | using migration paths
xibocms-cms-web-1 | - /var/www/cms/db/migrations
xibocms-cms-web-1 | warning no environment specified, defaulting to: production
xibocms-cms-web-1 | using adapter mysql
xibocms-cms-web-1 | using database cms
xibocms-cms-web-1 | ordering by creation time
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20220330111440 ModulesTableVerFourMigration: migrating
xibocms-cms-web-1 | == 20220330111440 ModulesTableVerFourMigration: migrated 0.1017s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20220512130000 AddTwitterConnectorMigration: migrating
xibocms-cms-web-1 | == 20220512130000 AddTwitterConnectorMigration: migrated 0.0087s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20220512155400 RegionTypeMigration: migrating
xibocms-cms-web-1 | == 20220512155400 RegionTypeMigration: migrated 0.0239s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20220520175400 DisplayMediaMigration: migrating
xibocms-cms-web-1 | == 20220520175400 DisplayMediaMigration: migrated 0.1751s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20220903153600 RequiredfileDependencyMigration: migrating
xibocms-cms-web-1 | == 20220903153600 RequiredfileDependencyMigration: migrated 0.1466s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20220915100902 AddFontsTableMigration: migrating
xibocms-cms-web-1 | == 20220915100902 AddFontsTableMigration: migrated 0.1194s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20220928091249 PlayerSoftwareRefactorMigration: migrating
xibocms-cms-web-1 | == 20220928091249 PlayerSoftwareRefactorMigration: migrated 0.1264s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20221124120259 AddLayoutIdToActionTableMigration: migrating
xibocms-cms-web-1 | == 20221124120259 AddLayoutIdToActionTableMigration: migrated 0.0172s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20230118151031 AddAlphaVantageConnectorMigration: migrating
xibocms-cms-web-1 | == 20230118151031 AddAlphaVantageConnectorMigration: migrated 0.0134s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20230130114907 UpdateCampaignDisplayColumnDataTypeMigration: migrating
xibocms-cms-web-1 | == 20230130114907 UpdateCampaignDisplayColumnDataTypeMigration: migrated 0.3438s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20230209132720 AddOpenWeatherMapConnectorMigration: migrating
xibocms-cms-web-1 | == 20230209132720 AddOpenWeatherMapConnectorMigration: migrated 0.0245s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20230214135035 RemoveDoohUserTypeMigration: migrating
xibocms-cms-web-1 | == 20230214135035 RemoveDoohUserTypeMigration: migrated 0.1135s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20230220213618 UpdatePlayListTimelineHelpLinkMigration: migrating
xibocms-cms-web-1 | == 20230220213618 UpdatePlayListTimelineHelpLinkMigration: migrated 0.0135s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20230310143321 SavedReportMoveOutMigration: migrating
xibocms-cms-web-1 | == 20230310143321 SavedReportMoveOutMigration: migrated 0.1213s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20230321105750 AddSchemaVersionWidgetMigration: migrating
xibocms-cms-web-1 | == 20230321105750 AddSchemaVersionWidgetMigration: migrated 0.0231s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20230411090410 AddWidgetCompatibilityTaskMigration: migrating
xibocms-cms-web-1 | == 20230411090410 AddWidgetCompatibilityTaskMigration: migrated 0.0166s
xibocms-cms-web-1 |
xibocms-cms-web-1 | == 20230509113820 ContentSyncMigration: migrating
xibocms-cms-web-1 | PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\x80\x80navL…’ for column ‘actionType’ at row 1 in /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:192

[flx123]

Given the two new cms versions released, figured I’d try again: Rolled back to 3.3.7. Successfully upgraded docker cms to 3.3.8. Unfortunately, upgrade to v4 still fails (this time from 3.3.8 to 4.0.2).

Can anyone help get my version upgrade working, or do I need start over with a clean install of v4?

Thanks.

xibocms-cms-web-1  |  == 20230509113820 ContentSyncMigration: migrating
xibocms-cms-web-1  | PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\x80\x80navL...' for column 'actionType' at row 1 in /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:192
xibocms-cms-web-1  | Stack trace:
xibocms-cms-web-1  | #0 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(192): PDO->exec()
xibocms-cms-web-1  | #1 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Util/AlterInstructions.php(108): Phinx\Db\Adapter\PdoAdapter->execute()
xibocms-cms-web-1  | #2 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(626): Phinx\Db\Util\AlterInstructions->execute()
xibocms-cms-web-1  | #3 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(1001): Phinx\Db\Adapter\PdoAdapter->executeAlterSteps()
xibocms-cms-web-1  | #4 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(477): Phinx\Db\Adapter\PdoAdapter->executeActions()
xibocms-cms-web-1  | #5 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/TimedOutputAdapter.php(420): Phinx\Db\Adapter\AdapterWrapper->executeActions()
xibocms-cms-web-1  | #6 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Plan/Plan.php(151): Phinx\Db\Adapter\TimedOutputAdapter->executeActions()
xibocms-cms-web-1  | #7 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(719): Phinx\Db\Plan\Plan->execute()
xibocms-cms-web-1  | #8 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(627): Phinx\Db\Table->executeActions()
xibocms-cms-web-1  | #9 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(686): Phinx\Db\Table->update()
xibocms-cms-web-1  | #10 /var/www/cms/db/migrations/20230509113820_content_sync_migration.php(71): Phinx\Db\Table->save()
xibocms-cms-web-1  | #11 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(108): ContentSyncMigration->change()
xibocms-cms-web-1  | #12 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(388): Phinx\Migration\Manager\Environment->executeMigration()
xibocms-cms-web-1  | #13 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(359): Phinx\Migration\Manager->executeMigration()
xibocms-cms-web-1  | #14 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(122): Phinx\Migration\Manager->migrate()
xibocms-cms-web-1  | #15 /var/www/cms/vendor/symfony/console/Command/Command.php(298): Phinx\Console\Command\Migrate->execute()
xibocms-cms-web-1  | #16 /var/www/cms/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run()
xibocms-cms-web-1  | #17 /var/www/cms/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
xibocms-cms-web-1  | #18 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(70): Symfony\Component\Console\Application->doRun()
xibocms-cms-web-1  | #19 /var/www/cms/vendor/symfony/console/Application.php(171): Phinx\Console\PhinxApplication->doRun()
xibocms-cms-web-1  | #20 /var/www/cms/vendor/robmorgan/phinx/bin/phinx(28): Symfony\Component\Console\Application->run()
xibocms-cms-web-1  | #21 /var/www/cms/vendor/bin/phinx(119): include('...')
xibocms-cms-web-1  | #22 {main}
xibocms-cms-web-1  | Importing ca-certs
xibocms-cms-web-1  | cp: cannot stat '/var/www/cms/ca-certs/*.pem': No such file or directory
xibocms-cms-web-1  | cp: cannot stat '/var/www/cms/ca-certs/*.crt': No such file or directory
xibocms-cms-web-1  | Updating certificates in /etc/ssl/certs...