Forum Support

Shape 5
April 17, 2021, 03:08:39 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]
  Print  
Author Topic: Error joomla admin login : JUser: :_load: Unable to load user with id: 42  (Read 1616 times)
jonahh
Administrator
*****
Offline Offline

Posts: 23789



WWW
« 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
Logged

Jonah Hall
------------
Shape 5 Team

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


- 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
rogue
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

Code:
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)');
Logged
Pages: 1 [2]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
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.