SQL issue when upgrading

Im getting the following error when trying to go from version 1.6.4 to 1.7.0.

An error occurred running the upgrade. Please take a screen shot of this page and seek help. Statment number: 80. Error Message = [SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘isSystem’ in ‘where clause’]

Upgrading from database version 72 to 84

Does anyone have a work around or something?

The first thing to try is to restore your backup and upgrade to the latest 1.7 release (1.7.7 at the time of writing) - any issues with the upgrade steps we’ve found in the meantime will be fixed.

Ok so I downloaded the current versjon (1.7.7) and got an error that says the same, but also have som more info.

The isSystem column has been part of the Xibo database schema since the first version and is removed in database version 80 (1.7.0-alpha).

At this point I think its highly likely that you have a partial upgrade - i.e. your database upgraded part way through and then failed. You are now trying to upgrade a corrupted database.

Please can you restore your pre-upgrade backup and try again with the latest version?

Oh…I really hope the DB is not currupted…but Im starting to think something has gone wrong some where on the 3 year long road. I now get this error message:

Still statment 80, but the rest is diffrent.Not good?

I am sure you are running the upgrade over a database that has already been part upgraded… you will need to revert to your pre-upgrade backup and run the upgrader again to find out the root cause of the failure.

I suppose the follow on question is - do you have a backup ? :frowning:

Yes, we have a backup, but it looks like the part upgrade has happend earlyer than we have backups from. The solution for us is now to start a new fresh database instead.

Thanks for your help :slight_smile:

Sorry :frowning:

We might be able to manually repair it for you as a support indicent - if you’re interest please contact support@springsignage.com