HELP: WP database error

Discussion in 'WordPress' started by amiecn, Mar 4, 2008.

0
  1. #1
    When I try to write a post I get this message when I click publish:



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


    Can anyone tell me how to correct this?

    Thanks in advance for your time... :D
     
    amiecn, Mar 4, 2008 IP
  2. CaffinePhil

    CaffinePhil Banned

    Messages:
    945
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #2
    This may not be much help but I had this and I simply restarted my machine and not had the problem since. Not really a solution but it worked for me.
     
    CaffinePhil, Mar 4, 2008 IP
  3. amiecn

    amiecn Well-Known Member

    Messages:
    360
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    120
    #3
    as crazy as your suggestion sounds - I tried it

    it didn't work

    any other suggestions?
     
    amiecn, Mar 4, 2008 IP
  4. MeetHere

    MeetHere Prominent Member

    Messages:
    15,399
    Likes Received:
    994
    Best Answers:
    0
    Trophy Points:
    330
    #4
    repair your database from your cpanel ;)
     
    MeetHere, Mar 4, 2008 IP
  5. Pixelrage

    Pixelrage Peon

    Messages:
    5,083
    Likes Received:
    128
    Best Answers:
    0
    Trophy Points:
    0
    #5
    ^ this is true...go into your mysql area and click "repair" next to your database listing. Might work. Otherwise, I've seen errors like this when the server was about to crash (or already has). Try restarting "MySQL server" in your server's admin panel, and try it again.
     
    Pixelrage, Mar 4, 2008 IP