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!
- You must be logged in to reply to this topic.