Skip to:
Content
Pages
Categories
Search
Top
Bottom

Installation error – syntax error when try to create 'bb_allposts' table

  • Got thru installation procedure, but one error when tried to create ‘bb_allposts’ table. Error seems to be syntax error??? How do I fix or how do I re-install? If I have to re-install, do I need to remove anything first?

    Hope you can help

    Regards

    S

    SQL ERROR!

    >>> Database: seoirse_eg_wordpress (localhost)

    >>>>>> CREATE TABLE IF NOT EXISTS bb_allposts (

    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!

Viewing 2 replies - 1 through 2 (of 2 total)
  • We are a big china jerseys wholesaler .

    We have

    NFL

    Team player`s number sewn on the chest and sleeves

    Player`s name sewn at the upper back on a sewn down nameplate

    MLB

    We have athletic and collbase jerseys All name and number sewn on .Whith team sign and player number sewn on the chest,Player name sewn on the back of jerseys.

    NHL

    Team flag sewn on the chest

    Player`s name sewn at the upper back on a sewn down nameplate ,Player’s Number swen at downner down the name.

    NBA

    It always nike or adidas brand Jerseys.High quality and all num and name sewb on.

    All of my product is high quality and lowest price . Mix Order Big discount for big order!If you have any questions Please feel free to contact us

    Not the answer I was looking for. If I could mark you down, I would. :-0

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.