Skip to:
Content
Pages
Categories
Search
Top
Bottom

SQL error!


  • jzp820927
    Member

    @jzp820927

    SQL error!

    >>> database:bbpress (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

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

  • zaerl
    Participant

    @zaerl

    Probably you have a very old version of MySQL, something like v3.20 which doesn’t support utf8. What version are you using?


    zaerl
    Participant

    @zaerl

    Probably you have a very old version of MySQL, something like v3.20 which doesn’t support utf8. What version are you using?


    jzp820927
    Member

    @jzp820927

    Apache version:2.2.17 (Win32)

    PHP version:php-5.3.5-Win32-VC6-x86

    Mysql version:MySQL Community Server 5.5.8

    OS:Win XP pro SP3


    jzp820927
    Member

    @jzp820927

    Apache version:2.2.17 (Win32)

    PHP version:php-5.3.5-Win32-VC6-x86

    Mysql version:MySQL Community Server 5.5.8

    OS:Win XP pro SP3

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