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
 
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
great replied on at Permalink Reply
Hi
I have a website with multilingual.
I upgraded to 8.3.2 and now website is not working anymore...
PLEASE HELP!!!! What do I need to do???
webpresso replied on at Permalink Reply
webpresso
great

You should open a new thread and give some more informations.
I hope you have done the upgrade on a test site first. If not I reccommend to roll back to your previous version with a backup.