By chris48b on

I'm using an old version of Drupal which has been working steadily for me for a few years now.

For some reason today I was denied access with my login. I checked and the login is definitely correct. I also tried using an alternate user login and password and was also denied. The site works as far as navigation and search go, but no one can write new comments to it (which you usually don't need to be logged in to do).

I had a login problem once before and solved it by replacing the sessions table with a backup. I tried that this time and had no luck. I also tried uploading the entire SQL backup from two days ago, when the site was working fine, and I still can't log in.

Since I can neither log in or write a new comment to the site there seems to be some problem with the database accepting new input. Can anyone help pinpoint the problem here?

Could it have anything to do with my web service provider, or is it just an SQL issue?

Thanks!

Comments

shady_gun’s picture

shady_gun commented

Most probably one of the mysql tables has crashed .. Enable error reporting and check which table has crashed ...

chris48b’s picture

chris48b commented

Wouldn't I be able to see that the table was crashed when viewing my database tables in MySQL?

I tried repairing all my tables but that didn't help.

Besides, wouldn't the backup tables from three days ago work well enough to at least let me login as I was doing at that time?

chris48b’s picture

chris48b commented

Also, I can write directly to my SQL database tables, but can't do any writing to them through the site. Is there some connection that's been dropped between my site and my database?

shady_gun’s picture

shady_gun commented

Check error log table for the latest entry and see if you can find a clue there ..

chris48b’s picture

chris48b commented

I don't see an error log table! Where is this found in MySQL?

kazah’s picture

kazah commented

Do you solvе your problem. If so....how?