Re: Topics created, posts counted, but no posts shown
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
