Multilingual wrecked my site - now cannot add any pages

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,

View Replies:
MarcYBB replied on at Permalink Reply
I figured it out on my own.
MrKDilkington replied on at Permalink Reply

To assist others in the future, can you describe your solution, please.
bayleafmedia replied on at Permalink Reply
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

mbordoni replied on at Permalink Reply
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
koalasoft replied on at Permalink Reply
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.