
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.
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.
- Under cPanel, 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.

- In the dialog box (shown below), type in the following SQL command.

SQL Code BelowDROP 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)
);
- 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?
I have troubles with forum
I'm trying to open forum but sometimes there are no images on it :(
Thanks!
A really big THANK YOU for outlining how to fix the sessions_table.
Post new comment