phpBB SQL Error - 'phpbb_sessions' is marked as crashed and should be repaired

General errorL
SQL ERROR [ mysqli ]

Table './mysql/phpbb_login_attempts' is marked as crashed and should be repaired [145]
**********************************************************************

Recently, my phpBB forum encountered a SQL error, shown below:

'phpbb_sessions' is marked as crashed and should be repaired [145]

The first thing that I did was to access phpMyAdmin to try an repair the table with the SQL command:

REPAIR TABLE 'phpbb_sessions'

Unfortunately, that does not work. I did some research online and finally, I managed to resolve the issue. It takes a bit of tweaking nonetheless, but it's a fairly simple procedure.

(find out how to resolve this phpBB issue, click here...)

Solution to Resolve phpBB error

If you have access to phpMyAdmin application, under cPanel (from your web hosting service provider), then it would make things a lot simpler.

1. Under your control panel , click on phpMyAdmin icon.

Select your phpBB database, and then click on the "xxx_sessions", where "xxx" represents your phpBB database suffix (In my example, my prefix is phpbb).


Next, click on SQL, located that top of the phpMyAdmin application. This will then open up the dialog box.

4. In the dialog box (shown below), type in the following SQL command.
   
   SQL Code Below

   DROP TABLE IF EXISTS phpbb_sessions;
CREATE TABLE phpbb_sessions (
session_id binary(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
session_forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL,
session_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
session_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
session_ip varbinary(40) DEFAULT '' NOT NULL,
session_browser varbinary(150) DEFAULT '' NOT NULL,
session_forwarded_for varbinary(255) DEFAULT '' NOT NULL,
session_page blob NOT NULL,
session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_time (session_time),
KEY session_user_id (session_user_id),
KEY session_fid (session_forum_id)
);

5. The above code will typically delete the 'phpbb_sessions' table and re-create a new one.

After you have completed the above procedure, you should see no error on the phpBB Forums now.
Fixed..!
***************************************************************************************************************************