Deleted a category and screwed the whole thing up, help!

Discussion in 'WordPress' started by hmansfield, Jan 19, 2008.

  1. #1
    I deleted a category a screwed up my blog.
    I am getting this error message all over the place:



    WordPress database error: [Can't open file: 'wp_post2cat.MYI'. (errno: 145)]
    SELECT post_id, category_id FROM wp_post2cat WHERE post_id IN (786,781,776,758,756,752,750,749,742,740,736,734,730,720,711)


    What does it mean, and how can I fix it?
    Can anyone help?
     
    hmansfield, Jan 19, 2008 IP
  2. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #2
    Have you tried fixing the database?
     
    Richie_Ni, Jan 19, 2008 IP
  3. hmansfield

    hmansfield Guest

    Messages:
    7,904
    Likes Received:
    298
    Best Answers:
    0
    Trophy Points:
    280
    #3
    How do I do that?
     
    hmansfield, Jan 19, 2008 IP
  4. twodogs

    twodogs Banned

    Messages:
    291
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #4
    do you have a downloaded backup?

    i backup mine every week
     
    twodogs, Jan 19, 2008 IP
  5. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #5
    You have Cpanel?
    If you do,log into cpanel and click MySQL® Databases ,find your database and click Repair.
     
    Richie_Ni, Jan 19, 2008 IP
  6. hmansfield

    hmansfield Guest

    Messages:
    7,904
    Likes Received:
    298
    Best Answers:
    0
    Trophy Points:
    280
    #6
    I only have FTP access. I don't know what cpanel is.
     
    hmansfield, Jan 19, 2008 IP
  7. maldives

    maldives Prominent Member

    Messages:
    7,187
    Likes Received:
    902
    Best Answers:
    0
    Trophy Points:
    310
    #7
    your domain control panel
     
    maldives, Jan 19, 2008 IP
  8. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #8
    :eek:

    cPanel ("Control Panel") is a graphical web-based web-hosting control panel, designed to make administration of websites easy. cPanel handles all aspects of website administration in its interface. The software, which is proprietary and distributed by cPanel Inc.
    http://www.google.com/search?client=safari&rls=en&q=define:cpanel&ie=UTF-8&oe=UTF-8
     
    Richie_Ni, Jan 19, 2008 IP
    hmansfield likes this.
  9. hmansfield

    hmansfield Guest

    Messages:
    7,904
    Likes Received:
    298
    Best Answers:
    0
    Trophy Points:
    280
    #9
    OK, let me check it out...
     
    hmansfield, Jan 19, 2008 IP
  10. hmansfield

    hmansfield Guest

    Messages:
    7,904
    Likes Received:
    298
    Best Answers:
    0
    Trophy Points:
    280
    #10
    Nope...I'm lost, can anyone be a little more specific?
     
    hmansfield, Jan 19, 2008 IP
  11. mizaks

    mizaks Well-Known Member

    Messages:
    2,066
    Likes Received:
    126
    Best Answers:
    0
    Trophy Points:
    135
    #11
    It looks like your Featured Article hack for your theme is looking for the category you deleted. Try to readd the category or change the category call in your index.php
     
    mizaks, Jan 20, 2008 IP
    hmansfield likes this.
  12. hmansfield

    hmansfield Guest

    Messages:
    7,904
    Likes Received:
    298
    Best Answers:
    0
    Trophy Points:
    280
    #12
    OK, now we are getting somewhere, thank you.:) I did try adding the category again, but that didn't work, I will tool around the index file.
    Would you know what string of code I should look for and what I should change it to?
     
    hmansfield, Jan 20, 2008 IP
  13. mann3r

    mann3r Peon

    Messages:
    1,416
    Likes Received:
    100
    Best Answers:
    0
    Trophy Points:
    0
    #13
    as for other said, repairing the database thru cpanel, go to your domain.com/cpanel in your browser, input your ftp username and password, you can see icons leading to your control panel, now find MySQL database, inside that you will see Repair DB. choose DB of your wp. Click repair. if that not solved you problem. Go to your wp admin. Manage. And now edit every post you have posted on that category and change where the post will belong. It normally goes to the default post category
     
    mann3r, Jan 20, 2008 IP
    hmansfield likes this.
  14. hmansfield

    hmansfield Guest

    Messages:
    7,904
    Likes Received:
    298
    Best Answers:
    0
    Trophy Points:
    280
    #14
    OK, I got it fixed. In case anyone else ever has this problem, I downloaded a plug in for phpmyadmin, from slipstream,com, found the affected file, and selected "repair" in the options.(as mann3r suggested)
    It worked!
    Back to normal.
    Thanks for the help guys, it was enough to point me in the right direction since I have never had this problem, and didn't fully understand myphp, or cpanel, before this incident.

    Once again, this forum has come through again with quality help...you guys rock!
     
    hmansfield, Jan 20, 2008 IP