I’ve been getting some database table related warnings in one of Drupal sites. So I decided to repair database table from phpMyAdmin. Once all tables were repaired I started to see following error:
Table ‘sessions’ is marked as crashed and should be repaired
As it is clear from the error, problem lies in sessions table. Sessions table contains the login sessions.
The solution to this problem is to Empty the sessions table. To do so login into phpMyAdmin, select the sessions table and click on Empty.
You have nothing to loose except that logged in users will be kicked out and they will have to log back in. There might be some errors as well.
One problem I faced was that the admin password was reset to the previous password which is weird. I’ve no clue why this happened.