• Greetings,

    I just finished upgrading to 2.3 and was met with the following:
    —————————
    WordPress database error: [Table ‘affbiz_wrdp1.wp_terms’ doesn’t exist]
    SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘category’) AND t.slug = ‘wp-admin’ ORDER BY t.name ASC

    WordPress database error: [Table ‘affbiz_wrdp1.wp_terms’ doesn’t exist]
    SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘category’) AND t.slug = ‘wp-admin’ ORDER BY t.name ASC

    WordPress database error: [Table ‘affbiz_wrdp1.wp_term_relationships’ doesn’t exist]
    SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND post_name = ‘upgradephp’ AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (‘0’) AND post_type = ‘post’ GROUP BY wp_posts.ID ORDER BY post_date DESC
    ——————————

    Tell me what to do and I will do it…

    Thanks in advance,

    JJH

Viewing 9 replies - 1 through 9 (of 9 total)
  • Did you run the upgrade script. It’s Step 2 here.

    Makes me think the new terms database tables didn’t get created.

    If necessary, try forcing a database upgrade.

    If that doesn’t work you might have to restore to your database backup and do the upgrade again.

    See:
    How do I force a database upgrade?

    I am getting somewhat similar errors when posts or comments are published…

    I got this error when I tried to write a comment to one of my posts:

    WordPress database error: [Table ‘whatwedig.wp_post2cat’ doesn’t exist]
    SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = ‘publish’ GROUP BY cat_ID

    I tried to force a database upgrade, but got this error:

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

    Then I just noticed in my Manage Posts Page, the last post I posted says under the Category Column:

    WordPress database error: [Table ‘whatwedig.wp_categories’ doesn’t exist]
    SELECT categories.cat_ID FROM wp_categories as categories WHERE categories.category_nicename = ‘blog’ LIMIT 1

    Everything is still posting and the site works fine, but users are redirected to these error pages when posting comments. Any thoughts?

    I am getting somewhat similar errors

    Not true.
    Your error is completely different and it is addressed in one of the “sticky” posts on the main page of the forum.

    Thanks, I checked it out and I had not updated Google Site Maps.

    Thanks!

    Thread Starter ibuildtraffic2

    (@ibuildtraffic2)

    OK…I ran the “Forced Upgrade” and upon successful completion was presented with the following:

    ———————————————–

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

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

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

    Your WordPress database has been successfully upgraded!

    ———————————————–

    Note that is also says the db was successfully upgraded….

    Next task?

    And thank you for taking time out of your day to help meyou are appreciated.

    Thread Starter ibuildtraffic2

    (@ibuildtraffic2)

    I began deactivating plug-ins and have managed to get all of the on-page visible code to go away except one instance-in the top left corner-that says:

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

    Do I just continue deactivating plug-ins?

    Thanks much!

    jjh

    There is no wp_categories table in WP 2.3 – so it must be either a plugin or a line of custom code calling for that table.
    It might simply be the theme is not compatible with 2.3

    Thread Starter ibuildtraffic2

    (@ibuildtraffic2)

    Moshu…

    I’ve deactivated each and every plug-in. I’ve even removed some of the suspect ones using phpMyAdmin/wp_options.

    As of right now I have no plug-ins activated and maybe 5 total are even uploaded/installed.

    Theme is 2.3 compatible…

    What next?

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

The topic ‘WordPress DB Error-**.wp_terms doesnt exist’ is closed to new replies.