Upgrading from database version 91 to 92


I want to upgrade the CMS but i get this error when running the db upgrade

“An error occurred running the upgrade. Please take a screen shot of this
page and seek help. Statement number: 92. Error Message =
[SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key
name ‘Type’]. File = [Array]. SQL = [ALTER TABLE stat ADD INDEX Type
(displayID, end, Type)].”

I can’t find why in db


Its adding a missing index that you shouldn’t already have - because you already have it, its failing.

You can edit install/database/92.sql and remove the statement that adds the index.

Oh great, it’s ok, thank you !

1 Like

What did you remove from install/database/92.sql to fix the issue you was having?

Thank you

The above statement would have been removed.

Yes, it was this line

1 Like