MyBB Community Forums

I successfully install mybb on my dedicated server. But it doesn't seem to be working. I tried doing a thread repair, but I received the following message:

Table 'chatautos.thread' doesn't exist

I'm new to dedicated servers, and I'm not sure how to fix this. Any help would be most appreciated.

Thanks,
Matt

Have you edited the database in anyway? Sounds like the table might have been dropped.

I don't think so. It didn't quite work from the beginning.

http://www.chatautos.com/forums/index.php

Can you tell me what version of MySQL and PHP you are running on your server.

MySQL 3.23.58

PHP Version 4.3.10

chatautos Wrote:MySQL 3.23.58

That's very old. Could you or your host upgrade to 4.0.24-standard? That could be why MyBB isn't running right.

Do you think that's what the problem is?

What page are you seeing this error from? And can you take a screenshot of it?

The table called "thread" is not supposed to exist. It's supposed to be called "threads"

chatautos Wrote:Do you think that's what the problem is?

DennisTT is right, the table should be called threads.

Using phpMyadmin run this query.

CREATE TABLE IF NOT EXISTS `chatautos_threads` (
  `tid` int(10) NOT NULL auto_increment,
  `fid` smallint(6) NOT NULL default '0',
  `subject` varchar(120) NOT NULL default '',
  `icon` smallint(6) NOT NULL default '0',
  `poll` smallint(6) NOT NULL default '0',
  `uid` smallint(6) NOT NULL default '0',
  `username` varchar(80) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  `lastpost` bigint(30) NOT NULL default '0',
  `lastposter` varchar(120) NOT NULL default '',
  `views` int(100) NOT NULL default '0',
  `replies` int(100) NOT NULL default '0',
  `closed` varchar(30) NOT NULL default '',
  `sticky` smallint(6) NOT NULL default '0',
  `numratings` smallint(6) NOT NULL default '0',
  `totalratings` smallint(6) NOT NULL default '0',
  `notes` text NOT NULL,
  `visible` smallint(6) NOT NULL default '0',
  `messageindex` text NOT NULL,
  `subjectindex` text NOT NULL,
  PRIMARY KEY  (`tid`),
  KEY `subject` (`subject`),
  FULLTEXT KEY `subject_2` (`subject`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

Now as for the version of MySQL on your server, it could lead to other problems. I'm not sure if MyBB has been tested on any of the MySQL 3.x.x versions. Also it's a huge security risk running an older version of MySQL like that. Trust me when I say someone could issue a command that will kill your database.