Error when creating new page from versions interface
Permalink
Hi,
I am trying to duplicate a specific page using Versions (both from sitemap and from within the page itself). This page houses an html block which I suspect is causing the issue. I do not understand what this error is telling me. Does anyone know by glancing over it what the system thinks is wrong?
This is the error presented after clicking "New Page":
[code]{"error":{"message":"An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cInheritPermissionsFrom, cFilename, cPointerID, cPointerExternalLink, cPointerExternalLinkNewWindow, cDisplayOrder, pkgID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"622\", null, \"6\", null, \"2\", \"1\", 1, \"PARENT\", null, 0, null, \"0\", \"26\", \"0\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null"},"errors":["An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cInheritPermissionsFrom, cFilename, cPointerID, cPointerExternalLink, cPointerExternalLinkNewWindow, cDisplayOrder, pkgID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"622\", null, \"6\", null, \"2\", \"1\", 1, \"PARENT\", null, 0, null, \"0\", \"26\", \"0\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null"]}[\code]
I am trying to duplicate a specific page using Versions (both from sitemap and from within the page itself). This page houses an html block which I suspect is causing the issue. I do not understand what this error is telling me. Does anyone know by glancing over it what the system thinks is wrong?
This is the error presented after clicking "New Page":
[code]{"error":{"message":"An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cInheritPermissionsFrom, cFilename, cPointerID, cPointerExternalLink, cPointerExternalLinkNewWindow, cDisplayOrder, pkgID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"622\", null, \"6\", null, \"2\", \"1\", 1, \"PARENT\", null, 0, null, \"0\", \"26\", \"0\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null"},"errors":["An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cInheritPermissionsFrom, cFilename, cPointerID, cPointerExternalLink, cPointerExternalLinkNewWindow, cDisplayOrder, pkgID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"622\", null, \"6\", null, \"2\", \"1\", 1, \"PARENT\", null, 0, null, \"0\", \"26\", \"0\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null"]}[\code]
The error message from mySQL is essentially saying that you can't create a page without giving it a parent.
To update this post:
No user in our CMS can create a new page (even superadmin). This error is displayed when the user clicks publish and/or edit mode from composer after have clicked "add page" on an item in the sitemap. In every case a parent is selected.
Also, creating pages using the pages interface fails (I think that's what it is called [next to the settings slider])
- When clicking on a page type for creation the user receives an error like this immediately:
An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID, cIsActive, cIsDraft) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["693", null, "6", null, "1", "TEMPLATE", null, 195, 0, 0, 0, 1]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null
Currently, users can only create a new page by copying other pages in the site map through drag and drop.
The errors above were presented to the super admin user. Every other user follows suit.
Any further advice would be greatly appreciated.
thanks
No user in our CMS can create a new page (even superadmin). This error is displayed when the user clicks publish and/or edit mode from composer after have clicked "add page" on an item in the sitemap. In every case a parent is selected.
Also, creating pages using the pages interface fails (I think that's what it is called [next to the settings slider])
- When clicking on a page type for creation the user receives an error like this immediately:
An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID, cIsActive, cIsDraft) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["693", null, "6", null, "1", "TEMPLATE", null, 195, 0, 0, 0, 1]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null
Currently, users can only create a new page by copying other pages in the site map through drag and drop.
The errors above were presented to the super admin user. Every other user follows suit.
Any further advice would be greatly appreciated.
thanks
I'd still appreciate any decoding you might be able to do, but I am moving on at the moment.
thanks again.