• I get this message failure when trying to repair a database.

    Any ideas?

    ‘wp_commentmeta: Table ‘wrightwingview_1980952.wp_commentmeta’ doesn’t exist’

Viewing 3 replies - 1 through 3 (of 3 total)
  • Some. During install or probably upgrade to 2.9 the new table wp_commentmeta was not created.

    Read here, near the end of the topic:
    http://wordpress.org/support/topic/342965?replies=28

    Thread Starter spinsight

    (@spinsight)

    thanks henkholland. Do I apply this to the admin.php file or somewhere else? Didn’t really understand from that post (seemed to mostly be about another issue). Thank you so much though.

    I was referring to this:

    for those interested, the SQL code you need to run to create the new wp_commentmeta table is:
    
    CREATE TABLE IF NOT EXISTS wp_commentmeta (
    meta_id bigint(20) unsigned NOT NULL auto_increment,
    comment_id bigint(20) unsigned NOT NULL default '0',
    meta_key varchar(255) collate utf8_unicode_ci default NULL,
    meta_value longtext collate utf8_unicode_ci,
    PRIMARY KEY (meta_id),
    KEY comment_id (comment_id),
    KEY meta_key (meta_key)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

    but that’s SQL and if you are not familiar with that, leave it.

    Than click the upgade button in your admin panel and when it says “no need” I believe you get also te choice to re-install (the same version). Try that.

    From where were you trying to repair tables?

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

The topic ‘database unable to repair wordpress 2.9’ is closed to new replies.