Can't login to admin backend after restoring database!

Need help installing Joomla!? For all Joomla! installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
thumbelulu
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Sep 18, 2009 7:57 pm

Can't login to admin backend after restoring database!

Postby thumbelulu » Fri Jun 10, 2011 1:03 am

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!

User avatar
Jay44
Joomla! Ace
Joomla! Ace
Posts: 1131
Joined: Fri Oct 19, 2007 10:34 pm
Location: Australia

Re: Can't login to admin backend after restoring database!

Postby Jay44 » Fri Jun 10, 2011 5:15 am

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
"Things not being necessary is what makes life interesting" -- Stephen Fry
This is necessary - http://docs.joomla.org/

caolannjo
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Oct 26, 2012 1:46 pm

Re: Can't login to admin backend after restoring database!

Postby caolannjo » Fri Oct 26, 2012 10:21 pm

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', 'my-email@email.com', '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

bosekaspathy
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat May 22, 2010 11:09 pm

Re: Can't login to admin backend after restoring database!

Postby bosekaspathy » Sat Nov 09, 2013 12:43 pm

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: 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.


Return to “Installation - 1.0.x”

Who is online

Users browsing this forum: No registered users and 3 guests