Can't Access Dashboard!!

Permalink
Suddenly, this strange error appeared! I really don't know, where it comes from. When I log in as admin, I'll get to the dashboard, which is set like this. But then the following error occurs:
An exception occurred while executing 'select cID from Pages where cParentID = and cIsTemplate = 0 order by cDisplayOrder asc': 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 cIsTemplate = 0 order by cDisplayOrder asc' at line 1

Apparently, the cParentID is not set:
cParentID =

I did not change any settings before that. I was just editing.
First, it logged me out when signing in
Then, after clearing caches (manually in the file system), clearing browser caches the above error occured. Very strange.
When signing in as non-admin user, everything is fine.

Using 5.7.4 Any ideas why this could happen?

Here's the complete PDO-Exception:
Uncaught exception 'PDOException' with message '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 cIsTemplate = 0 order by cDisplayOrder asc' at line 1' in /home/ekacomc1/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104 Stack trace: #0 /home/ekacomc1/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('select cID from...') #1 /home/ekacomc1/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(935): Doctrine\DBAL\Driver\PDOConnection->query('select cID from...') #2 [internal function]: Doctrine\DBAL\Connection->query('select cID from...') #3 /home/ekacomc1/public_html/concrete/src/Database/Connection/Connection.php(71): call_user_func_array('parent::query', Array) #4 /home/ekacomc1/public_html/concrete/src/Page/Page.php(1715):


EDIT:

If I check the "Stay signed in for 2 weeks" it works!
WTF is going on?

Also language is set to en_US, but the dashboard is still in german and the pages (editing) is english

daenu
View Replies:
WillemAnchor replied on at Permalink Reply
WillemAnchor
dunno, just some quick checks:
- try to clear the cache when logged in ? (with 2 weeks log in enabled)
- try to delete cookies
- try to login with a different browser
daenu replied on at Permalink Reply
daenu
- try to clear the cache when logged in -> check
- try to delete cookies -> check
- try to login with a different browser -> check (no history or cache)

Still the same, Im thinking about putting a backup from this morning in, because it is completely unlogic to mi understanding.....
WillemAnchor replied on at Permalink Reply
WillemAnchor
i found that query in pages.php
public function getCollectionChildren()

somehow it doesn't get the proper collectionID

you could check your database pages table to see if all entriies have a cID
daenu replied on at Permalink Reply
daenu
Yes they all have a cID. My provider is loading the backup from this morning at this moment.... We'll see, what that brings...
Strange thing is, that I wasn't creating any pages or single pages, just editing
WillemAnchor replied on at Permalink Reply
WillemAnchor
Strange that it doesn't happen when you stay logged in for 2 weeks.
Maybe you lost permissions somehow and c5 still tried to access the dashboard.
I didn't didn't dig into that part of the code, maybe someone else has...

Can you stil reproduce the error ?
daenu replied on at Permalink Reply
daenu
After restoring the backup, everything was normal again. I think, the customer did something with single pages without asking me how to.......
WillemAnchor replied on at Permalink Reply
WillemAnchor
:)