Skip to:
Content
Pages
Categories
Search
Top
Bottom

Forum Replies Created

Viewing 1 replies (of 1 total)
  • I just spent a few hours on this and finally got it to work by manually creating the [prefix]_bb_posts table with the SQL from jdpark7. But, the single-quotes in the statement had to be re-typed to get it to work. Note, my db prefix is wp1_:

    CREATE TABLE IF NOT EXISTS wp1_bb_posts (
    post_id bigint(20) NOT NULL auto_increment,
    forum_id int(10) NOT NULL default 1,
    topic_id bigint(20) NOT NULL default 1,
    poster_id int(10) NOT NULL default 0,
    post_text text NOT NULL,
    post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,
    poster_ip varchar(15) NOT NULL default ”,
    post_status tinyint(1) NOT NULL default 0,
    post_position bigint(20) NOT NULL default 0,
    PRIMARY KEY (post_id),
    KEY topic_time (topic_id, post_time),
    KEY poster_time (poster_id, post_time),
    KEY post_time (post_time),
    FULLTEXT KEY post_text (post_text)
    ) ENGINE = MYISAM DEFAULT CHARACTER SET ‘utf8’;

    Whew!

Viewing 1 replies (of 1 total)
Skip to toolbar