Can't Access Dashboard!!
An exception occurred while executing 'select cID from Pages where cParentID = and cIsTemplate = 0 order by cDisplayOrder asc': SQLSTATE: 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:
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: 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):
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
- 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
- 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.....
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
Strange thing is, that I wasn't creating any pages or single pages, just editing
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 ?