Forum Support

Shape 5
April 17, 2021, 01:33:53 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
   Home   Help Search Login Register  
Pages: 1 [2]
Author Topic: Error joomla admin login : JUser: :_load: Unable to load user with id: 42  (Read 1615 times)
Offline Offline

Posts: 23789

« Reply #15 on: 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

Jonah Hall
Shape 5 Team

- Need a great host for your website? We highly recommend!

- Put your trust in the hands of our extremely qualified staff to get your job done right!

- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
Jr. Member
Offline Offline

Posts: 2

« Reply #16 on: 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)');
Pages: 1 [2]
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.