bbPress

Info

• 3 posts
• 2 voices
• Started 11 months ago by valked1n
• Latest reply from Sithu Thwin
• This topic is not resolved

Tags

• bb_posts
• error
• key master mail not send
• mysql

• Posts in this topic

I got this error problem :(

1. • 
   • valked1n
   • Member

   • Posted 11 months ago #

   SQL ERROR!
   >>> Database: xxxxxxxxxxx (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!

   I am using XAMPP and I tried to integrate it with WP which I installed it into the same database.

   can anyone please help me ?
2. • 
   • Sithu Thwin
   • Member

   • Posted 11 months ago #

   I have the exactly the same problem. I'm using MySql server version 5.5.12 on iis . When I look at database from phpMyadmin. bbPress post tables are missing. So although everything fine on forum, I can't view post nor add new post.
3. • 
   • Sithu Thwin
   • Member

   • Posted 11 months ago #

   I got a hack for it if you are using MySql 5.5.
   It reported on trac at https://bbpress.trac.wordpress.org/ticket/1486
   Change TYPE = MYISAM to ENGINE = MYISAM in your bbPress installation's bb-admin/includes/defaults.bb-schema.php

4. You must log in to post.