Multilingual wrecked my site - now cannot add any pages
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: 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,