Shape 5

Joomla Templates => Appwonder - Club => : explisys December 05, 2011, 09:02:04 AM



: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: explisys December 05, 2011, 09:02:04 AM

Hello,

I have installed Appwonder - Site Shaper - Current  on my web server (Quick install of Joomla combined with all the modules, images, etc used on the demo) but when i try to connect on administrator panel, Joomla says me :         

JUser: :_load: Unable to load user with id: 42
        JUser: :_load: Unable to load user with id: 42
        You do not have access to the administrator section of this site.

Who can help me please!?

Best regards,

Xv


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: jonahh December 05, 2011, 01:37:28 PM
Hello

Try making the username admin and password admin and then changing later once the site is setup and working.  I just tested site shaper and it worked no problem when I did this


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: explisys December 05, 2011, 03:44:50 PM

thanks for the help and the frighteninly fast reply,

I tested with admin username and password but doesn't working. I think this problem appears when i click the install sample data at the last screen, i've got this error message :

Error
    Some errors occurred while populating the database: Table 'signao.jos_usergroups' doesn't exist SQL=-- -- Dumping data for table `jos_usergroups` -- INSERT INTO `jos_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES (1, 0, 1, 16, 'Public'), (2, 1, 6, 13, 'Registered'), (3, 2, 7, 12, 'Author'), (4, 3, 8, 11, 'Editor'), (5, 4, 9, 10, 'Publisher'), (6, 1, 2, 5, 'Manager'), (7, 6, 3, 4, 'Administrator'), (8, 1, 14, 15, 'Super Users')

Do you know more about this error?

Sincerely,

Xv


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: jonahh December 06, 2011, 02:13:41 PM
Oh it might be your MySQL server version.  What version of MySQL are you running?


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: explisys December 06, 2011, 04:20:00 PM

Please, find my server information :

    Server: Localhost via UNIX socket
    Version: 5.0.44-log
    Version du protocole: 10
    MySQL: UTF-8 Unicode (utf8)

Web server :

    Apache/2.2.16 (Unix) mod_ssl/2.2.16 OpenSSL/0.9.8o
    MySQL: 5.0.44
    Extension PHP: mysql



: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: jonahh December 07, 2011, 02:43:40 PM
Ok we are running:

5.0.92-community and site shapers are built on 5.1.53.  I would try upgrading as this most likely is the issue why it can't import the template demo data


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: 12flamingo January 01, 2012, 01:03:45 PM
I've had this problem once when installing an extra intance of Joomla (the Simplex template) on my server and never found out why it happened. I've never had any problems with installing the demodata or siteshapers in general.

Do you have any clue why because I'd really like to know how to solve it.


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: jonahh January 02, 2012, 02:52:33 PM
The newer Joomla 1.7 site shapers cause this issue but most people when upgrading there MySQL version wont have this issue. 


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: 12flamingo January 02, 2012, 04:23:05 PM
It is not possible for me to upgrade and my version is 5.0.51. can't it be dealt with in any other way?


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: triton186 January 03, 2012, 12:22:38 AM
The newer Joomla 1.7 site shapers cause this issue but most people when upgrading there MySQL version wont have this issue. 

My host uses MySQL 5.0.51a. They won't upgrade it because the server is a 'shared server'. Why is it that you don't warn people about some specific MySQL version requirement before they (me) pay the membership fee here at Shape 5??

From reading through the forums tonight, I can see that there are quite a few poeple having the Step 6 - install sample data error, which leads to not being able to login to the site after the install. This means we have a completely broken site, where the only option for us is to remove the Shape 5 install completely and start fresh from native 1.7.3 install... which by the way, works perfectly. This is unacceptable that Shape 5 does not clearly post the MySQL version requirement, if that is what is truely causing so many of us this common error with the site shaper install process.


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: 12flamingo January 03, 2012, 10:23:46 AM
There must be another solution than upgrading the MySql?


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: jonahh January 03, 2012, 01:28:27 PM
If you PM me server access I can try to manually import into MySQL for you. 


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: apanos March 03, 2012, 03:38:50 PM
i tried to install vertex template and i have th same problem. I cannot login to admin area (backend).
I also tried to see the replies in this ticket but it seems that are deleted.
Can you pease tell me what to do to fix it?
I need to test vertex template before i buy the developer subscription.
regards
Andreas


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: jonahh March 05, 2012, 01:16:07 PM
Hello,

You will need to post in the Vertex free template area if you need support on this.   Appwonder is a paid club template and you currently have a free account


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: meshtalk April 20, 2012, 11:30:49 AM
Hello,

I experiance the same problem:

        JUser: :_load: Unable to load user with ID: 42
        JUser: :_load: Unable to load user with ID: 42
        You do not have access to the administrator section of this site.

I bought Joomla upgrade for unlimited domains. First installation I made without problems - aurora dawn complete joomla install.

When I tried to install on the second domain - cyan template, I always received this error. Also when I tried to install again aurora dawn.

First - successful installation was made with differen admin name (not admin) ... and it went well ... all other server settings are the same.

What else can I do?

Mateo


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: jonahh April 20, 2012, 12:48:57 PM
When going through install, make sure to not change language at first page.  And make your username and password "admin"  then once you finish install and login change from admin


: Re: Error joomla admin login : JUser: :_load: Unable to load user with id: 42
: rogue January 31, 2013, 11:01:48 PM
Just had the same problem and found the fix. The problem is the #__usergroups` didn't get created during the install. I had to revert back to the original joomla script:  Don't forget to replace #_ with your prefix eg. jos_usergroups

:
DROP TABLE IF EXISTS `#_usergroups`; CREATE TABLE IF NOT EXISTS `#_usergroups` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',   `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',   `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',   `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',   `title` varchar(100) NOT NULL DEFAULT '',   PRIMARY KEY (`id`),   UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`),   KEY `idx_usergroup_title_lookup` (`title`),   KEY `idx_usergroup_adjacency_lookup` (`parent_id`),   KEY `idx_usergroup_nested_set_lookup` USING BTREE (`lft`,`rgt`) ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; -- -- Dumping data for table `#__usergroups` -- 



INSERT INTO `#_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES (1, 0, 1, 20, 'Public'), (2, 1, 6, 17, 'Registered'), (3, 2, 7, 14, 'Author'), (4, 3, 8, 11, 'Editor'), (5, 4, 9, 10, 'Publisher'), (6, 1, 2, 5, 'Manager'), (7, 6, 3, 4, 'Administrator'), (8, 1, 18, 19, 'Super Users'), (12, 2, 15, 16, 'Customer Group (Example)'), (10, 3, 12, 13, 'Shop Suppliers (Example)');