Skip to:

At a loss…….Problems with FULLTEXT and missing files

  • pensandpencils



    I am intergrating BB into WordPress and am hitting a wall.

    When I attempt to go to step three of installation I meet the following text:

    bbPress database error: [Column ‘post_text’ cannot be part of FULLTEXT index]

    CREATE TABLE 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_id (topic_id), KEY poster_id (poster_id), KEY post_time (post_time), FULLTEXT KEY post_text (post_text) ) TYPE = MYISAM

    1. Created table bb_forums

    2. Created table bb_posts

    3. Created table bb_topics

    4. Created table bb_topicmeta

    5. Created table bb_tags

    6. Created table bb_tagged

    7. Changed type of wp_usermeta.meta_key from varbinary(255) to varchar(255)

    8. Changed type of wp_usermeta.meta_value from longblob to longtext

    9. Changed type of wp_users.user_login from varbinary(60) to varchar(60)

    10. Changed type of wp_users.user_pass from varbinary(64) to varchar(64)

    11. Changed type of wp_users.user_nicename from varbinary(50) to varchar(50)

    12. Changed type of wp_users.user_email from varbinary(100) to varchar(100)

    13. Changed type of wp_users.user_url from varbinary(100) to varchar(100)

    14. Changed type of wp_users.display_name from varbinary(250) to varchar(250)

    15. Added index wp_users UNIQUE KEY user_login (user_login)

    bbPress database error: [Table ‘louise.bb_posts’ doesn’t exist]

    INSERT INTO bb_posts (forum_id, topic_id, poster_id, post_text, post_time, poster_ip, post_status, post_position) VALUES (‘1’, ‘1’, ‘1’, ‘

    First Post! w00t.

    ‘,’2007-05-10 15:35:23’, ‘’, ‘0’, 1)

    bbPress database error: [Table ‘louise.bb_posts’ doesn’t exist]

    SELECT post_id, poster_id FROM bb_posts WHERE topic_id = 1 AND post_status = 0 ORDER BY post_time

    bbPress database error: [Table ‘louise.bb_posts’ doesn’t exist]

    SELECT * FROM bb_posts WHERE post_id = 0


    I am doing everything to the letter and cannot see what I’m doing wrong…..

    The only things I change to install is the directory titles from:

    wordpress to ‘journal’


    bbpress to ‘message_board’

    Help would be greatly appreciated. As its driving me mental. All of this just so I can have people sign in to both wordpress and bbpress at the same time.


Viewing 2 replies - 1 through 2 (of 2 total)

  • chrishajer


    What version MySQL are you using? Prior to 3.23.23 you could not create a full text index.

    Still thinking about this one…



    Thanks for the reply.

    I’m running the latest stable MySql and PHP on a Mac apache local testing server if this helps at all.


Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Skip to toolbar