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!