Skip to:
Content
Pages
Categories
Search
Top
Bottom

I got this error problem :(

  • 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 ?

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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.

    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

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Skip to toolbar