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

[DavidBoggitt]

I didn't go near jUpgrade, ever! I think I used spUpgrade for this particular site..

[sovainfo]

Tried to run AssetFix https://github.com/elinw/AssetFix and ran into the problem with JObservableInterface being unknown. See issue on the repo.

Advice to use the AssetFix if you are not sure your envionment is having the exact problem for the SQL provided here.

[mcsmom]

Make sure you are using the J3 version. I've just been also doing a hotfix for the larger issue that error represents.

I actually just deleted the other version since it was confusing.

[mcsmom]

I actually just also posted a hotfix for the issue of the JObservableInterface being unknown if you want that but asset fix should run without that. Going to go check that now. Mean time hotfix is here.

http://joomlacode.org/gf/project/joomla ... m_id=31663

[sovainfo]

Downloaded and used the J3 version. Also used your hotfix. Unfortunately can't reproduce the error now. Which confirms what you are saying that AssetFix runs without it. But doesn't explain why I had the error in the first place.

[colin99]

Slightly off topic: What is the suggested method of migrating
to Joomla 3.X (and I know that I can visit the requisite forum...)

Was just looking for your opinion.

Overall, I would say that Jupgrade served me well for many upgrades
and migrations -- and only now are we seeing some minor bugs...
I am sure there were more issues - they just did not effect me I guess.

[sovainfo]

For simple sites migrating with jupgrade is not a problem. For more complex sites the data migration is the biggest challenge. Very much depending on de data migration possibilities of the extensions in use.

Starting with an empty J3 and importing what you still want using J2XML or other tools is also an option.

[mcsmom]

JUpgrade had some problems when 1.6 was first released, but now I think it handles things pretty well.

How to migrate from 1.5 to 2.5 or 3 really depends on how complex your site is and whether any extensions you are using have good upgrade paths.

There are basically three issues in migrating and JUpgrade/spupgrade will deal with one, which is moving your data. You need to carefully
How to upgrade really depends on how complex your site is and whether any extensions you are using have good upgrade paths.

How to upgrade from 2.5 to 3 is basically 95% about your template and how easy or hard it is to convert to use Bootstrap mark up. Again a big question is whether you extensions are ready. This means both for markup and whether they are still using any 1.5 code that was kept for legacy purposes throughout 1.6-2.5 but removed in 3.

The main thing is test, test, test on a development site.

[TheDode]

https://github.com/elinw/AssetFix
Download that file and place it in your website root.
Browse to it mydomain.com/assetfix.php

Had the same issue after updating from 2.5.11 to 2.5.14, and tried your php script but it throws:

Code: Select all

Fatal error: Uncaught exception 'RuntimeException' with message 'Library path /home/sdo/public_html/libraries/legacy cannot be found.' in /home/sdo/public_html/libraries/loader.php:251 Stack trace: #0 /home/sdo/public_html/assetfix.php(36): JLoader::registerPrefix('J', '/home/sdo/publi...') #1 {main} thrown in /home/sdo/public_html/libraries/loader.php on line 251

The 2 SQL queries posted above seemed to have fix the problem, but i just wanted to be sure with your AssetFix. HTH.

[mcsmom]

The JObservableInterface issue is one that is going to happen for standalone applications that don't import the legacy and cms libraries. It may also happen to some other components we'll have to see.
With assetFix you need to make sure to put it in the joomla root.

[Fintan]

Hi guys/girls?, I have been following this with interest. I am having the same problems with loging in as public user. I have set the public acess to public and registered. In Global all the pertinent access permissions are set to allow.

I am no PHP guru at all. I can follow the logic discussed here but have a problem applying it.

How do I do this from within my phpadmin?

Step by step?

I tried running assetfix.php and it threw me this:

Fatal error: Uncaught exception 'RuntimeException' with message 'Library path /home/httpd/vhosts/latina-bodyfashion.ch/httpdocs/Test/libraries/legacy cannot be found.' in /home/httpd/vhosts/latina-bodyfashion.ch/httpdocs/Test/libraries/loader.php:251 Stack trace: #0 /home/httpd/vhosts/latina-bodyfashion.ch/httpdocs/Test/assetfix.php(36): JLoader::registerPrefix('J', '/home/httpd/vho...') #1 {main} thrown in /home/httpd/vhosts/latina-bodyfashion.ch/httpdocs/Test/libraries/loader.php on line 251

NO clue

Please help. So close and yet so far away.

Oh, yes this was after the latest joomla update last week.

[sovainfo]

library/legacy is for J3, the both of you are running J2.5!

Unfortunately no J2.5 of AssetFix anymore?

Run phpMyAdmin tab SQL: SELECT count(*) FROM `#__assets` WHERE parent_id = 0
Replace #_ with your prefix.
It should be 1 row. Do yo have more than 1?

[Fintan]

Code: Select all

