MyBB Community Forums

Full Version: Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
mySQL error: 1016
Can't open file: 'mybb_sessions.MYI'. (errno: 145)
Query: SELECT sid,uid FROM mybb_sessions WHERE sid='0' AND ip='24.82.24.27'

What's wrong?????
I can't get to the main page.. but I can login to the admin panel??
The database table mybb_session seems to be corrupted. Please try to repair the table via phpMyAdmin. See if that fixes your problem.
How to repair it? I'm at the mybb_session page in phpMyAdmin
Please see the following tutorial on how to do it with PHPMyAdmin: http://paulstamatiou.com/2006/05/31/how-...hpmyadmin/
If it keeps on getting corrupted, what possibly go wrong?

Other databases are working alright.. but the database for my forum is acting very weird (won't even let me repair the tables now)
In this case you have to cantact the support of your host because there's not much we can do from here. What you can try: Upload the attached file into your forum's root directory and open it in your browser.
wont work.. can't access the index page

It's off-topic now, but in my phpMyAdmin, It says (and only) my sessions table is "in-use". Is it anything wrong with that?
Yeah, that's wrong. As I said before you should contact your host about that issue. If there's nothing they can do you can try to recreate the sessions table using the following queries:
DROP TABLE IF EXISTS mybb_sessions;
CREATE TABLE mybb_sessions (
  sid varchar(32) NOT NULL default '',
  uid int unsigned NOT NULL default '0',
  ip varchar(40) NOT NULL default '',
  time bigint(30) NOT NULL default '0',
  location varchar(150) NOT NULL default '',
  useragent varchar(100) NOT NULL default '',
  anonymous int(1) NOT NULL default '0',
  nopermission int(1) NOT NULL default '0',
  location1 int(10) NOT NULL default '0',
  location2 int(10) NOT NULL default '0',
  PRIMARY KEY(sid),
  KEY location1 (location1),
  KEY location2 (location2)
) TYPE=MyISAM;