I think this will not work anymore, because in Joomla 1.5 an additional $salt parameter is used to encrypt the password. In the usertable the password is stored in the format:
so simple md5 hashed passwords will not work anymore...
It worked for me when I tested it. Mark Dexter 15:08, 4 October 2008 (EDT)
Trust me :-) You can put in an md5 in the database as the password, When that user tries to login Joomla will notice that the password is md5 hashed and will then UPGRADE that password to a SALTED password, saving the result back to the database - thats why it works :-) Phil Taylor
Depending on the version of the MySQL server, the function LAST_INSERT_ID( ) can produce 0 and the recovery procedure fails.
You can insert the admin2 user into the last two tables 'manually'. Run this query to find out the id of the admin2 user:
SELECT * FROM `jos_users` WHERE username = 'admin2'
Use the value of id in the next query to replace 9999:
INSERT INTO `jos_core_acl_aro` VALUES (NULL, 'users', 9999, 0, 'Administrator', 0);
Use the value of id to replace 9999 to find out aro_id:
SELECT * FROM `jos_core_acl_aro` WHERE value = 9999
Use the value of aro_id in the last query to replace 8888:
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, , 8888);
Toivo 00:44, 10 May 2009 (UTC)
My solution: I set manually values for tables jos_core_acl_aro,jos_core_acl_groups_aro_map and jos_core_acl_aro_sections. I had an other joomla database where I could compare values and make changes to "problem" database.