Skip to Content

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

phpBB Logo

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 cPanel, click on phpMyAdmin icon.
    phpMyAdmin
  2. 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).
    php Sessions
  3. Next, click on SQL, located that top of the phpMyAdmin application. This will then open up the dialog box.
    phpMyAdmin SQL
  4. In the dialog box (shown below), type in the following SQL command.
    SQL Dialog box
    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. Good luck!

 

GoDaddy March 2010 Coupons

This is a compiled list of go daddy coupons my entire IT group uses.

Godaddy domain coupons:
RAD7 : 30% Off .com renewal domains, as many domains as you want
RAD5 : 10% off any order
RUSH3 : $7.49 domains
RUSH1 : 10% off any order

Godaddy hosting coupns:
RUSH20 : 20% Off Hosting (1,2,3 yr accounts)
RUSH1 : 10% Off Monthly hosting accounts

Based on order size:
BUCK2 : $5 off order of $30 or more
BUCKOFF : $10 off order of $40 or more
MOP15 : 15% off order of $75 or more

Unique promo codes:
MOPSSL : $12.99 SSL ( 56% Off )
AUCTION12 : 50% Off Auction accounts

They do not expire so print them.

The only one I cannot find is a .net discount, anyone have one?

could use some tips

Hey I'm new here. I'm sorry if this is thewrong place for this but I was hoping someone here on www.neohide.com would be able to mmg me some information on most realible cpanetworks to send traffic to?

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options