Okay went to the sqp tab in phpadmin and ran:
SELECT count(*) FROM `x3bzx__assets` WHERE parent_id = 0

and get this:

Error

SQL query: Documentation

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

MySQL said: Documentation
#1146 - Table '11678_latinatest.x3bzx__assets' doesn't exist

Now what?

[Fintan]

Code: Select all

Okay went to the sqp tab in phpadmin and ran:
SELECT count(*) FROM `x3bzx__assets` WHERE parent_id = 0

and get this:

Error

SQL query: Documentation

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

MySQL said: Documentation
#1146 - Table '11678_latinatest.x3bzx__assets' doesn't exist

Now what?

[sovainfo]

Created another clean 315 environment, ran assetfix. Downloaded assetfix again. Copied content of github. All three tries result in :
Fatal error: Interface 'JObservableInterface' not found in C:\xampp\htdocs\Joomla\j315schoon\libraries\joomla\table\table.php on line 26

[sovainfo]

Go to administrator, Global configuration tab Server. Verify Database name and prefix.
Go to phpMyAdmin, make sure you are on the right database and use that prefix. Run the sql command again.

[mcsmom]

AssetFix should still run on 2.5. If it isn't let me know and I'll make a separate version.

Meantime you can just comment out the line importing that. Basically there are a bunch of imports at the top that are only needed because of this interface issue in J3.

Is it easier if I make two separate repositories?

[Fintan]

AssetFix should still run on 2.5. If it isn't let me know and I'll make a separate version.

Didn't work here.

[mcsmom]

Try it now I just pushed an update. You will get a warning with mysqli but it doesn't cause a problem.

[sovainfo]

Confirm AssetFix working on J2.5.14 including warning on mysqli.

EDIT:

Needed to comment out line below:

Code: Select all

//JLoader::registerPrefix('J', JPATH_PLATFORM . '/legacy');

[Fintan]

Have been running the latest assetfix for the last 10 minutes. The brwowser tab page stay white. I am kind of concerned about closing it. How long does the script usually take? Is there any way of seeing what it is doing?

Cheers
Fintan

[Fintan]

Ran assetfix for an hour. Blank (white) tab page. Finally closed the tab and tried. No change.

[apollonios]

I have the same problem: “You cannot access the private section" , after upgrade to Joomla 2.5.14
I run the assetfix but the problem not solved...

Any idea please?

[Jessnet]

Same problem here.
I also run the assetfix in Joomla 2.5.14 but got this:

Code: Select all

Fatal error: Uncaught exception 'JDatabaseException' with message 'Unknown column 'alias' in 'where clause' SQL=SELECT id FROM j25_assets WHERE alias = 'root'' in /customers/6/6/1/mjolbypk.org/httpd.www/libraries/joomla/database/database/mysqli.php:403 Stack trace: #0 /customers/6/6/1/mjolbypk.org/httpd.www/libraries/joomla/database/database.php(965): JDatabaseMySQLi->execute() #1 /customers/6/6/1/mjolbypk.org/httpd.www/libraries/joomla/database/tablenested.php(1262): JDatabase->loadColumn() #2 /customers/6/6/1/mjolbypk.org/httpd.www/libraries/joomla/database/table.php(291): JTableNested->getRootId() #3 /customers/6/6/1/mjolbypk.org/httpd.www/libraries/joomla/database/table/content.php(102): JTable->_getAssetParentId(NULL, NULL) #4 /customers/6/6/1/mjolbypk.org/httpd.www/libraries/joomla/database/table.php(641): JTableContent->_getAssetParentId() #5 /customers/6/6/1/mjolbypk.org/httpd.www/libraries/joomla/database/table/content.php(272): JTable->store(false) #6 /customers/6/6/1/mjolbypk.org/httpd.www/assetfix.php(262): JT in /customers/6/6/1/mjolbypk.org/httpd.www/libraries/joomla/database/database/mysqli.php on line 403

[TheDode]

Try it now I just pushed an update. You will get a warning with mysqli but it doesn't cause a problem.

Worked without errors on an "old" upgraded J! 2.5.14, and with the MySQLi warning on another fresh 2.5.14 install.
Thanks a lot for your tool mcsmom !

[mcsmom]

Great, I'm so glad it worked.

[Jessnet]

It don´t work for me
I get the error as I attached to my earlier post yesterday and can´t log in.

Any suggestions?

[rowdyred94]

The assetfix script ran successfully for me in under a minute, but unfortunately it didn't solve the problem.

[Fintan]

I ran it again with the same resulzs (none).
http://www.latina-bodyfashion.ch/Test/assetfix.php

I have attached my assetfix.php

[scene66]

Thank you mcsmom.

Changing Parent_IDs from 0 to 1 fixed the issue.
The site was a native 2.5.
Never had used JUgrade.
Believe the issue occurred after a recent Joomla upgrade (perhaps from 2.5.11 through 13'ish?)
Presently using 2.5.14