Multilingual wrecked my site - now cannot add any pages
Permalink
Hi C5,
First I have to say that the dual-view site map is TERRIBLE! Most times when it ain't broke, leave it alone. End rant and onto my question:
After adding a 2nd locale and copying the existing language tree, I ended up with 3 home pages and thanks to the dual view couldn't figure out what was what and now when I try to add a page I get this error:
An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID, cIsActive) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["447", null, "12", null, "1", "TEMPLATE", null, 234, 0, 0, 0]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null
I do not have much knowledge of mySQL so if someone could tell me what table needs to be changed and the data that is wrong/missing I would be most grateful.
Thanks in advance,
Marc
First I have to say that the dual-view site map is TERRIBLE! Most times when it ain't broke, leave it alone. End rant and onto my question:
After adding a 2nd locale and copying the existing language tree, I ended up with 3 home pages and thanks to the dual view couldn't figure out what was what and now when I try to add a page I get this error:
An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID, cIsActive) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["447", null, "12", null, "1", "TEMPLATE", null, 234, 0, 0, 0]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null
I do not have much knowledge of mySQL so if someone could tell me what table needs to be changed and the data that is wrong/missing I would be most grateful.
Thanks in advance,
Marc
I figured it out on my own.
HI MarcYBB,
To assist others in the future, can you describe your solution, please.
To assist others in the future, can you describe your solution, please.
Hi Marc,
It's been a while since you posted this but I could use the information you found on how to fix your issue. I am suffering from this issue as well. Same error and cannot create new pages.
I'm running 8.4.0
thanks
It's been a while since you posted this but I could use the information you found on how to fix your issue. I am suffering from this issue as well. Same error and cannot create new pages.
I'm running 8.4.0
thanks
Would be helpful if you shared the solution with the community......
I have the same problem c5 8.4, multilanguage and advanced permissions.
Please post the solution
Please development team fix this bug.
Thanks in advance
Please post the solution
Please development team fix this bug.
Thanks in advance
Please refer to the bug I have found how I fixed it!
I tried to give a concrete example how to produce this and I think this can happen quite easily.
https://www.concrete5.org/developers/bugs/8-5-0/multilingual-setup-l...
I tried to give a concrete example how to produce this and I think this can happen quite easily.
https://www.concrete5.org/developers/bugs/8-5-0/multilingual-setup-l...