http://bbpress.org/forums/ bbPress support forums Topic: At a loss.......Problems with FULLTEXT and missing files en Thu, 20 Nov 2008 12:36:43 +0000 http://bbpress.org/forums/topic/at-a-lossproblems-with-fulltext-and-missing-files#post-7359 Fri, 11 May 2007 09:50:10 +0000 pensandpencils 7359@http://bbpress.org/forums/ <p>Thanks for the reply.</p> <p>I'm running the latest stable MySql and PHP on a Mac apache local testing server if this helps at all.</p> <p>Cheers </p> http://bbpress.org/forums/topic/at-a-lossproblems-with-fulltext-and-missing-files#post-7339 Thu, 10 May 2007 17:35:33 +0000 chrishajer 7339@http://bbpress.org/forums/ <p>What version MySQL are you using? Prior to 3.23.23 you could not create a full text index.</p> <p>Still thinking about this one... </p> http://bbpress.org/forums/topic/at-a-lossproblems-with-fulltext-and-missing-files#post-7338 Thu, 10 May 2007 15:53:00 +0000 pensandpencils 7338@http://bbpress.org/forums/ <p>Hello,</p> <p>I am intergrating BB into Wordpress and am hitting a wall.</p> <p>When I attempt to go to step three of installation I meet the following text:</p> <p>bbPress database error: [Column 'post_text' cannot be part of FULLTEXT index]<br /> 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</p> <p> 1. Created table bb_forums<br /> 2. Created table bb_posts<br /> 3. Created table bb_topics<br /> 4. Created table bb_topicmeta<br /> 5. Created table bb_tags<br /> 6. Created table bb_tagged<br /> 7. Changed type of wp_usermeta.meta_key from varbinary(255) to varchar(255)<br /> 8. Changed type of wp_usermeta.meta_value from longblob to longtext<br /> 9. Changed type of wp_users.user_login from varbinary(60) to varchar(60)<br /> 10. Changed type of wp_users.user_pass from varbinary(64) to varchar(64)<br /> 11. Changed type of wp_users.user_nicename from varbinary(50) to varchar(50)<br /> 12. Changed type of wp_users.user_email from varbinary(100) to varchar(100)<br /> 13. Changed type of wp_users.user_url from varbinary(100) to varchar(100)<br /> 14. Changed type of wp_users.display_name from varbinary(250) to varchar(250)<br /> 15. Added index wp_users UNIQUE KEY user_login (user_login)</p> <p>bbPress database error: [Table 'louise.bb_posts' doesn't exist]<br /> INSERT INTO bb_posts (forum_id, topic_id, poster_id, post_text, post_time, poster_ip, post_status, post_position) VALUES ('1', '1', '1', '</p> <p>First Post! w00t.<br /> ','2007-05-10 15:35:23', '192.168.2.4', '0', 1)</p> <p>bbPress database error: [Table 'louise.bb_posts' doesn't exist]<br /> SELECT post_id, poster_id FROM bb_posts WHERE topic_id = 1 AND post_status = 0 ORDER BY post_time</p> <p>bbPress database error: [Table 'louise.bb_posts' doesn't exist]<br /> SELECT * FROM bb_posts WHERE post_id = 0</p> <p>Finished!</p> <p>I am doing everything to the letter and cannot see what I'm doing wrong.....</p> <p>The only things I change to install is the directory titles from:</p> <p>wordpress to 'journal'<br /> and<br /> bbpress to 'message_board'</p> <p>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.</p> <p>Thanks </p>