that’s a wordpress bug related to a piece of shit software called mysql. the bug has been filed in trac already.
to solve, change your db type to myisam rather than innodb
Denis can you explain how one goes about doing this on a server?
Brian,
I only pale in comparison to the help Denis can provide you, but here is the response I got from my hosting company:
========================================================
Myisam is the standard database engine for mysql while innodb is considered the high-end engine. We support both on the virtual server and only Myisam with the regular MYSQL. myisam is better for most purposes because it’s faster and uses much less disk space. innodb is only necessary when you are doing complex database stuff, such as transactions, foreign keys, etc. These features aren’t supported by the myisam engine.
For what you’re doing you probably won’t need anything else other than myisam. For more detailed information on these two types of engines you may consult the internet. I’ve seen many results on the subject.
=========================================================
Hope that helps, turns out I am set up properly, a support ticket to your host company might determine the same thing for you, who knows.
It does thanks, and I checked my database is MyIsam, what I needed was the new update from 2.0 to 2.2 and now it works fine.
Thanks!
