Database issue

  • Resolved goinhome50

    (@goinhome50)


    10 years, 2 months ago

    Hi folks — I haven’t asked for help for five years, and I’m at the end of my rope here. I’m moving three sites from server to server within Media Temple — they’ve been most helpful, but they reserve any opinions on WordPress. All three sites haven’t been updated for two or more years. I’ve moved one so far — https://www.goinhome.com. Uploaded database, nothing showed, added the define('WP_ALLOW_REPAIR', true); to the wp-config file and it worked. The database appeared to be fine except for this message:

    “Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.”

    wp_commentmeta: Table 'db32949_goinhome.wp_commentmeta' doesn't exist

    Since I’m of the mind that I should follow directions, I’m doing so and I hope someone can help me out here.

    Many thanks in advance, Linda

Viewing 4 replies - 1 through 4 (of 4 total)

  • Well; comment meta was introduced in WordPress version 2.9. It’s possible your WordPress installs are using versions before 2.9… in which case the table would not exist.

    You can attempt to run the following SQL query to add the comment meta table:

    CREATE TABLE wp_commentmeta (
  meta_id bigint(20) unsigned NOT NULL auto_increment,
  comment_id bigint(20) unsigned NOT NULL default '0',
  meta_key varchar(255) default NULL,
  meta_value longtext,
  PRIMARY KEY  (meta_id),
  KEY comment_id (comment_id),
  KEY meta_key (meta_key)
)

    I’d take a database backup beforehand.. just to be safe.

    Thread Starter goinhome50

    (@goinhome50)

    Hey Josh — thanks. That worked to create the table, for sure. Site still isn’t showing up. I don’t even know where to go from here. Any suggestions are welcome.

    Thread Starter goinhome50

    (@goinhome50)

    Well I’ll be doggone…the site is working. Thanks Josh!

    ?? My pleasure.
    Glad you got it working properly.

    [Marking topic as resolved.]

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database issue’ is closed to new replies.