MyBB Community Forums

I get the following error when I tryto enter mybb

mySQL error: 1016
Can't open file: 'mybb_sessions.MYI'. (errno: 145)
Query: SELECT sid,uid FROM mybb_sessions WHERE sid='0' AND ip='12.226.113.254'

I am new to mybb, and am totaly lost
any suggestions ???
Dave

Your mybb_sessions table is corrupt. You need to run the repair command in phpMyAdmin or ask your host to do it for you.

Tikitiki Wrote:Your mybb_sessions table is corrupt. You need to run the repair command in phpMyAdmin or ask your host to do it for you.

the file referred to doesnt show up???


impboatc_p_mybb table listingBelow is a list of tables contained in the impboatc_p_mybb database, and the status associated with each table. If the status is not 'OK', you can click on the Repair link to attempt to repair the table.
Table Name Status
mybb_adminlog OK Repair
mybb_adminoptions OK Repair
mybb_announcements OK Repair
mybb_attachments OK Repair
mybb_attachtypes OK Repair
mybb_awaitingactivation OK Repair
mybb_badwords OK Repair
mybb_banned OK Repair
mybb_datacache OK Repair
mybb_events OK Repair
mybb_favorites OK Repair
mybb_forumpermissions OK Repair
mybb_forums OK Repair
mybb_forumsubscriptions OK Repair
mybb_groupleaders OK Repair
mybb_helpdocs OK Repair
mybb_helpsections OK Repair
mybb_icons OK Repair
mybb_joinrequests OK Repair
mybb_moderatorlog OK Repair
mybb_moderators OK Repair
mybb_polls OK Repair
mybb_pollvotes OK Repair
mybb_posts OK Repair
mybb_privatemessages OK Repair
mybb_profilefields OK Repair
mybb_regimages OK Repair
mybb_reportedposts OK Repair
mybb_reputation OK Repair
mybb_searchlog OK Repair
mybb_settinggroups OK Repair
mybb_settings OK Repair
mybb_smilies OK Repair
mybb_templates OK Repair
mybb_templatesets OK Repair
mybb_themes OK Repair
mybb_threadratings OK Repair
mybb_threads OK Repair
mybb_threadsread OK Repair
mybb_userfields OK Repair
mybb_usergroups OK Repair
mybb_users OK Repair
mybb_usertitles OK Repair
return to database setup


how do i create a entry in the data base for this file?

Your not supposed to setup a file? You just need to run the repair command on the tables.

Tikitiki Wrote:Your not supposed to setup a file? You just need to run the repair command on the tables.

the only repair commands available are a check box next to each database entry, I have repaired all of these, but the entry for mybb_sessions.myi is completely missing from my dbase

You seem to have removed mybb_session table from your database. Please run the following query in phpMyAdmin

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',
  loginattempts tinyint(2) NOT NULL default '1',
  failedlogin bigint(30) NOT NULL default '0',
  PRIMARY KEY(sid),
  KEY location1 (location1),
  KEY location2 (location2),
  KEY time (time),
  KEY uid (uid)
) TYPE=MyISAM;

Error
SQL query:

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',
loginattempts tinyint( 2 ) NOT NULL default '1',
failedlogin bigint( 30 ) NOT NULL default '0',
PRIMARY KEY ( sid ) ,
KEY location1( location1 ) ,
KEY location2( location2 ) ,
KEY time( time ) ,
KEY uid( uid )
) TYPE = MYISAM ;



MySQL said:

#1050 - Table 'mybb_sessions' already exists

You just said mybb_sessions doesn't exist....

anyway run this query

REPAIR TABLE mybb_sessions

Thank you, you are a GOD!!!!!!!!

Dave

lol, no problem