Page 2 of 3

Re: Frontend login error:“You cannot access the private sect

Posted: Sun Aug 04, 2013 8:22 am
by DavidBoggitt
I didn't go near jUpgrade, ever! I think I used spUpgrade for this particular site..

Re: Frontend login error:“You cannot access the private sect

Posted: Sun Aug 04, 2013 9:39 am
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Sun Aug 04, 2013 2:49 pm
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Sun Aug 04, 2013 4:21 pm
by 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

Re: Frontend login error:“You cannot access the private sect

Posted: Sun Aug 04, 2013 5:33 pm
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Sun Aug 04, 2013 6:33 pm
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Sun Aug 04, 2013 8:26 pm
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Mon Aug 05, 2013 7:52 am
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Mon Aug 05, 2013 3:01 pm
by TheDode
mcsmom wrote: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.

Re: Frontend login error:“You cannot access the private sect

Posted: Tue Aug 06, 2013 3:23 am
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Tue Aug 06, 2013 5:51 pm
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Tue Aug 06, 2013 6:10 pm
by 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?

Re: Frontend login error:“You cannot access the private sect

Posted: Tue Aug 06, 2013 6:18 pm
by 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?

Re: Frontend login error:“You cannot access the private sect

Posted: Tue Aug 06, 2013 6:38 pm
by 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?

Re: Frontend login error:“You cannot access the private sect

Posted: Tue Aug 06, 2013 7:53 pm
by 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

Re: Frontend login error:“You cannot access the private sect

Posted: Tue Aug 06, 2013 7:58 pm
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Wed Aug 07, 2013 2:29 am
by 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?

Re: Frontend login error:“You cannot access the private sect

Posted: Wed Aug 07, 2013 6:55 am
by 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.

Re: Frontend login error:“You cannot access the private sect

Posted: Thu Aug 08, 2013 1:14 am
by mcsmom
Try it now I just pushed an update. You will get a warning with mysqli but it doesn't cause a problem.

Re: Frontend login error:“You cannot access the private sect

Posted: Thu Aug 08, 2013 2:02 am
by 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');

Re: Frontend login error:“You cannot access the private sect

Posted: Thu Aug 08, 2013 10:34 am
by 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

Re: Frontend login error:“You cannot access the private sect

Posted: Thu Aug 08, 2013 2:25 pm
by Fintan
Ran assetfix for an hour. Blank (white) tab page. Finally closed the tab and tried. No change. :(

Re: Frontend login error:“You cannot access the private sect

Posted: Fri Aug 09, 2013 7:59 am
by 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?

Re: Frontend login error:“You cannot access the private sect

Posted: Sat Aug 10, 2013 3:26 pm
by 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
:(

Re: Frontend login error:“You cannot access the private sect

Posted: Sat Aug 10, 2013 3:55 pm
by TheDode
mcsmom wrote: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 !

Re: Frontend login error:“You cannot access the private sect

Posted: Sat Aug 10, 2013 4:34 pm
by mcsmom
Great, I'm so glad it worked.

Re: Frontend login error:“You cannot access the private sect

Posted: Sun Aug 11, 2013 8:02 am
by 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?

Re: Frontend login error:“You cannot access the private sect

Posted: Mon Aug 12, 2013 6:20 pm
by rowdyred94
The assetfix script ran successfully for me in under a minute, but unfortunately it didn't solve the problem.

Re: Frontend login error:“You cannot access the private sect

Posted: Tue Aug 13, 2013 7:35 am
by Fintan
I ran it again with the same resulzs (none).
http://www.latina-bodyfashion.ch/Test/assetfix.php

I have attached my assetfix.php

Re: Frontend login error:“You cannot access the private sect

Posted: Wed Sep 11, 2013 5:00 am
by 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