Bulletin Board system

[smith Wang]

I got a problem with setup.php in chapter 16. I used the downloaded code, when I run the code, I got message: "The used table type doesn't support FULLTEXT indexes". Here is the code below:
/******* Posts Table *************************************************/
$sql = <<<EOS
CREATE TABLE forum_posts (
  id int(11) NOT NULL auto_increment,
  topic_id int(11) NOT NULL default '0',
  forum_id int(11) NOT NULL default '0',
  author_id int(11) NOT NULL default '0',
  update_id int(11) NOT NULL default '0',
  date_posted datetime NOT NULL default '0000-00-00 00:00:00',
  date_updated datetime NOT NULL default '0000-00-00 00:00:00',
  subject varchar(255) NOT NULL default '',
  body mediumtext NOT NULL,
  PRIMARY KEY (id),
  KEY IdxArticle (forum_id,topic_id,author_id,date_posted),
  FULLTEXT KEY IdxText (subject,body)
)
EOS;
$result = mysql_query($sql);
switch(mysql_errno()) {
  case 1050:
    break;

  case 0:
    $sql = "INSERT INTO forum_posts VALUES (NULL, 0, 1, 1, 0, '" .
           date("Y-m-d H:i:s", time())."', 0, 'Welcome', 'Welcome " .
           "to your new Bulletin Board System. Do not forget to " .
           "change your admin password after installation. " .
           "Have fun!')";
    $result = mysql_query($sql)
      or die(mysql_error());
    break;

  default:
    die(mysql_error());
    break;
}
$a_tables[] = "forum_posts";

Can anyone give me a guide? Thanks,

Smith.

[bigkevracer]

not sure if you're still here, this thread is a very old one, but the reason why it doesn't work is because the default table type doesn't support FULLTEXT indexes. I think this was introduced in MySQL 5.

I fixed the problem with the following:

    /* Posts Table */
    $sql = "CREATE TABLE  forum_posts (
        id int(11) NOT NULL auto_increment,
        topic_id int(11) NOT NULL default '0',
        forum_id int(11) NOT NULL default '0',
        author_id int(11) NOT NULL default '0',
        update_id int(11) NOT NULL default '0',
        date_posted datetime NOT NULL default '0000-00-00 00:00:00',
        date_updated datetime NOT NULL default '0000-00-00 00:00:00',
        subject varchar(255) NOT NULL default '',
        body mediumtext NOT NULL,
        PRIMARY KEY  (id),
        KEY IdxArticle (forum_id,topic_id,author_id,date_posted),
        FULLTEXT KEY IdxText (subject,body)) ENGINE=MyISAM";

Note at the end of the SQL statement, and before the semi-colon, the line "ENGINE=MyISAM"? You need to use this dbase engine to use FULLTEXT keys.

Hope that helps someone.