• I am getting this error:

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

    I am hosted on 000webhosting.com with my own domain. Can anybody please help? My site has been down for 2 days now. I have already tried running the Database Repair and the Database Repair and Optimize. Still get the same error. I also have checked the version.php file and it has the correct version 2.9 with the database size of 12329. Also have tried the fix at https://www.clickonf5.org/wordpress/solution-database-upgrade-required/2247 with no luck. Any help would be appreciated/

    Thanks In Advance…

Viewing 6 replies - 1 through 6 (of 6 total)
  • I would go ahead and create that table

    Maybe when you upgraded it didn’t create that table.

    I’m having the same issue but I can’t find directions on how to do it exactly.

    Also make sure you have the correct rights given to your Database user (DB_USER in wp-config.php) to allow creation of databases. Contact your host if you don’t know how to manage that.

    I have full rights for that database. It is a local test install. My problem is that the https://codex.www.ads-software.com/Database_Description#Table:_wp_commentmeta doesn’t provide me with enough information to make the SQL query myself. I can figure out most of it just not all of it.

    Well after some searching I found the file that has the SQL command. It is in wp-admin/includes/schema.php. I’ll test it later as I have other things that I have to do right now.

    All I had to run was the following. If you have a prefix other then “wp_” you will need to change the first line to match what it is.

    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)
    )
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘wp_commentmeta: Table ‘a39xxxx2_blog.wp_commentmeta’ doesn’t exist’ is closed to new replies.