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

[@chrishajer Participant 17 years, 7 months ago]

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

Still thinking about this one…

[@pensandpencils Member 17 years, 7 months ago]

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