Joomla! Forum - community, help and support

I recently had to restore the database and I'm now not able to login to my backend. I've already gone into phpadmin and reset my admin password as well as created a new admin login. Neither works to log me in.

I've also edited the configuration.php file so that siteoffline=0.

What else could it be? Thanks so much!

can you use the "Reset password" - ie is your email working on the site?

Check out this:

http://docs.joomla.org/Administration_FAQs_Version_1.0

J

I need to create a new superuser and would like to run the query (in my sql database) that you provided in the instructions.

I went to Query and pasted in this query in the SQL guery on (my database) and then hit submit query

INSERT INTO `jos_users` VALUES
(62, 'Administrator2', 'admin2', '[email protected]', '21232f297a57a5a743894a0e4a801fc3',
'Super Administrator', 0, 1, 25, '2005-09-28 00:00:00', '2005-09-28 00:00:00', '', '');
INSERT INTO `jos_core_acl_aro` VALUES (10,'users','62',0,'Administrator2',0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25,'',10);

However, it is saying "You have to choose at least one column to display". I don't see anything about columns except "Add/Delete Field Columns." I choose "1", but that had no effect.

Can anyone help. The alternative method offered is even more beyond my skill level.
Thanks

Hi, I wish i ad seen this page earlier. I wasted 3 days and found this at last. from pwrusr.com
=========do this=========

If, for some reasons, you need to reset your joomla! admin password, or if you need to offer admin access to somebody else, or for whatever the reason, please change it by doing so:

Open PHPmyAdmin.
access your joomla DB and goto table jos_users.
modify "admin"-row and set it’s password code to this: 21232f297a57a5a743894a0e4a801fc3 (it’s the equivalent of ‘admin‘).
(for more info and explanations, check this post over here: http://forum.joomla.org/viewtopic.php?t=10985).

Hope this info is useful for everyone, and wish you all have a good time.
==================================================
No one should waste their time in vain like I did.