SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2010
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problem #1166 - Incorrect column name ''

    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. #2
    SitePoint Guru
    Join Date
    Sep 2008
    Posts
    977
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    well it is telling you a column name is incorrect.

    The column name below user_id is blank.

    bazz


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •