Hi,
I’m trying to import my old DB to a new host but this error appears:
CREATE TABLE IF NOT EXISTS
wp_comments
(
comment_ID
bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
comment_post_ID
bigint( 20 ) unsigned NOT NULL default ‘0’,
comment_author
tinytext NOT NULL ,
comment_author_email
varchar( 100 ) NOT NULL default ‘0’,
comment_author_url
varchar( 200 ) NOT NULL default ‘0’,
comment_author_IP
varchar( 100 ) NOT NULL default ‘0’,
comment_date
datetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_date_gmt
datetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_content
text NOT NULL ,
comment_karma
int( 11 ) NOT NULL default ‘0’,
comment_approved
varchar( 20 ) NOT NULL default ‘1’,
comment_agent
varchar( 255 ) NOT NULL default ‘0’,
comment_type
varchar( 20 ) NOT NULL default ‘0’,
comment_parent
bigint( 20 ) unsigned NOT NULL default ‘0’,
user_id
bigint( 20 ) unsigned NOT NULL default ‘0’,
`` enum( ‘Y’, ‘N’ ) NOT NULL default ‘N’,
PRIMARY KEY (comment_ID
) ,
KEYcomment_approved
(comment_approved
) ,
KEYcomment_post_ID
(comment_post_ID
) ,
KEYcomment_approved_date_gmt
(comment_approved
,comment_date_gmt
) ,
KEYcomment_date_gmt
(comment_date_gmt
)
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =24076;
#1166 - Incorrect column name ‘’
I don’t know where is the problem. Sorry for my newbies questions.
Thanks!