At a loss…….Problems with FULLTEXT and missing files
-
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
- You must be logged in to reply to this topic.