CMS Version
2.3.12 upgrading to 3.0.x
Installation Method
Docker
Operating System
Ubuntu 20.04.3 LTS
Issue
Hi,
We just upgraded our Android licenses to v3 but can’t upgrade the CMS to use them.
A migration fails when upgrading our database from 2.3.12 to 3.0.x:
docker-compose logs -f
shows:
cms-web_1 | == 20200604103141 CommandImprovementsMigration: migrating
cms-web_1 | == 20200604103141 CommandImprovementsMigration: migrated 0.2141s
cms-web_1 |
cms-web_1 | == 20200612141755 OauthUpgradeMigration: migrating
cms-web_1 |
cms-web_1 | In PdoAdapter.php line 134:
cms-web_1 |
cms-web_1 | SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'cms.oaut
cms-web_1 | h_access_tokens'
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
We’ve tried upgrading to 3.0.0, .1, .2, and .3 with the same error.
Here’s our upgrade procedure:
cd /opt/xibo
docker-compose down
cd /opt
mv xibo xibo-old
wget https://github.com/xibosignage/xibo-docker/archive/refs/tags/3.0.3.tar.gz
tar -xvf 3.0.3.tar.gz
mv xibo-docker-3.0.3 xibo
cp xibo-old/config.env xibo/
cp -r xibo-old/shared xibo/
cd xibo
docker-compose up -d
We have not modified docker-compose.yml which is why we’re not migrating it.
Previous upgrades within 2.x have worked well. Are we missing anything regarding the 3.x upgrade?
We are using the recommended Docker setup. The only “odd” thing I can think of in our setup is that we used to host the database remotely on MariaDB. We imported it into Xibo’s MySQL 5.7 a few versions ago using the shared/backup/import.sql procedure and it’s been working fine.
Here’s the full output of docker-compose logs -f
: Attaching to xibo_cms-web_1, xibo_cms-db_1, xibo_cms-memcached_1, xibo_cms-quick - Pastebin.com
We’re happy to upload the database to Xibo staff if that’d help troubleshoot.