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

MarcYBB
 
MarcYBB replied on at Permalink Reply
MarcYBB
I figured it out on my own.
MrKDilkington replied on at Permalink Reply
MrKDilkington
HI MarcYBB,

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

thanks
glin425 replied on at Permalink Reply
Would be helpful if you shared the solution with the community......
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
koalasoft
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...