SOLVED: Cant log in as admin in 1.5.1

[fableman2]

When did it happen ?
I was working with my site just turning off some modules and playing around. Iam used to joomla since a few years back, I did it all the day and got logged off a few times but worked to login again, then all of a sudden it was impossible to log back in as admin. (my site is not even on internet yet soo not exploited or anything.haha)

This is what I been trying todo soo far and Iam going crazy over this!!!!

System: Joomla 1.5.1./ Linux Centos 5

I tried using Firefox instead of IE7 still not working.

I checked my sql tables if I needed to set published to 1, but it is already set to 1 !!!

Here my table:

id 1
name Authentication - Joomla
element joomla
folder authentication authentication
access 0
ordering 1
published 1
iscore 1
client_id 0
checked_out 0
checked_out_time 0000-00-00 00:00:00

I turned on debug in configuration.php and this is my output from administration screen after I typed admin and my correct password. (no warning about wrong user or pass) just sent back to login screen again.

Profile Information
Application afterLoad: 0.001 seconds, 0.27 MB
Application afterInitialise: 0.040 seconds, 2.19 MB
Application afterRoute: 0.040 seconds, 2.19 MB
Application afterDispatch: 0.055 seconds, 2.70 MB
Application afterRender: 0.057 seconds, 2.78 MB
Memory Usage
2950840
8 queries logged
SELECT *
FROM jos_session
WHERE session_id = 'pqliffisu095inq65q8kqk3087'
DELETE
FROM jos_session
WHERE ( time < '1010374032' )
SELECT *
FROM jos_session
WHERE session_id = 'pqliffisu095inq65q8kqk3087'
UPDATE jos_session
SET `time`='1010374932',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='1',`data`='__default|a:8:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1010374050;s:18:\"session.timer.last\";i:1010374067;s:17:\"session.timer.now\";i:1010374932;s:22:\"session.client.browser\";s:50:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:70:\"/home/fr/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"674663fbe7d96ae4a7167b6b1895cb8c\";}'
WHERE session_id='pqliffisu095inq65q8kqk3087'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 1
ORDER BY position, ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
Language Files Loaded
/home/fr/public_html/administrator/language/en-GB/en-GB.ini 1
/home/fr/public_html/administrator/language/en-GB/en-GB.plg_system_debug.ini 1
/home/fr/public_html/administrator/language/en-GB/en-GB.com_login.ini 1
/home/fr/public_html/administrator/language/en-GB/en-GB.mod_login.ini 1
/home/fr/public_html/administrator/language/en-GB/en-GB.tpl_khepri.ini 1
Untranslated strings
None


PLEASE HELP!!!!!!!!!!!!!!!!!!!

[fableman2]

I found myself how to fix it and how to recreate the problem..

How to recreate the problem:

If you go into the Plugin manages and then un publish the plugin: User - Joomla!
Then it will be impossible to login as admin after that.

Solution:
Use a mysql editor, I used http://www.webmin.com

Select your Joomla database then table: jos_plugins

Show data in table jos_plugins

Then Edit when you find field: User - Joomla!

And set published 1

Save and now you can login again.


Developers:
Ya need to fix soo admin logins don't depend on any thing you can unpublish.



Sorry for bad english again.. Happy hacking in the mysql tables

[shimanotaka]

Thank you! You saved my day!

I had been messing around with Jfusion and SMF yesterday, and after setting up Jfusion, I couldn't log in as admin anymore. Thanks to your help, I can now log in again! It would never have occured to me to go and "hack" the database manually.

EDIT: This solution is not restricted to J!1.5.1. I have J!1.5 and it should probably work just as well for any other Joomla release.

[dougbedford]

I was already set to 1 in my database, yet i'm having the same problem.

[zlajavt]

It worked for me too!
I did have to export jos_plugins table from my other joomla site - database, so I save it as a file on my computer. Then i went to my actual joomla site and dropped jos-plugins table (red "X" in php MyAdmin), imported saved one from my working site, and I could see that joomla user was set to "1" as published instead of "0"

I did it this way because manually did not work for me, i was getting all kinds of errors.

Seconds later I was able to login.

[ripplegraphics]

Just had the same thing happen to me. Thanks for this post! It helps me. I did not drop and then import a backup table, but I did seem to have to save the database table edit twice. Hope this helps someone else!

[m4verick]

I found myself how to fix it and how to recreate the problem..
Solution:
Use a mysql editor, I used http://www.webmin.com

Select your Joomla database then table: jos_plugins

Show data in table jos_plugins

Then Edit when you find field: User - Joomla!

And set published 1

Save and now you can login again.

works perfect! thanks dude

[giganull]

Thanks for the info. FWIW my problem wasn't with the User - Joomla! setting but with with gmail authentication and open ID ditto. I had turned open ID authentication on and experimented with it. Everything worked fine until I turned gmail authentication on. After a couple of hours things got a little sticky. Thumping of fists and biting of keyboards commenced.
As per your instructions I turned open ID and gmail off and now I can get back to work. THANKS again.

[Corleone187]

THANKS YOU SAVED THE DAY MY FRIEND!!!!!!!!!!!!

[Corleone187]

YAY fableman2!

[cooterrules]

You rock!

Saved my butt.

Tanks alot!!!!!!!!!!!!