Hi,
I am having the same problem. I’m a little confused as to what the fix is?
CREATE TABLE wp_categories
(
cat_ID
bigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_name
varchar( 55 ) NOT NULL default ”,
category_nicename
varchar( 200 ) NOT NULL default ”,
category_description
longtext NOT NULL ,
category_parent
int( 4 ) NOT NULL default ‘0’,
PRIMARY KEY ( cat_ID
) ,
KEY category_nicename
( category_nicename
)
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2
#1064 – 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 ‘DEFAULT CHARSET=latin1 AUTO_INCREMENT=2’ at line 9