[tanvir]

I also had the same problem as @dwwilkin.

I enable the Wp_debug and found that when buddypress installing the forum it’s unable to create a table name wp_bb_post. So whenever someone try to open the open the post’s under topic it returns WPDB error that $bbdb->posts table not found.

I looked at bb-adminincludesdefaults.bb-schema.php for the crate table command. I found at line 40, the post table use ‘FULLTEXT KEY’ which is only supported by ‘MYISAM’.

This is the original query:

$bb_queries = “CREATE TABLE IF NOT EXISTS `$bbdb->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_time` (`topic_id`, `post_time`),
KEY `poster_time` (`poster_id`, `post_time`),
KEY `post_time` (`post_time`),
FULLTEXT KEY `post_text` (`post_text`)
) TYPE = MYISAM;”;

This query is returning error ion MySQL 5. So, I change the last line of the query to;

‘) ENGINE = MYISAM’

And it works. Now I’m able to create post under any topic.

So in summary simplest fix for the issue is:

1. Create a table on your wordpress database using following query

CREATE TABLE IF NOT EXISTS `wp_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_time` (`topic_id`, `post_time`),
KEY `poster_time` (`poster_id`, `post_time`),
KEY `post_time` (`post_time`),
FULLTEXT KEY `post_text` (`post_text`)
) ENGINE = MYISAM;

2. Refresh the forum topic page in front-end.

[tanvir]

I was Upgrading from 1.1.1 to 1.1.2

Just install the Buddypress using WPMU plugin installer and try to upgrade it after get the update notification of 1.1.2