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?
You have Cpanel? If you do,log into cpanel and click MySQL® Databases ,find your database and click Repair.
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
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
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?
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
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!