Problem #1166 - Incorrect column name ''

CMS & WordPress
1

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 ) ,
KEY comment_approved ( comment_approved ) ,
KEY comment_post_ID ( comment_post_ID ) ,
KEY comment_approved_date_gmt ( comment_approved , comment_date_gmt ) ,
KEY comment_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!

2

well it is telling you a column name is incorrect.

The column name below user_id is blank.

bazz