Forums / General / Lost access to siteaccesses admin and public

Lost access to siteaccesses admin and public

Previous topic

General

Next topic

Author	Message
Virgilio Lemos	Thursday 06 August 2009 11:51:46 pm When I try to access the site I receive the message below: You do not have permission to access I could see in the log file (/var/www/site/var/log/error.log) the following message: ZMySQLiDB: Query error: 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 ')' at line 3. Query: SELECT DISTINCT limit_identifier, limit_value FROM ezuser_role WHERE contentobject_id IN ( 0, ) I think the system is triyng to access a contentobject_id 0. Any idea about what caused and how to solve it?
Łukasz Serwatka	Friday 07 August 2009 2:24:44 am Hi, This looks like a DB inconsistency. Did you remove any content? This error seems to be a result of few things. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Author

Message

Virgilio Lemos

Thursday 06 August 2009 11:51:46 pm

When I try to access the site I receive the message below:
You do not have permission to access
I could see in the log file (/var/www/site/var/log/error.log) the following message:
ZMySQLiDB:
Query error: 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 ')' at line 3. Query: SELECT DISTINCT limit_identifier, limit_value
FROM ezuser_role
WHERE contentobject_id IN ( 0, )
I think the system is triyng to access a contentobject_id 0.
Any idea about what caused and how to solve it?

Łukasz Serwatka

Friday 07 August 2009 2:24:44 am

Hi,

This looks like a DB inconsistency. Did you remove any content? This error seems to be a result of few things.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog