Kurt Glen (@yunglion)

Forum Replies Created

Viewing 8 replies - 1 through 8 (of 8 total)
  • hey asboyd do you have phpmyadmin or any other database management? if so select the database and go to execute and execute the same exact code that gave u the error… should be the same as mine. Only this time change the last line to:

    ENGINE = MYISAM DEFAULT CHARACTER SET 'utf8';

    basically changing TYPE to ENGINE. That will correct everything. good luck.

    PS thanks to Super Artsy in the topic below for posting the solution.

    https://bbpress.org/forums/topic/db-posts-table-not-installing?replies=4#post-86225

    hey asboyd do you have phpmyadmin or any other database management? if so select the database and go to execute and execute the same exact code that gave u the error… should be the same as mine. Only this time change the last line to:

    ENGINE = MYISAM DEFAULT CHARACTER SET 'utf8';

    basically changing TYPE to ENGINE. That will correct everything. good luck.

    PS thanks to Super Artsy in the topic below for posting the solution.

    https://bbpress.org/forums/topic/db-posts-table-not-installing?replies=4#post-86225

    thank you a lot man it worked for me.

    thank you a lot man it worked for me.

    what file exactly do i change that in?

    what file exactly do i change that in?

    hey guys its a database problem where the table for posts arent being created any1 have any ideas why? this is the error im getting:

    SQL ERROR!

    >>> Database: xxxxxxxx (127.0.0.1)

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

    hey guys its a database problem where the table for posts arent being created any1 have any ideas why? this is the error im getting:

    SQL ERROR!

    >>> Database: xxxxxxxx (127.0.0.1)

    >>>>>> 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 8 replies - 1 through 8 (of 8 total)