Frontend login error:“You cannot access the private section"

[ypdmd]

I just upgraded three sites from 2.5.x to 2.5.14 and my users no longer have front end access. I tried assetfix, which ran successfully in a few seconds, but did not solve the problem.
All help is appreciated. (and yes I believe they were jupgraded)

[tmoberg]

This issue has taken me down for a month, and I finally got it fixed. So for the benefit of others I am posting my solution.

I patched to 2.5.14 and then my users could not log into the backend or to the private section of the frontend. It seemed odd that the Asset table had anything to do with this, but I ran the AssetFix code and that did not help. The trick was to sort the Asset table by Parent ID, then I noticed that there were indeed other entries with a value of 0, specifically for JEvent categories. Apparently during the upgrade from 1.5.x to 2.5.x this had not been changed (I used JUpgrade for that). It all worked fine until the 2.5.14 patch, which then did not like the other 0-value Parent IDs. I changed them to a value of 1, and now everything works.

Who knows what will break next!

[WebJIVE]

Yep, 2.5.14 needed more testing.. Broke one of our sites with the 0 value in the parent as well. ACLManager doesn't detect those either and fix.

[Chacapamac]

Everything work on a newly install site. Administration and all.

I get the dreaded login component 1 crap in the admin and take out the error by trashing manually the cache and adding cache 0 in the configuration, but I cannot login anymore.

Run the asset.php and nothing, I enter my login, click, refresh to login. I basically can’t reach the administration anymore.. Next step ... Not to sure...


What should I try

My core login seem to be the only asset table at 0

1 0 1 119 0 root.1 Root Asset {"core.login.site":{"6":1,"2":1},"core.login.admin...


Lot of Parent ID to 1 ???

Don’t know what to do next?

[TheDani]

Same problem here. Running J!2.5

• I have tried Extension Manager -> Database -> Fix.
• I have tried running (an unmodified) assetfix.php. Took a second. Gave a warning at the bottom

  Code: Select all

  Warning: mysqli_ping() [function.mysqli-ping]: Couldn't fetch mysqli in /path/to/mysite/libraries/joomla/database/database/mysqli.php on line 190

• Code: Select all

  SELECT count(*) FROM `j_assets` WHERE parent_id = 0

  Result: 1. So I have 1 record in asset table where parent_id = 0, 34 records where parent_id = 1 and 704 with other numbers. Should I change all those others to 1?
• I have tried rebuild categories in Category Manager even though I dont use Joomla's native category manager. I could not find any rebuild buttons in K2.
• I have tried rebuild categories in JEvents.

Any more suggestions?

[Chacapamac]

Where that problem come from?
how to get rid of it?
How to not get it at all?

[TheDani]

I have upgraded from 2.5.11 to 3.1.5.

Same login error. I wen through the procedure in my last post. assetfix.php did not throw any error this time, but did also not fix the issue.

[Chacapamac]

Really annoying, Somebody now what to do
• Can we have some information on what migration tools cause that ?
• How to bypass ?
• How to fix ?

[TheDani]

I have it solved.

Verify your settings in:
* Users -> User Manager
* Users -> Groups
* Users -> Options
* The group your user is in
* System -> Global Configuration -> Permissions
* If you have K2, also check K2's user settings.

[C0nw0nk]

So use this code to just fix those rows which are broken.

Code: Select all

UPDATE `prefix_assets` SET `parent_id`=1 WHERE `parent_id`=0

No, should be:

Code: Select all

UPDATE `prefix_assets` SET `parent_id`=1 WHERE `parent_id`=0 AND id>1

Thanks sova allot of people keep posting to drop the assets table and re-instal just run this sql command and fix the issue so easly

[roadsider]

Not for me, unfortunately. I have a fresh Joomla 3 install, no migration, and I'm getting the 403 error. I get to the admin area, but nothing shows up and I can't log out. I've tried the assetfix.php script and I've run the SQL queries. Nothing.

Really need some guidance with this.

[lintila]

Hello,

I have read the entire thread and tried the solutions offered here, however none of them have worked.

My situation is a little different. First of all, I did not upgrade from 2.5 -> 3.x

I started with a brand new database and install of Joomla 3.2.2. It has been running fine for about a month and I have 117 users that registered and logged in at various times.

Starting yesterday, I started getting emails from users that can no longer log in. They get the dreaded "You cannot access the private section of this site."

It seems only super users can login.

Not sure what happened to cause this as it has been fine for a month.

In trying the solutions listed here, I did not have any Assets with ID=0, they all look fine. I also updated my Joomla to 3.2.3.

Any other ideas?

Thanks
ANdy

[lintila]

I have found my problem. Another admin, in trying to send a site-wide email, has deleted the user group "Registered" which had all 116 users in it.

[stantaylor]

This problem suddenly arose for me in Joomla 2.5. I looked at the assets table in the database and found several JEvents rows with a parent_id of 0. I changed them all to 1 and the problem was gone. I suspect a JEvents update was the culprit. I see there is an update available for it now and wonder if that may fix the issue, too.

[yl56661]

Hi,
Here are my system details:
System Information
Setting Value

PHP Built On Linux euro1.accesstochina.com 2.6.32-042stab085.20 #1 SMP Fri Mar 21 19:07:05 MSK 2014 x86_64
Database Version 5.5.30
Database Collation utf8_general_ci
PHP Version 5.3.3
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.2.3 Stable [ Ember ] 6-March-2014 14:30 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.2; WOW64; rv:28.0) Gecko/20100101 Firefox/28.0

