Solution for 2.3 database errors / wp_post2cat does not exist

  • If you are getting a database error like this:

    WordPress database error: [Table ‘wp_post2cat’ doesn’t exist]
    SELECT p2c.category_id AS cat_id, COUNT(p2c.rel_id) AS numposts, UNIX_TIMESTAMP(max(posts.post_date_gmt)) + ‘8’ AS last_post_date, UNIX_TIMESTAMP(max(posts.post_date_gmt)) AS last_post_date_gmt FROM wp_post2cat p2c INNER JOIN wp_posts posts ON p2c.post_id=posts.id WHERE 1 = 1 AND posts.post_type = ‘post’ AND posts.post_status = ‘publish’ AND posts.post_date_gmt <= ‘2007-09-19 12:08:25’ GROUP BY p2c.category_id ORDER BY numposts DESC

    or like this:

    WordPress database error: [Table ‘wordpress.wp_post2cat’ doesn’t exist]
    SELECT c.cat_name FROM wp_post2cat p2c INNER JOIN wp_categories c ON p2c.category_id = c.cat_id WHERE p2c.post_id = 218

    or like this:

    WordPress database error: [Table ‘wordpress.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

    or any other database error which contains wp_post2cat or wp_categories, you are using a plugin or theme which is not compatible with WordPress 2.3.

    Example plugins which don’t work:

    It could also be that your theme is causing this error:

    Please double check before posting that you don’t use any incompatible plugins. A list of plugins that work and which won’t work can be found at the WordPress Codex.

Viewing 15 replies - 76 through 90 (of 100 total)
  • grantlairdjr

    (@grantlairdjr)

    I had “errors / wp_post2cat does not exist”, too after upgraded to 2.3.1 from 2.2.2. It turned out that my crawl page plugins caused it. I deactivate this plugins and all is okay now.

    gwlj

    lcarlos

    (@lcarlos)

    I got the same error after upgrading, even using a theme without extra sql queries.
    The problem was elsewhere.
    I just deactivate the “Other Posts From Cat” plugin and everything is fine now.

    leilers

    (@leilers)

    I upgraded to 2.3.1 and got the “wp_post2cat does not exist” error. After reading this thread I went through my plugins and removed them one at a time to see which was causing the problem. The culprit was Category Access.

    Just an FYI.

    Mine did it because I had Ultimate Tag Warrior running. Once I deactivated the plugin everything went to normal.

    Hi folks,

    I’ve read through this thread and found someone else has posted the same thing as below, but no response explaining what it is – could someone tell me what this means and a possible way of fixing it?

    I have reloaded all files very carefully and methodically gone through plugins, also permalinks are updated. In addition,I repaired databases through Myphpadmin and have a compatable theme.

    please advise, should upload my database backups? Would this possibly fix it?

    Thanks in advance

    WordPress database error: [Table ‘ronpembe_wrdp1.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 (377, 376, 375, 374, 373, 372, 371, 370, 369, 368, 367, 364, 363, 362, 361) ORDER BY t.name ASC

    I’m getting the same error as ronaldp423, more or less.

    WordPress database error: [Table ‘wordpress1.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 (125, 124, 123, 122, 120, 117, 116, 115, 114, 113) ORDER BY t.name ASC

    I had version 2.1.something when I upgraded. I made the mistake of not deactivating all my plugins, but the only one I had running was Popstats, and I don’t think that’s the problem. Deactivating all my plugins doesn’t fix the problem. Switching to the default or classic theme also doesn’t help. Uploading my database backup also didn’t help.

    I should also note that when I ran the upgrade script, I got a bunch of error messages. However, when I tried to run it again, it wouldn’t let me, saying that my version was up to date. Is there by any chance a way to force the upgrade script to run again so that I can at least report the error messages here?

    My blog is at this URL: https://www.purevideogames.net/blog/

    Thanks very much.

    st0rmshadow: you could try deleting the plugins using ftp.

    Looking at ronald423’s blog, I think he has resolved his problem. But basically, I wanted to come in here and say that I fixed my problem by going to wp-admin/options and changing the value for db_version back to 6123 and forcing an upgrade. I’m going to have to go back and recategorize all my posts, but my blog isn’t unfeasibly big yet.

    I don’t know maybe its me, but is the answer somewhere in here?

    I think what I did was install a 2.3 theme onto my 2.2 wordpress install now I get the dreaded:

    wp_post2cat does not exist…

    I read this thread twice backwards and forwards… did I miss the fix? or is a restore / backout of the theme in order?

    Your truly,
    Sebastian Rametta

    Thanks!

    Google Sitemaps 2.7.1 plugin was not updated; WordPress latest version did not even advise me of needed update for the above plugin.

    Marevlous! Issue resolve by upgrading above plugin.

    hi,

    getting the same errors – not the first time I’m upgrading either, plugins disabled before upgrade.

    After getting the errors – I got rid of all plugins and custom themes as well – forcing it to use the default theme found in the 2.3.1 folder – but no joy…. the upgrade page is blank – can’t get into the admin – wordpress frontend shows the DB errors…..
    what a headache, shame…

    tried various of the solutions on here – but no luck…. :”(

    even tried a fresh install to a new database – installer file is blank as well… looks like it’s just a broken version?
    (for us lower-end coders at least.. :”(…..)

    I too had these errors…. It wound up being the Google sitemap generator…

    Deactivated, and deleted..problem gone…

    its to bad as this is a great way to get google to index site….

    Ok just deactivate all plugin and activate 1 by 1 to see which plugin show u that error thats what i do ….

    Okay, I am a theme developer and most of my themes are compatible with the 2.0 series, which I see that the WP Devs plan to continue to “support” for a few years to come, so like that old diehard curmudgeon in the Florida Keys who refuses to leave when a hurricane is bearing down on him, I imagine there will be quite a few folks “left behind” who don’t plan to upgrade.

    Should I just offer “two flavors” of each theme? Or supply alternate code/files and keep just one “version” of each theme with that alternate code/files?

    What is the best practice? I’d rather have no themes for 2.3 than have themes breaking all over the place and people screaming for my hide. Any other theme designers out there care to share how they are working around all these versions?

    Regard,

    Joni Mueller

    I get the error all the time and after I checked the DB I noticed that the new WP does not even install those tables. I have created my own, but I still can’t create categories from within the admin panel.

Viewing 15 replies - 76 through 90 (of 100 total)
  • The topic ‘Solution for 2.3 database errors / wp_post2cat does not exist’ is closed to new replies.