[SOLVED] HELP Just lost my backend login

Breakdown... First All well then i installed CB social. It told me to remove joomla login so i did. all is well. Next day i was having problems with CB and I Decided to use jomsocial. So I unpublished the CB Login and other mods and at that exact second my 4 month daughter started crying so i stopped what i was doing. I came back half hour later and my admin timed out. I tried to log in and nothing. i have 3 registered names to get in and none work. If i put a wrong name in i get the error message for wrong name and pw but if i put in the correct name in it just refreshes and i have to try again. I have tried everything including backup recovery from the day before"which is all I have" and that didnt work. Is it possible that the Login mod for joom is connected to your backend? I really need this solved fast and will tip or pay for help. Thank you so much for your help. TY again Site is running fine http://www.extremecybernet.com

Hope someone can help me here. If so i will get a year subscription. ty so much in advance. if tried joomla and rockettheme forums and no help

ok I just fixed this myself and for anyone that has this problem here is the fix. Go to database: "mysql" then go to jos_modules and in row 2 LOGIN make sure the published is set to 1 and not 0. Next and most important go to jos_plugins and make sure Joomla user login is also set to 1 and not 0. If there is still a problem try this
We can try to remake a new Superadmin user and password;

1. Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
2. Press the "SQL" button in the toolbar to run a SQL query on the selected database. This will display a field called "Run SQL query/queries on database <your database>".
3. Delete any text in this field and paste in the following:


Code:
INSERT INTO `jos_users`
(`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`,
`gid`, `registerDate`, `lastvisitDate`)
VALUES (NULL, 'Administrator2', 'admin2', 'your-email@yourdomain.com',
'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMm BVxYmg0vuXEA4199',
'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());


Then click Go.

4. At this point, you should be able to log into the back end of Joomla! with the username of "admin2" and password of "secret". After logging in, go to the User Manager and change the password to a secure value and the e-mail to a valid e-mail address.

See how this goes

Did you try the Lost password?