Admin session expired - can't log in (Jfish language bot)

[zuze]

HI!
After installing J!Fish and having issue with site visitor not being able to view the site in default language, I followed suggestion to change some setting in Multi lingual abstraction layer bot.

I selected option for site default language. After this I can not log in, I get Admin Session Expired message.

Is there any solution? I can access Joomla files via FTP but I have no access to db, unless I am going through Joomla. I am in a major picke here...

[ot2sen]

Hi zuze,

Not sure if its related, but theres a known fix for 'Admin session problem' here:
http://forum.joomla.org/index.php/topic,200725.0.html

[zuze]

I did install patch beforehand, and it solved problem of being logged out all the time by the site.

This is different , I can't even log in, I immediately get message that session is expired.

I am using Joomla 1.0.13 and J!Fish 1.7


I tried to duplicate this problem on local server, but everything still works good. I do not have the Admin patch suggested above installed on local server. The patch and mambots particular setting might not be compatible. I got to do some file replacing .... I'll post results.

[Elamintal]

Thank you for the link to the patch! However, I uploaded the patch and it is not working for some reason. I currently have this problem of receiving "Admin Session Expired" when I attempt to login on two different sites... one using 1.0.13 and the other using 1.0.15. I'm pretty much stuck for now. Any other help would be great!

Elamintal

[hadin]

me too have a same error message.
my version is 1.0.12a, but not using jfish component.
i guess the problem come from these conditionals :
if ( $link && strpos( $link, 'index2.php?option=com_' ) === 0 && $_VERSION->SITE == 1 && @$mosConfig_admin_expired === '1' )

==> at line 825 of joomla.php at my joomla version

either the $link is not redirect to 'index2.php?option=com_' or other conditionals is not occupied. [malicious redirected at administrator/index.php .. ?] .

[benassis]

Hi zuze,

Not sure if its related, but theres a known fix for 'Admin session problem' here:
http://forum.joomla.org/index.php/topic,200725.0.html

Hi,

I just applied the patch to solde the same problem "Admin Session Expired" with no positive result. In fact, the patch changed nothing at all.

Anybody else found a fix untill now ?

[hadin]

my problem has been solved ... it's because of my session table corrupted. I dropped the table then created with a new one.

[poodawgg]

my problem has been solved ... it's because of my session table corrupted. I dropped the table then created with a new one.
my problem has been solved ... it's because of my session table corrupted. I dropped the table then created with a new one.

How did you create a new one?

[hadin]

or simply you repair it with phpmyadmin function.
checked any tables corrupted, and then select on "When selected" option ==> "Repair Table".

[poodawgg]

or simply you repair it with phpmyadmin function.
checked any tables corrupted, and then select on "When selected" option ==> "Repair Table".

I repaired jos_session at nothing change i still cant log in to my admin...
how do i tell if a table is currupted?

[hadin]

first. have you checked if any of your tables being "in use" a.k.a corrupted?
then you must fix those tables with "repair table".
in generics way, in phpmyadmin select your database, select all tables and then select repair table at the bottom options.
second. if the first way doesnt work out, and indeed the jos_session is damaged, just drop the jos_session table (or delete jos_session.MYI and jos_session.MYD), and create another one with this sql script. run this sql query with phpmyadmin :
CREATE TABLE `jos_session` (
`username` varchar(50) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) ENGINE=MyISAM;

i was quite experience these same situations recently, and i merely did the above step to fix it out. and yes, i can re-login to backend admin after the jos_session was fixed.

[poodawgg]

first. have you checked if any of your tables being "in use" a.k.a corrupted?
then you must fix those tables with "repair table".
in generics way, in phpmyadmin select your database, select all tables and then select repair table at the bottom options.
second. if the first way doesnt work out, and indeed the jos_session is damaged, just drop the jos_session table (or delete jos_session.MYI and jos_session.MYD), and create another one with this sql script. run this sql query with phpmyadmin :
CREATE TABLE `jos_session` (
`username` varchar(50) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) ENGINE=MyISAM;

i was quite experience these same situations recently, and i merely did the above step to fix it out. and yes, i can re-login to backend admin after the jos_session was fixed.

thanks for the help

i tried both steps and still get the error

"Admin Session Expired"

[alig8r]

I have this same issue. Joomla 1.0.15 I tried the dropped the session table and recreated but no resolution. It happened right after I changed the session time out in the backend config. Now I can't even ftp a corrected config file. Is there any way to override?

[purro]

I have deleted and recrated the jos_session as you say and still the same error, what else can I do?
Thanks
Error:
DB function failed with error number 145
Table './kinesiol_joom1/jos_session' is marked as crashed and should be repaired SQL=SELECT session_id FROM jos_session WHERE session_id = '0dace59a2010762c345608d1df979bea'
SQL =

SELECT session_id
FROM jos_session
WHERE session_id = '0dace59a2010762c345608d1df979bea'

[purro]

When I try to log in my admninistrator (the only page I can see) the next message appear for 2 seconds, before refreshing the administrator logging page.

DB function failed with error number 145
Table './kinesiol_joom1/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO jos_session SET time = '1239450006', session_id = 'a9343a0840c2c581671ae53b952bebc7', userid = 146, usertype = 'Super Administrator', username = 'html'DB function failed with error number 145
Table './kinesiol_joom1/jos_session' is marked as crashed and should be repaired SQL=DELETE FROM jos_session WHERE userid = 146 AND username = 'html' AND usertype = 'Super Administrator' AND session_id != 'a9343a0840c2c581671ae53b952bebc7' AND guest = 1 AND gid = 0

I try everything, could be something (any component) that may be corrupting my jos_session table anytime. Could I delete unnesessary component withaut being logged in joomla?
Thanks

[sharo]

Hey, THANKS to you hadin.

I don't know why, I never had (since 2 years) a problem with admin auth, but the jos_session table had a problem. I used your simple SQL request, and it works now. It's great... So thank you for the idea