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_idbigint(20) NOT NULL auto_increment,forum_idint(10) NOT NULL default 1,topic_idbigint(20) NOT NULL default 1,poster_idint(10) NOT NULL default 0,post_texttext NOT NULL,post_timedatetime NOT NULL default ‘0000-00-00 00:00:00’,poster_ipvarchar(15) NOT NULL default ”,post_statustinyint(1) NOT NULL default 0,post_positionbigint(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!
- You must be logged in to reply to this topic.