Error editing pages
Permalink 1 user found helpful
Hi, I'm developing a site in 5.7.3 and this morning we started to get an error message after putting pages in edit mode:
Did an upgrade to 5.7.3.1 but the errors continue. Can anyone shed some light on this?
thanks
Doctrine \ DBAL \ DBALException An exception occurred while executing 'select cID from Pages where cParentID in () and cInheritPermissionsFromCID = ': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and cInheritPermissionsFromCID =' at line 1 /home/licess/public_html/pavilion/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php { $msg = "An exception occurred while executing '".$sql."'"; if ($params) { $msg .= " with params " . self::formatParameters($params); } $msg .= ":\n\n".$driverEx->getMessage(); return new self($msg, 0, $driverEx); }
Did an upgrade to 5.7.3.1 but the errors continue. Can anyone shed some light on this?
thanks
I am having the same error. Glad to know I am not alone. I hope someone comes to our rescue. I am getting tired of all the bugs with the new 5.7. I love Concrete 5, so I hope a solution presents itself.
In my case this was a problem with a Page Type and I think it was one that was copied from another (a problem with copying Page Types was fixed in 7.3.1).
I made a new Page Type, switched the pages to that new page Type and deleted the old one. that resolved the issue.
I made a new Page Type, switched the pages to that new page Type and deleted the old one. that resolved the issue.
Thanks for your quick response. I will look into that and let you know the
outcome.
outcome.
Your solution worked. Thanks! You save me hours of work.
This helped me too - thanks!
I ran into this error too. I followed the stack and realized that for some reason the collection was trying to run a permissions update on an invalid collection. I don't really know why yet but in the mean time I've made a patch which ensures it doesn't try to run the update queries on an invalid collection.
Hi mscmorris,
Do you have any information on your patch? I recreated my Page Type and things were fine. But today, the problem resurfaced. Any help would be greatly appreciated.
Thanks!
Do you have any information on your patch? I recreated my Page Type and things were fine. But today, the problem resurfaced. Any help would be greatly appreciated.
Thanks!
Having this same issue... Please help
Having this same issue... Please help
Yes, I am also getting the same error quite frequently (even in latest 5.7.5.3). It makes editing pages and page types very frustrating.
Can anyone post a code patch that resolves this?
Can anyone post a code patch that resolves this?