Forums / General / Lost access to siteaccesses admin and public

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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