I had an index error in jos_core_acl_aro table
I ran mysqlcheck -r and it recovered about 50% of users
I’m trying to recreate missing users manually but my modx backend is claiming wrong password..
even though all is correct in mox_manager_user including the correct MD5 password
I ran the following from the joomla support site to try and recreate a superuser but of course that will not change modx manager
INSERT INTO `jos_users`
(`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`,
`gid`, `registerDate`, `lastvisitDate`)
VALUES (NULL, ’Administrator2’, ’admin2’, ’
[email protected]’,
’d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199’,
’Super Administrator’, 0, 1, 25, ’0000-00-00 00:00:00’, ’0000-00-00 00:00:00’);
INSERT INTO `jos_core_acl_aro` VALUES (NULL, ’users’, LAST_INSERT_ID(), 0, ’Administrator’, 0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, ’’, LAST_INSERT_ID());
Anything else I can try?
