1
I've been running XOOPS 2.0.14 successfully since around February. Suddenly today, I haven't been able to log in as an admin or as a regular user. After attempting, I'm forwarded to the normal "Thank you for logging in" screen. When trying to log in with a made up username and password, I get an error, so I don't think there's something wrong with an error page (like the language file is messed up or something). On the "Who's Online" block, it says no users are logged in, but on the user info page, it says that the user was last logged in when I tried to log in (in other words, even though it says no users are logged in, it says that I last logged in this minute). I cleared my cookies, tried using IE instead of FF, but nothing. I can tell from my referrer log that another user kept trying to log in but couldn't.
I'm fairly certain this just happened today, and that I was the last person to be able to log in. I didn't alter any files today. I changed a stylesheet last night. The only thing I did with my entire hosting account is create an ftp account, a new database, and a new user.
I'm assuming it's a problem with the cookies. Is there a way to test the cookies? After clearing my cookies and trying again, this is what the cookie says:
Name: PHPSESSID
Content: 0a5ba78cc04678f981625b8b6068cb4e
Path: /
Send for: Any type of connection
Expires: at end of session
edit:
I searched using google and different terms and was able to find the solution here:
https://xoops.org/modules/newbb/viewtopic.php?topic_id=56423&forum=1&post_id=2496So here it is if anyone finds this post in the future:
Quote:
vaughn:
just go into phpmyadmin
select the table, then scroll down and you'll see a selection box, select repair table and then hit submit.
alternatively goto the query window and type REPAIR TABLE xoops_session
and you're done
*remember to change the prefix if your tables don't use xoops_