Can't install bbpress forum on platform pro

[kakadong+ 4]

I follow the steps on your site . and I get the error. SQL ERROR! >>> Database: wordpress (localhost) >>>>>> CREATE TABLE IF NOT EXISTS `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`) ) TYPE = MYISAM DEFAULT CHARACTER SET 'utf8'; >>>>>> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = MYISAM DEFAULT CHARACTER SET 'utf8'' at line 16 Key master email not sent! and when I go to my forum , it is like the pic. So, where is the problem? BTW, I have key all the auth key and auth key salt with what i find in wp-config.php. screen shots: http://www.megapix.com/?p=N3ZCAL63&expid=IBXYYQRDP&expind=1 http://www.megapix.com/?p=SJ4YEU45&expid=IBXYYQRDP&expind=0

[bryan-hadaway 3]

Let me get you some developer support. Thanks, Bryan

[kakadong+ 4]

So..?? you will help me??

[kakadong+ 4]

After deep intergrate with wordpress , the 5 lines disappear . But I key some test article in the forum , I got only topic but no content ... >"<

[kakadong+ 4]

I solve this but don't know if there was any problem ..... I use phpmyadmin to add the sql..

CREATE TABLE IF NOT EXISTS 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_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),
	);
	

then add post_text column manually.... the my posts in the forum appears.. Don't know if it is ok.... ^^"

[Andrew 207]

You shouldn't have to create any tables or anything like that. Did you go through the default bbPress installer UI?

[kakadong+ 4]

yes,I did ... it seems to happen everytime... my problem? I will record then show u what happened..

[kakadong+ 4]

I find out what's wrong! Due to the mysql version , you should edit the original code

TYPE = MYISAM DEFAULT CHARACTER SET 'utf8';

to this one

ENGINE = MYISAM DEFAULT CHARACTER SET 'utf8';

all should be solved!