multilingual site error after upgrade to 8.2

Permalink
I'm upgrading a multilingual site from 5.7.5.13 to 8.2.1, but the upgrade stops with the following error:
An exception occurred while executing 'ALTER TABLE MultilingualPageRelations ADD PRIMARY KEY (mpRelationID, cID)': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '111-0' for key 'PRIMARY'


Can someone help me to get passed this error and finish my upgrade?

buurvrouw
View Replies: View Best Answer
buurvrouw replied on at Permalink Reply
buurvrouw
Anyone? Please...
A3020 replied on at Permalink Reply
A3020
What I'd do is checking the MultilingualPageRelations table *before* the upgrade starts. Then sort on the `cID` column and remove all records that have `0` as a value.

Why? I think there shouldn't exist any pages with a collection id that is 0.

Make sure you perform a backup first ;)
buurvrouw replied on at Permalink Reply
buurvrouw
This worked, thank you so much!!!
mlocati replied on at Permalink Best Answer Reply
mlocati
https://github.com/concrete5/concrete5/pull/6070 should fix this issue
buurvrouw replied on at Permalink Reply
buurvrouw
And yes, this works!
webpresso replied on at Permalink Reply
webpresso
I have the same error. I have tried to update from 5.7.5.13 directly to 8.3.2. Should I first update to 8.2.1?

Error Message:
An exception occurred while executing 'ALTER TABLE MultilingualPageRelations ADD PRIMARY KEY (mpRelationID, cID)': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59-289' for key 'PRIMARY'
mlocati replied on at Permalink Reply
mlocati
No: you should upgrade to the latest version.

In order to solve your issue, I need to know the stack trace (that is, all the function calls that lead to the error).
mlocati replied on at Permalink Reply
mlocati
https://github.com/concrete5/concrete5/pull/6365 should fix this issue