The Joomla! Forum ™

Well I finally found a solution to fix my log in to admin issue. Inexplicably access had been switched off in the DB.

But for no known reason I still can't log into the front end. Users can sign up. But they can't actually log in. I've tried maybe 50 "solutions." Nothing.

This is ridiculous.

Why do I feel like I'm using Windows all over again?

I swear, with everything I've had to do the past 2 weeks, it would have been quicker for me to install Drupal and work out how to port over a decent theme instead.

I am another new to Joomla. I have tired all of the save suggestion to no avail. When I went into phpMyAdmin as mentioned in the following post:

In phpmyadmin, go to the table jos_plugins.
Then scroll down to User - Joomla!
Click on the Edit icon
Go to the area where it says published and change that from 0 to 1

I find that the 'published' setting is already set to 1. I am hopeful that someone else has come up with a different solution. If I can't get into the back end of this program it is useless to me.

Thanks,
Idlespur

Good luck then.

I had a Joomla site working perfectly, until I moved it to a new hosting. After transferring the site and the db I was able to see the front end correctly, so I thought the configuration.php was fine.
However I could not login to the back end.

I solved the problem thanks to this post: viewtopic.php?p=1855719#p1855719

The content of the configuration.php was fine, but the encoding of the file was not compatible with the new hosting, probably. I fixed it by changing the encoding of the file to utf8- w/o bom and uploading it.

Fabrizio

Our client set $lifetime to 999999. I set it back to 15 and now it works perfectly again, thanks!

I had this login problem with 1.5.14 and when I went to fix the jos_plugins table I found that User - Joomla! was already set to '0'.

After searching and searching for an answer, I tried something silly: I set published to '1' - tried to login and it worked! I went back and set it to '0' again. Not a lick of trouble since.

Tried this but no success. I finally removed Joomla and it was the end of my problems^^

I tried for fun to reinstall (again) Joomla from scratch, new db, latest update and bla bla bla... Seems to work but I definitely lost all confidence in Joomla. Some "native modules" just mess with the system and of course there is no way back nor any real solution from the devs.

As I said on another thread, Joomla is nice for simple websites especially if you don't need advanced features or functions. But in my case for a webshop it's just too dangerous. You don't change anything in the system and some day you cannot log in anymore... Too many problems, too much time needed to fix simple issues, no real support, no reliability.

Joomla is good for newbies that just want to make a simple website but I definitely recommend to pros to forget about it because as a base for an e-commerce it's just too unstable and your business can just shut down from one day to another. It's not worth the time investment. I'll pay a real pro to design something stable that's the only way.

Hi Guys,

This may solve your Admin login issue:

http://help.joomla.org/content/view/1944/306/1/4/

Manually add the following QUERY to your DB:

INSERT INTO `jos_users` VALUES (62, 'Administrator', 'admin', 'your-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,'Administrator',0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25,'',10);

Follow the article above for instruction. It seems the admin profile is not getting set up during auto installation?

Aidan

I doubt you are reading what the majority of people are saying. Many if not most have been USING THEIR JOOMLA INSTALL then suddenly it stopped working. It is not an install issue!

_________________
Carcassonne Central - http://www.carcassonnecentral.com
MySteamID - http://www.mysteamid.com

Holy crap thank you for figuring this out. You just saved my a** :-)

I know it's open source, but that still comes with some responsibility.

I've just spent two months working on a beautiful Joomla site and suddenly I can't log in to admin. I've tried all the fixes on here and more. If I had know about this issue, I would have used DRUPAL instead.

Where are the DEVs on this issue? I haven't seen much of a response from them here.

[quote="Bob Roberts"]Can't login to admin - solved.

Yes thats correct folks. With the help of Crowbar, I was able to solve this problem.

In phpmyadmin, go to the table jos_plugins.
Then scroll down to User - Joomla!
Click on the Edit icon
Go to the area where it says published and change that from 0 to 1
And that is it. Fixed.


This worked for me.

My problem was the same as most others: I'd get no error message on front-end or admin; it just would present the login screen again. My solution is so stupid, I'm almost embarrassed to reveal it!

None of the previous solutions had worked for me:
- I tried refreshing the admin password
- I tried messing around with the published and access flags in the database
- I tried changing the lifetime

Was just about to try reinstall when I remembered something. The last time I edited the 'configuration.php' file in my text editor, it reported that there was no end-of-line [EOL] at the end of the file. so I added a new-line to the end of it. This converted it from a DOS format to UNIX format. So, I tried removing the new-line and converting back to DOS format, and it worked.

The thing is, I have since converted back to UNIX format and reintroduced the new-line, and I can still log in. I have no idea why this solution should work. Sounds to me like a nasty bug.

So, my advice would be to try adding/deleting new-lines at the end of 'configuration.php', refresh the page and see what happens!

Hope this helps.

