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:

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

pvernaglia
 
rainbow replied on at Permalink Reply
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.
pvernaglia replied on at Permalink Reply
pvernaglia
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.
rainbow replied on at Permalink Reply
Thanks for your quick response. I will look into that and let you know the
outcome.
rainbow replied on at Permalink Reply
Your solution worked. Thanks! You save me hours of work.
malkau replied on at Permalink Reply
malkau
This helped me too - thanks!
mscmorris replied on at Permalink Reply
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.
uimatters replied on at Permalink Reply
uimatters
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!
ljarbeau replied on at Permalink Reply
Having this same issue... Please help
ljarbeau replied on at Permalink Reply
Having this same issue... Please help
simoneast replied on at Permalink Reply
simoneast
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?