Happiness is a warm login prompt

After a MySQL crash (or PHP upgrade) at my hosting provider, my site started to misbehave. Badly. Drupal refused any login attempt, which is, as you can imagine, quite impractical. For days, I searched the Drupal forums, tried every hint of every problem which looked somehow like mine, but without any luck. I got my site back in hand after :

* backup database and website pages
* drop the database, remove all Drupal webpages, and reinstall.
* create a new admin user
* log out
* drop the entire database again, but keep the users table.
* Restore the database except for the users table
* Restore old Drupal pages

There might be some things which can look weird, but I hope to correct those in the next couple of days...

partha Mon, 09/10/2007 - 07:03

Hi,

Can you please elaborate on your steps for getting back to a sane state?

I am facing the same kind of login problems with Drupal.

Thanks,
Partha.

kristof Mon, 09/10/2007 - 18:44

In reply to by partha

Actually, the trick is to recreate the users table. I did this by reinstalling from scratch, and thereby registring my admin user again for the first time. That way, your users table is valid (so you can log in), but your content is now gone.
Restore then everything back from your old database, but keep the users table intact (don't overwrite it with the previous version, or you will not be able to login again.)