My posts won't show up in my wordpress blog - initially I could click on a month and they would show up by month, but not as "show last posts", and worpress sais it's a mysql issue, sometimes solved by running a repair table. so I went into mysql and did that, and now I can't even see my posts by months. I did a backup, and also I can see my posts in phpmyadmin, but worpress can't se them for some reason, it keeps giving me the same error;
WordPress database error: [Got error 28 from table handler]
SELECT * FROM wp_posts WHERE 1=1 AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 15
This error only shows up under posts. My pages and comment, everything else is fine. And again, it used to show up only for 'last posts', but now it shows up on any of the months I click on. I did some searching but couldn't find anything. I'm hosted on server 2, is there a problem with the server?
Please help me! Thank you.
The temporary directory on the server was full due to some website storing files there and script kiddies trying to upload hacking scripts. (not working, but it's still taking space)
Anyway, I cleaned it now and the error shouldn't be appearing anymore. If it does, please post it here.
thanks man, it's all working now.