Trouble running upgrade wizard from 1.7.5 (XAMPP) to 1.8.2 (Docker)

Hi all,

I’m in the process of upgrading from 1.7.5 to 1.8.2. My original config was running on Ubuntu x64 14.04 LTS with XAMPP 5.6.14-4. I have migrated to a test machine with the same version of Ubuntu, however I am using Docker 17.06.2-ce and have followed the Xibo guides (Switch to Docker and Docker on Linux). After some fiddling I was able to get Docker installed, my data migrated from the old install, composing the Xibo Docker instance and being able to login to the Xibo web interface. I am currently at the upgrade wizard and am having issues. I ran into the same issue as in this post, getting stuck on the same step even (141). I followed the same advice & skipped the step. I hit several other steps that had similar errors (typically they indicated a duplicate key, column, row, etc); specifically steps 198, 203, 209, 211, 213, 215*, 216, 218, 222, 223, & 232.

However, step 233 gives the error, “SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘LastPage’; check that column/key exists”.

Any advice would be greatly appreciated.

I would upgrade to 1.7.9 first, and then attempt a 1.8.2 upgrade.

That’s the most tested route.