Wordpress Error

[abinidi 1]

I went to a wordpress blog that I manage today, and I'm seeting the following error at the top of the page:

 

WordPress database error: [Got error -1 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') GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 15

 

When I log in to the wp-admin area, and go to the manage posts page, I see the same error; none of my content is shown.

 

I don't know what my first error recovery steps should be.

 

(FYI, this site is for my brother-in-law, and my mother-in-law is the person who adds all the content. I just keep the WordPress code up-to-date, and manage the server and stuff. So I don't know what happened that caused this error.)

[abinidi 1]

Clicking "Repair the database" in MySQL Databases didn't solve the problem.

[TCH-Thomas 25]

Don´t know if this will help, but I found this. It looks a little similar.

[TweezerMan 0]

I'm seeing "WordPress database error: [Got error 28 from table handler]" at the top of the page. See this WordPress troubleshooting FAQ on "MySQL Error 28".

 

Bottom line: You should submit a ticket to the Help Desk and have them check the free space for /tmp on the server.

[abinidi 1]

If you refresh the page, it switches between error 28 and error -1.

 

I put a question in to the wordpress support forums, and I asked the TCH help desk to look at my account to see if it is the error 28 (out of space) error.

 

I guess I'll let you know what either the help desk or the wordpress support forums say.

[abinidi 1]

Now it seems to be working.

 

Maybe the help desk ticket was the trick. However, they haven't replied to it or resolved it, so I'm not sure WHAT it was that fixed the problem.

 

Maybe it was the THINK method of server repair: think about it long enough, and the problem will solve itself!

 

Then again, maybe it was the help desk, and they just haven't had a chance to close the ticket or respond to it. In any case, what is important to me is that the site is working!

 

Thanks for all your help.

[abinidi 1]

Its broken again. I wonder what is going on.

 

I commented on my help desk request to let them know it is broken again.

 

Still no reply yet on the ticket. I'll let you know if something happens here....

[abinidi 1]

I just got a reply from TCH-Abdul who said he was able to resolve the mySQL problem, so I guess the problem was server side.

 

Anyway, the site is back up again. Glad TCH could fix it.

 

I never know exactly when to contact the help desk, because I don't know when the problem is server-side and when the problem is with the 3rd-party script, you know?

[TCH-Bruce 16]

Well here's a tip. If it was working and you didn't change anything and it is now broken that would warrant a trip to the help desk. Now if you made changes that may have caused the error then I'd try to figure out what you did before going to the help desk.