WordPress database error: [Got error 134 from storage engine]
November 27th, 2007
You may noticed that yesterday, for a few hours, I have an error message displayed on my blog. While I was trying to insert a text widget on my sidebar, I’ve got this message:
WordPress database error: [Got error 134 from storage engine]
SELECT option_value FROM wp_options WHERE option_name = ‘widget_text’ LIMIT 1
After that, my dashboard looks messy: there are displayed many code lines and my widget text are disappeared. I’ve got in panic because I don’t know what to do. Then, I noticed the error name: “error 134“. You got it? I didn’t know what to do first: to cry or to smile. After I calm down a little bit I’ve searched on error 134, and I find out that maybe a table has crashed on database.
So here is the solution for those of you who own the domain and have access to CPanel and database. And of course, who get this error :smile:. I wanted to add “and who has WordPress installed” but it seems that this is a MySQL error.
First of all, you must backup your database, just in case. Go in your CPanel and open phpMyAdmin. Then, select the database and under Export tab, select “Save as file”. Then Go, and save on your computer.
Now, you must repair the crashed table. In this case, if you read the second line on error message you will see that the table was wp_option. But of course, you can repair your entire table, just to be sure that you fixed all.
How to repair a table?
Select the table you want to repair, go on Operations tab and at Table maintenance choose Repair table. If the table was crashed, you will see what errors were repaired. If the table wasn’t crashed, you will see just that the table is OK.
After the table was repaired, I had to add my text widget again. And that’s all folks.
See? You can fix this error very easy, you don’t need to panic, like I do 
Hope this article helps. I don’t know if I make myself clear, but if you have any question , please feel free to ask me and if I can and I know how, I’ll help you.
Stumble this post!If you liked this post, please consider to subscribe to my RSS feed.
If you want to receive new posts directly to your inbox, you can subscribe by Email.
Entry Filed under: General
When I read the title, I was about to send you an email that your database is corrupted
I never got this error and I hope I never will, but at least now I know who to ask how to fix it
Simonne’s last blog post..How Christmas Gifts Can Ruin Relationships
Simonne, I hope you never got this error, but if you do, I’ll wait for you
The funny thing about this error is in the first place that it is called 134, and second, about 5 minutes after I’ve got this error, it was submitted an article for Carnival, called: “Importance of Backing Up Blog Regularly”
Aiya…a similar kind of problem happen to me but I don’t know what’s wrong….i do a lot of uninstalling but it was actually something wrong with my php coding…i found the way to fix it but it was already too late….unfortunate for me, because I have to start over again….but I’m an optimistic…it happen for a better outcome later on…
nimrodjo’s last blog post..The Online Opportunities For Making Money
As a Blogger user it won’t apply to me
But we do get our own problems from time to time!
I have something for you here!
Diana, just wondering why, when I visit your blog is says at the top right corner??
Thanks for visiting
My lucky number 13
from Jerusalem, Israel.
I wish you a great day!
I am in London UK..
I noticed this a few times now
@nimrodjo: I wish you the best of luck with the new blog. I’m sorry for the old one.
@Lady Banana: I’m really sorry for that. I use a script. I’ll ask on their forum for that. It seems that they must update their database.
I thought you were joking with that error name
your sql is psychic 
glad you were able to fix it, i would have panicked too…
pearl’s last blog post..Best 101 Lists
Lady Banana » it seems that it is fixed. Please tell me if it’s ok now.
@pearl: Oh yes, I have a psychic sql
Now, that I’ve going through this, I’m going to backup my database more often. Though my web hosting do that every night. But still…
Hi Diana,
Yes…backing up as often is important. Wordpress does give surprises like. I have experienced that a number of time. Your post is of great help to many individuals whom I am sure have come across such an incident. By the way, love your blog. Helpful tips and various stuff of interest. Thanks for sharing.
Regards…
Franco Yong’s last blog post..Why WordPress Rocks: Franco Yong
I would be like you — my first reaction to any kind of database error is to panic! But now, if I get 134 in an error message, now I’ll know what’s wrong and how to repair it. It’s great when bloggers share information about what can happen and how to fix it — so good for everyone, to add to the great pool of knowledge. Thanks!
Jen / domestika’s last blog post..Start a Healthy New Holiday Food Tradition: Guest Post