By newbietodrupal on

There have been many instances of not able to login or access denied.

If you are not able to login even as an "admin".

Don't despair help is at hand.

I suggest this remedy for users using Drupal 5.XX and it may or may not work for other installations

Login into Mysql database command prompt

and type in

"REPAIR table drupal_sessions"

and mostly 99% of the time your error should go away

DO remember that your session table name could be different from drupal_sessions.

⋅ Categories: Drupal 5.x

Comments

deanx0r’s picture

deanx0r commented

Cheers for this post, it just saved me a whole lot of hassle!

For those that don't have SSH access to their server but do have access to PhpMyAdmin, you can do this:

1) Open PhpMyAdmin for your Drupal database.
2) Click on your database name at the top of the left frame.
3) Tick the checkbox next to your sessions table, and select "Repair table" from the select box at the bottom of the page.
4) And that's it!

mangecelle’s picture

mangecelle commented

I tried to do the same but for me it didn't work. Anyway it gave me an hint where to look. I went in to the session table and saw that the uid for my session was 0. I changed it to 1 and then i was able to logon.

Thanks again.

wwam’s picture

wwam commented

Thank you so much.
It works for me.
I'd having a headache for that problem and the suggestion that you gave is really help for me.
Many thanks.

antcw’s picture

antcw commented

This worked for me - table 'sessions' in 6.xx. Just saved me so much time!

jdeg’s picture

jdeg commented

didn't work for me :s

vm’s picture

vm commented

try clearing/emptying/truncating the sessions table which essentially logs everyone and everything out.

skyswather’s picture

skyswather commented

I've been struggling with this for days.

Cleared the sessions table and everything working again.

Thanks.

mickster917’s picture

mickster917 commented

Can someone please tell me how to "clear" the sessions table in MySQL Administrator? I cannot log in to my site on any browser other than Konqueror, and even when I'm in on Konqueror I am missing things like my FCKeditor. When I log in on any other browser (IE, Firefox, Chrome) it gives me the access denied page, but when I check the log it shows "session opened for [user1 account]". I have been stumped on this for a full week now. Desperately need to resolve this asap!!!

mickster917’s picture

mickster917 commented

just wanted to add that I tried to "repair" sessions table w/ no luck.

Mike Evans’s picture

Mike Evans commented

Thank you again for your help with this. I really appreciate it.

Liam Ke’s picture

Liam Ke commented

thanks a lot, a was completely lost and managed to save the website in few minutes, and the cliend didn't even noticed it...