bbPress

Simple, Fast, Elegant

bbPress support forums » Troubleshooting

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

(3 posts)
  • Started 1 year ago by pensandpencils
  • Latest reply from pensandpencils
  • This topic is not resolved
  1. pensandpencils
    Member

    Hello,

    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', '192.168.2.4', '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

    Finished!

    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'
    and
    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.

    Thanks

    Posted 1 year ago #
  2. What version MySQL are you using? Prior to 3.23.23 you could not create a full text index.

    Still thinking about this one...

    Posted 1 year ago #
  3. pensandpencils
    Member

    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.

    Cheers

    Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.

Code is Poetry.