WordPress database error: [Table ‘wp_terms’ doesn’t exist] (WP 2.3)

  • I backed up my database and did the upgrade as normal (generally overwriting the existing files) and I get a *long* list of these errors when I get to the upgrade page:

    WordPress database error: [Table ‘wp_terms’ doesn’t exist]
    INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (‘3’, ‘Development’, ‘development’, ‘0’)

    WordPress database error: [Table ‘wp_term_taxonomy’ doesn’t exist]
    INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES (‘3’, ‘category’, ‘PHP & MySQL Development’, ‘0’, ’38’)

    I have tried different themes. I have tried dropping the tables, reverting to the backup and trying again. I’m not sure what else to try at this point.

    Also, searching google shows cache of a lot of other sites that had this problem but no documentation on how they may have fixed it.

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

  • Try forcing a database upgrade.

    Thread Starter zelut

    (@zelut)

    I tried the forced upgrade as suggested. I get this output during the upgrade:

    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_term_relationships ADD PRIMARY KEY (object_id,term_taxonomy_id)

    WordPress database error: [Table ‘ubuntutu_wrdp1.wp_categories’ doesn’t exist]
    SELECT * FROM wp_categories ORDER BY cat_ID

    WordPress database error: [Table ‘ubuntutu_wrdp1.wp_post2cat’ doesn’t exist]
    SELECT * FROM wp_post2cat

    WordPress database error: [Table ‘ubuntutu_wrdp1.wp_link2cat’ doesn’t exist]
    SELECT * FROM wp_link2cat

    …and the error still persists.

    Based on the various threads you’ve got going, I’d suggest starting from the beginning.

    Restore your database from before the upgrade.

    Delete the WordPress files, download the 2.3 distribution, reupload the files, then do the 2.3 upgrade again.

    I should add, DROP your existing database tables, then restore your database.

    This worked for me – I found it on Osterman’s blog:
    https://osterman.com/wordpress

    You have to run this setup script to complete the upgrade:
    https://www.yourwordpresssite.org/wp-admin/upgrade.php

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WordPress database error: [Table ‘wp_terms’ doesn’t exist] (WP 2.3)’ is closed to new replies.