1.8rc-2 Upgrade From rc-1 Error

Developer Experience
1

I got the following when attempting to upgrade from RC-1 to RC-2:

An error occurred populating the database. Statement number: 35. 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].

2

Did you solve it? What method did you use to upgrade?

3

I have not solved it. I just reverted back to RC-1 for now.

The code that produces this is lnie 26-28 in install/steps/125.json

{
“step”: “Add oAuth Client/Scope link table”,
“action”: “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;”
},

I think if you rem those lines out, it may continue.

4

It shouldn’t be running that file at all - 125 is an upgrade file from 1.8.0-beta.

Before you run the upgrade, can you check in the version table of the DB and see what is reported?

5 
app_ver    XmdsVersion    XlfVersion    DBVersion
1.8.0-rc1  5              2             128
6

@Dan,

Any idea as why I received the error? Seems like it should not had run the 125 upgrade steps.

I will try again and see if I get the same out come.

7

It should only run the actions in 129.json - it calculates the difference between the current DB version (128) and the Code DB version (129).