Table ‘wordpress.wp_terms’ doesn’t exist – after upgrade to 2.3

  • Resolved jbenni

    (@jbenni)


    18 years, 7 months ago

    I just updated from 2.1.1 to 2.3, using the SVN method for the first time. (I did follow the instructions for converting to SVN for udpates).

    Things appeared to go fine in the update, and the blog looked okay at first. But when I cleared cache I started getting WP errors:

    • WordPress database error: [Table ‘wordpress.wp_terms’ doesn’t exist]
      SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’) AND tr.object_id IN (100, 96, 99, 98, 97, 93, 92, 91, 90, 89) ORDER BY t.name ASC occurs at top of page
    • WordPress database error: [Table ‘wordpress.wp_terms’ doesn’t exist]
      SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’) AND tr.object_id IN (100) ORDER BY t.name ASC at bottom of entries

    Any suggestions on how to resolve this?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    18 years, 7 months ago

    Have you actually run the database update? Go to /wp-admin, see if it tells you that it has to update.

    Thread Starter jbenni

    (@jbenni)

    18 years, 7 months ago

    Yes, it told me to update, and I did so before encountering this problem.

    Since then, I reinstated my old version (which was actually 2.2.1, not 2.1.1 as originally posted). That also indicated that I needed to update my database, and when it did so I lost my categories. At least I’m back on the air for now.

    Other ideas?

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    18 years, 7 months ago

    The first thing to do would be to restore your database from your backup.

    You did make a backup, right?

    Thread Starter jbenni

    (@jbenni)

    18 years, 7 months ago

    I did make a backup. And happily, I’ve not posted much sinced then. I’ll restore the backup and go through the database update process again.

    Candidly, although I eventually followed all the steps in the instructions I probably played a bit fast and loose with the sequencing. A little knowledge <em>is</em> a dangerous thing.

    I’m optimistic that loading the backup and re-updating the DB will fix what ails me, and if it does I’ll chalk this experience up to user error. But I’ll wait to mark the issue resolved until I verify the result. Probably tonight.

    Thanks for the timely and helpful responses!

    Thread Starter jbenni

    (@jbenni)

    18 years, 7 months ago

    The issue is resolved.

    I re-restored the DB, corrected a privilege issue in the DB, and then reapplied the admin update. (Then of course I reconstructed the entries and comments since the backup.)

    theory for the problem: I had upgraded mySQL, and when I reloaded the database the privileges were out of whack (due to the a change in mySQL). I needed to run the mySQL update utility to fix the privileges BEFORE running the WP admin update. Failure to fixup the privs in mySQL meant that WP didn’t have the authority to create some new tables on update.

    Generally I try to avoid changing multiple things at once, but once in a while I get too cocky. Thanks again for help with this issue.

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

The topic ‘Table ‘wordpress.wp_terms’ doesn’t exist – after upgrade to 2.3’ is closed to new replies.