I have the issue with registered user cannot login, the message is:
"Warning

You cannot access the private section of this site."

I have update asset with parent_id=1 except one to 0 for title='Root Asset'

Anyone could advise me.

Thanks

Yuwan

[krcroteau]

I am experiencing the same problem, but I don't know how or where to run sql queries.

Can I simply change the default value for the Parent ID from 0 to 1 in the picture below. I would do this for all 3 assets tables.

Thanks.

[stantaylor]

krcroteau, you have a different look than my hosting service. It uses cPanel and the editing is done with phpMyAdmin. Anyway, looking at your screen, I think that should fix the problem. I had never done that before either, so I made a note of all the changes, just in case it messed things up and I had to undo the changes. I suggest you do that, too.

Can I simply change the default value for the Parent ID from 0 to 1 in the picture below. I would do this for all 3 assets tables.

[sovainfo]

@kroteau: Yes, that is ok

There is a SQL tab in the toolbar that allows you to enter the statements. Below the statements there are options to generate and clear the statement. Clear it first and paste the statement you want. Then edit the prefix and press GO.

[yl56661]

Hi

I use Joomla! 3.2.3 Stable, I have the above issue. I tried to update parent_id as suggested. But I have no success.

Can anyone give me advise.

Thanks

Yuwan

[sor]

Thank you very much. Much appreciated fixed that goddamn weird error.

Thank you again

[phuonker]

Hello everybody, I know it is a pretty old threat, but it is the only useful source I found about my problem. So its all about Frontend login error:“You cannot access the private section"
I tried now all the recommended stuff, which was mentionned in this threat, but unfortunately without any success at the moment.
I can access as superuser, but when I create an own user, I got this error message.
Some background information. I am running Joomla 3.6.5. I am also having Jevent as an extension. I now wanted to give some people restricted access to some articles (not Jevent) and this is not working. I can only apply general access levels like editor or superuser etc, which I do not want. I transferred the Jevent entries from a original 1.5 version. I just read, that this also might have some influence. But the Joomla installation itself is pretty new.
I also went into my DB and checked xxx-assets. There is one entry where the parent ID is 0 (root), but when I change it to 1, the Jevent is not working anymore properly, so it must stay 0.
I also analysed the DB for any damages, but there was nothing. I would be very happy, if there is someone who could give me a hint, how to solve this issue.
Thank you
Peter

[sha3rawy]

Hello everybody, I know it is a pretty old threat, but it is the only useful source I found about my problem. So its all about Frontend login error:“You cannot access the private section"
I tried now all the recommended stuff, which was mentionned in this threat, but unfortunately without any success at the moment.
I can access as superuser, but when I create an own user, I got this error message.
Some background information. I am running Joomla 3.6.5. I am also having Jevent as an extension. I now wanted to give some people restricted access to some articles (not Jevent) and this is not working. I can only apply general access levels like editor or superuser etc, which I do not want. I transferred the Jevent entries from a original 1.5 version. I just read, that this also might have some influence. But the Joomla installation itself is pretty new.
I also went into my DB and checked xxx-assets. There is one entry where the parent ID is 0 (root), but when I change it to 1, the Jevent is not working anymore properly, so it must stay 0.
I also analysed the DB for any damages, but there was nothing. I would be very happy, if there is someone who could give me a hint, how to solve this issue.
Thank you
Peter

I am having the same problem,I am running Joomla 3.8 though. did you solve your problem ? please let me know!