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.