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:
Can someone help me to get passed this error and finish my upgrade?
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?
Anyone? Please...
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 ;)
Why? I think there shouldn't exist any pages with a collection id that is 0.
Make sure you perform a backup first ;)
This worked, thank you so much!!!
https://github.com/concrete5/concrete5/pull/6070 should fix this issue
And yes, this works!
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'
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'
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).
In order to solve your issue, I need to know the stack trace (that is, all the function calls that lead to the error).
https://github.com/concrete5/concrete5/pull/6365 should fix this issue
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???
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???
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.
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.