I solved this problem by installing another copy of Joomla into another directory on my hosting account, extracting the database one table at a time thru PHPMyAdmin and importing it into the new install. Something was corrupt in one of my tables (now I don't remember which one). Eventually, dropped all tables from the original install, then re-imported fixed database and everything works fine now.

Still puzzled why this is such a widespread problem.

AIRTON IS THE MAN... i just moved my joomla installation from one server to another. i manually uploaded files using windows explorer ftp. i checked out if I had any files in my plugins/user folder and nothing was there. I uploaded them from my backup and bam.. logged right in. thanks, after hours of trying to figure this out.

C

just for the record - THANK you very much for solving this issue!! i had the same problem today and was able to fix it 'cuz of you guys. Can't thank you enough for saving my website

This worked for me
Changed the password in PHPMyAdmin to "password" (encrypted as 5f4dcc3b5aa765d61d8327deb882cf99)

i just wanted to thank you for this post – solved my issue in 2 minutes

Front End & Back End users stopped working for me after changing nothing. If I put in the wrong user/pass joomla would tell me I put in the wrong user/pass, and if I put in the correct user/pass it would appear as if I simply pressed refresh.

I've been scouring around looking for a solution and this is what worked for me:

Logged into phpMyAdmin, modified 'User- Joomla!' to access=1 & autoregister=0
....tried logging in again, still did not work.
modified 'User- Joomla!' back to access = 0 & autoregister=1
...everything works again.

Can't explain why changing, and then changing back to original fixed things, but it did at least for now.

Another joomla noob here. I too didn't realize that the login username is "admin". My browser had automatically populated it with the email for the admin I used to during the install. Once I changed the username, combined with the admin password, it logged in like a beauty.

Thanks for the tip.

Excellent job! Thanks for sharing.

Hi,

I somehow managed to uninstall the User-Joomla plugin on a plugin cleanup.

How would I add this again to my jos_plugin mysgl row in the db table, or restore?

Please I'm really stuck here and cannot login as a rsult, I get a login loop that just refreshes on admin login page.

Fixed, I went into another joomla databse for another site of mine and added the User-Joomla! to db row and all working again

I had this problem where my admin login page was just refreshing instead of logging in. It is now fixed for me using a variation of one of the solutions above, whereby you go into phpMyadmin > go to jos_plugins > click on browse tab > locate User - Joomla > click on edit button > instead of changing access to 1 (as recommended above, which didn't work for me) I changed the published field to 1.

This worked for me. I found this by comparing various fields in phpMyadmin against a different Joomla install I have which still worked.

Hope this helps for someone.

Thanks so much, this really helped me. i'm not sure why the file wasn't there, since I never deleted it specifically.

i had a hacking issues earlier this month and had to restore mywebsite and now I cannot login to the administrator page of joomla, i still have access to the ftp server. and I have read through this whole thread without any solutions. I can't access phpmyadmin, i've tried giong into www.youwebsite.com/phpmyadmin but that just takes to me "404 page does not exist error"

Any help??

cheers

I had the same problem with login, tried everything mentioned here, nothing worked.
The page is just refreshed.

I just stumbled upon something, it just works when i login to the link without www.
Ex: http://website.com/administrator

I didn't change anything, i usually logged in to the link with www.

Someone know what is causing this? Can't believe that such a big issue is left unnoticed

After screwing with this ridiculous issue, I decided to drop Joomla and go with Modx. Sorry Joomla community, your template designs are nice but that is all. Can't believe I wasted so much time with this crap. Apparently I can log in fine to the forums to b i t c h about Joomla, but can't login to my own website to continue using this CMS... hundreds of forums posts read, hundreds probably thousands of complaints all regarding the same stuff. And there is no good fix for it. Seems to only affect some, but not all. Why? I would think the people who designed it could answer that question, but they haven't.

THANK YOU!

This post just saved me :-)

I couldn't login to front end or admin back end, it wasn't giving any errors, just refreshing the page.

I checked /plugins/user/ and sure enough I was missing joomla.php and joomla.xml (I have no clue how?). So, I copied these 2 files back into my install of Joomla 1.5 and then also had to go into phpmyadmin and insert a record back into jos_plugins. This is exactly what I entered into the jos_plugins table:

id: 5
name: User - Joomla!
element: joomla
folder: user
access: 0
ordering: 0
published: 1
iscore: 0
client_id: 0
checked_out: 0
checked_out_time: 0000-00-00 00:00:00
params: autoregister=1

Hope this helps someone else out!

Hi;
I followed all the below steps and I still not been able to login inside joomla panel. I spend many days for this and still working with it. I wonder if anyone have got any new solution for the joomla login issue :-

Here is what i followed

Suggestion n.1)

edited the file administrator/components/com_login/admin.login.php to comment out line 69 (//LoginController::display() )
browsed to the login page.
[tried to login] and got an ‘Invalid token‘ message.
Reedited the [administrator/components/com_login/]admin.login.php file to remove my comment at line 69.
Refreshed the login page in my browser and got the normal login form.
Logged in [successfully].

try this and if it doesn’t work, then:

Suggestion n.2) [user inoxfire]

edit file administrator/components/com_login/admin.login.php [to comment out line 57, // JRequest::checkToken('request') or jexit( 'Invalid Token' );]
browsed to the login page.
[tried to login] and got an ‘Invalid token‘ message.
Reedited the [administrator/components/com_login/]admin.login.php file to remove my comment at line 57.
Refreshed the login page in my browser and got the normal login form.

try this and if it doesn’t work, then:

Suggestion n.3)

Log into phpMyAdmin and navigate to the jos_plugins table.
Look for the "User – Joomla!".
Ensure that it is published as mine was not (set published to 1 just in case).
[Look for] in row "Authentication – Joomla"
Ensure that it is published as mine was not (set published to 1 just in case).

try this and if it doesn’t work, then:
Suggestion n.4)

first check your Super Admin status:
[Open PHPmyAdmin] in the "jos_users" table set SuperAdmin to:
– field "id" – value "62"
– field "gid" – value "25" or "26".
in the "jos_core_acl_aro" table find row for "62":
– field "id" – write this down (should be 10 normally) – this is the "aro_id".
in the "jos_core_acl_groups_aro_map" table find row for "aro_id" = 10
– "group_id" should be "25" or "26".

BONUS:

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‘).

Looking forward to hear from you.

Thank You

Ujjwal

resetting password from database.

_________________
http://www.irishwebexperts.com