@ apljdi: Ok, I will list the plugins. In the meantime I have been tweaking, repairing, optimizing the DB. I also removed one plugin that was causing me some problems, but I am still getting the error 28 like mad. It has changed slightly however, so if this helps the error now looks like this:
[26-Dec-2009 12:17:49] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (540, 455, 465, 388, 382, 349, 322, 313, 66, 135) ORDER BY t.name ASC made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms
The bolded part changes occasionally, with different numbers.
The plugins I am using are all the most current version available (no betas):
Clean Archives Reloaded
Get Recent Comments
Highlight Author Comments
jQuery Comment Preview
MaxBlogPress Ping Optimizer
SI CAPTCHA Anti-Spam
Twitter Tools - Bit.ly URLs
Who is Online
GD Star Rating
Live Countdown Timer
Twitter Tools - Exclude Category
Twitter Tools - Hashtags
I really appreciate the help, this is killing my site. If it helps the site is FarmVille Fanatic
Here is a recent chat with my host:
Jake [2:59:45 PM]: I have an error: WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (143) ORDER BY t.name ASC made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms
[3:00:16 PM]: i have talked with dennis
[3:00:23 PM]: i was told its my problem
[3:00:30 PM]: he told me to check with the WP community
[3:00:40 PM]: I have and multiple times i have been told it is a host issue
[3:00:44 PM]: please check this thread:
[3:00:53 PM]: http://wordpress.org/support/topic/344853?replies=1
[3:01:32 PM]: the error is filling my log, and has caused my site to be shut down before by you (the host)
Mike V [3:02:17 PM]: The first error as mentioned was space related, everything else is related to your wordpress install and not something we can really assist with.
Jake [3:02:36 PM]: im only talking about the wp error 28
[3:02:45 PM]: everywhere says it is on your end
[3:02:54 PM]: even the mysql site itslef
[3:03:00 PM]: i cannot fix this error
Mike V [3:03:07 PM]: Delete your log files.
[3:03:18 PM]: Or set up log rotation to delete them for you.
[3:03:30 PM]: Or allocate more space to your site from your control panel.
Jake [3:03:50 PM]: more space to my site?
[3:04:04 PM]: 147.41 / 25000 MB
[3:04:08 PM]: thats how much i am using
[3:04:17 PM]: it has to do with the tmp space
[3:04:50 PM]: please look at this: http://www.mysql.com/news-and-events/newsletter/2003-10/a0000000249.html
Mike V [3:05:28 PM]: Something like that we can't increase on a per site basis, and the limits exist as a mysql restriction for a reason.
Jake [3:05:29 PM]: the error happened less than 5 minutes after clearing my tmp folder and files
Mike V [3:05:44 PM]: You're generating too much information in a very short time then.
[3:05:57 PM]: We have hundreds of other wordpress sites on this server and none are having this issue.
Jake [3:06:18 PM]: then how am i supposed to fix this? my install is nothing special
Mike V [3:06:24 PM]: Apparently it is.
Jake [3:06:28 PM]: i have been told again and again by wp community it is a host issue
[3:06:41 PM]: and host tells me again and again its a wp error
[3:06:45 PM]: so im in a bind here
Mike V [3:06:53 PM]: And if it isn't something special, then uninstall and reinstall it.
[3:07:09 PM]: You have something in your install that's causing this.
Jake [3:07:53 PM]: is there no way to determine more than this? I dont really have a way to simply re-install it without destroying a lot of work
[3:08:14 PM]: and if it continues to happen and everyone else says it is a host issue...
[3:08:17 PM]: then what?
[3:08:37 PM]: other hosts can increase the tmp size
Mike V [3:08:45 PM]: The issue with everyone claiming its a host issue is that we'd have every other wordpress or mysql utilizing site generating similar errors.
Jake [3:09:08 PM]: well i talked to this guy:
[3:09:08 PM]: Alex P [1:54:36 AM]: Please hold on, I'm checking...
Jake [1:54:44 AM]: ok
Alex P [1:57:45 AM]: I've raised tmp_table_size for mysqld and you shouldn't experience such problems anymore.
[3:09:14 PM]: this is your own host support
[3:09:28 PM]: he didnt seem to have a problem with saying it could be raised
[3:09:31 PM]: and claimed it was
Mike V [3:09:35 PM]: I see the size increase.
[3:09:42 PM]: Its at the highest we'd permit.
Jake [3:09:46 PM]: you just said a bit ago you couldent do that
[3:10:07 PM]: Mike V [3:05:28 PM]: Something like that we can't increase on a per site basis, and the limits exist as a mysql restriction for a reason.
Mike V [3:10:32 PM]: He didn't increase it on a per site basis.
[3:10:37 PM]: He increased it server wide.
Jake [3:11:00 PM]: no one has been able to help me with this issue at all
Mike V [3:11:04 PM]: What its at right now is the highest we'll be able to adjust it.
Jake [3:11:06 PM]: is the tmp folder full?
Mike V [3:11:22 PM]: You have to realize that no one else was having issues with their wordpress install at the original limits.
[3:11:24 PM]: You were the only one.
Jake [3:11:26 PM]: i had it cleared and within minutes the error continured to appear
Mike V [3:11:32 PM]: This means something in your install is causing this issue.
[3:12:14 PM]: We've adjusted any limits as high as we can really permit without risking abuse or performance issues on the server.