MyBB Community Forums

[ Error ]
mySQL error: 1016
Can't open file: 'mybbm_sessions.MYI'. (errno: 145)
Query: SELECT sid,uid FROM mybbm_sessions WHERE sid='0' AND ip='125.234.240.2'

[Fix]

Step 1 : delete table mybbm_sessions on database error
Step 2:
insert new table
CREATE TABLE mybb_sessions (
sid varchar(32) NOT NULL default '',
uid int(10) 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)
)

Thank

There is not need to drop the table then insert the new table.

simply from the phpmyadmin repair the tables, especially that one, by looking at the right frame scroll down. find the drop-down menu that says with selected: and choose repair table.

this is not a bug with mybb.

regards