1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

WordPress database error

Discussion in 'WordPress' started by amiecn, Dec 18, 2007.

0
  1. #1
    Anyone have any idea what happened?

    I installed a new theme...and some of my categories disappeared so I re-added them and went back to put posts in the categories instead of uncategorized and got this error when I tried to edit the category.

    WordPress database error: [Table 'amiecn14_wrdp1.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

    WordPress database error: [Table 'amiecn14_wrdp1.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
     
    amiecn, Dec 18, 2007 IP
  2. Rapidrobert

    Rapidrobert Peon

    Messages:
    160
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Did you recently upgrade to WP 2.3.1? If so, you'll need to recreate wp_post2cat and possibly wp_categories. Do you have a database backup?
     
    Rapidrobert, Dec 18, 2007 IP
  3. CypherHackz

    CypherHackz Well-Known Member

    Messages:
    447
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    155
    #3
    make sure you run the upgrade script. and if you install ultimate tag worrior, uninstall it.

    -cypher.
     
    CypherHackz, Dec 18, 2007 IP
  4. amiecn

    amiecn Well-Known Member

    Messages:
    360
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    120
    #4
    I didn't upgrade...its a new installation (as of about a month ago) and I didn't have ultimate tag warrior but I had a few others. I deleted almost all of them, but the problem remains. I was told that the database would have to be repaired, as it would not resolve itself.
     
    amiecn, Dec 20, 2007 IP
  5. mann3r

    mann3r Peon

    Messages:
    1,416
    Likes Received:
    100
    Best Answers:
    0
    Trophy Points:
    0
    #5
    why delete all the plug-in? Just upgrade the plug-in to its new compatible version, like sitemap plug-in. try it
     
    mann3r, Dec 20, 2007 IP
  6. CypherHackz

    CypherHackz Well-Known Member

    Messages:
    447
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    155
    #6
    first you must make sure all plugins and theme you are using is compatible with version 2.3.1.
    version 2.3.1 does not use wp_post2cat and wp_categories table anymore. that is why your server gives you that error.

    -cypher.
     
    CypherHackz, Dec 20, 2007 IP
    amiecn likes this.
  7. Peyote

    Peyote Peon

    Messages:
    549
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    0
    #7
    phew...why did wordpress have to make such sudden changes!
     
    Peyote, Dec 21, 2007 IP
  8. amiecn

    amiecn Well-Known Member

    Messages:
    360
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    120
    #8
    ideas_man fixed it for me...apparently it had nothing to do with the WP version or the database...it was a coding issue.

    thank you!
     
    amiecn, Dec 21, 2007 IP
  9. mann3r

    mann3r Peon

    Messages:
    1,416
    Likes Received:
    100
    Best Answers:
    0
    Trophy Points:
    0
    #9
    glad it finally worked and solved.
     
    mann3r, Dec 21, 2007 IP