If you need tips & tricks, here they are...

Joomla error 'You cannot access the private section of this site.'

Got the error "You cannot access the private section of this site." on one of my sites when trying to login as a "normal" user in front-end.

This was a pretty interesting issue to find and resolve.
It's an database 'error' of sorts that is pretty simple to fix.
First of all this is all due to a parent<-child condition that has gone horribly wrong in an update or something else.
Most likely you will find this issue in the table "assets".
You will need to find your database prefix fist of all, easiest found in the configuration and the option "$dbprefix". I will call it "prefix_" here for ease of typing.

So to find if you have this issue you can run the following in an sql manager of your choosing (mysql or phpmyadmin shoulden't make any differents, i did it in the cli mysql)

SELECT id,parent_id,title FROM `prefix_assets` WHERE parent_id=0;

If you find that there are multiple rows then hit the above do the following

UPDATE `prefix_assets` SET parent_id=1 WHERE parent_id=0 AND NOT id=1;

You should also verify that the "Root Asset" has id 1 and parent_id 0

SELECT id,parent_id,title FROM `prefix_assets` WHERE id=0 OR parent_id=0;

this should give the result

id parent_id title
 1 0 Root Asset

if not run
UPDATE `prefix_assets` SET parent_id=0 WHERE title="Root Asset";

This should have fixed the issue.

Add comment

Security code

Please consider supporting our efforts.

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.