DB error when upgrading xibo

Hi,

While trying to upgrade xibo I receive this error:

An error occurred populating the database. Statement number: 36. Error Message = [SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘oauth_client_scopes’ already exists]. File = [structure.sql]. SQL = [CREATE TABLE oauth_client_scopes( clientId varchar(254) NOT NULL, scopeId varchar(254) NOT NULL, id int PRIMARY KEY AUTO_INCREMENT ) ENGINE=InnoDB DEFAULT CHARSET=utf8].

Any ideas?

Between what versions have you ran the upgrade please?

I tried 1.7.9 to 1.8.2, then I tried to upgrade from 1.7.9 to 1.8.0

It looks to me like you’re trying to install 1.8 in to your 1.7 database (the structure.sql file isn’t used on an upgrade).

You need to restore your pre-upgrade backup of 1.7.9, and then upgrade using the upgrade routine, rather than trying to install a fresh install in to an existing database.

How do I do that?

I have taken a copy of my original database and tried to run the upgrade.

You would restore your pre-upgrade backup, so the database is back at v1.7.9, then extract your 1.8.2 files, and copy the settings.php from 1.7.9 install in to the web/ folder of your 1.8 install. Then browse to the webpage, and it will give you a login prompt, and then take you through to the upgrade. The process is detailed in the release notes.