Archive for December, 2006

Mysql Error

Sunday, December 31st, 2006

I had been working on my theme over the xmas holiday, everything was going well, I have some new ideas I’d like to implement but wanted to clean things up a little first. As I often do, I was downloading various torrents at the same time and wasn’t having any problems, time cracked on and when it got late I headed off to bed satisfied that I had achieved something with my blog.

I woke the next morning to find that I had [Got error 28 from table handler], not good, I couldn’t view any posts, I couldn’t even log into the torrent server, trying not to panic I used the first tool I could think of: Google, not too long afterwards I realised that since I had been downloading torrents I’d not actually made sure if the files would fit into the available space left on the server dedicated to them.

Quickly realising I was upto 100% usage on said drive I moved a few bits around and suddenly it all started working again, phew!

Later on I was suddenly faced with a message like [Can't open file: 'wp_comments.MYI'. (errno: 144)] I thought I’d got real problems, but I knew that I hadn’t changed anything for ages that might affect it in the slightest, a quick google later I found the solution.

Log into phpMyAdmin, select the wordpress database, goto SQL tab, type: REPAIR TABLE wp_comments, and hit GO.

That’s it problem fixed, crisis averted.

Lessons learned:

  • Don’t run out of space, things break.
  • Remember to try and repair the database before deleting it.
  • The place to find solutions for wordpress problems is here.
Creative Commons License