mikeo75

Bumping this…really looking for some help here. I’m at a loss.

No idea, can’t get an answer from anyone ??

Actually, I think it’s Taxonomy.php that is causing this problem.

Here is what my host found:

Unfortunately, I won’t be able to pin point where this query is coming from since wordpress uses variables but you can perform searches for certain key words that might at least lower the amount of scripts. I did a quick search that looks for one of the inner joins lines

INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id

You can run this from within ssh

egrep -ir “INNER JOIN .* AS tt ON t.term_id = tt.term_id” /home/43539/domains/

This looks to be retuning files with part of this query,

/home/43539/domains/popcritics.com/html/wp-includes/taxonomy.php
/home/43539/domains/popcritics.com/html/wp-content/plugins/simple-tags/2.3/simple-tags.client.php
/home/43539/domains/popcritics.com/html/wp-content/plugins/simple-tags/2.5/simple-tags.client.php
/home/43539/domains/popcritics.com/html/wp-content/plugins/simple-tags/2.5/inc/simple-tags.admin.php

The plugin appears to be Similar Posts, which sucks, because that’s a pretty nice feature. Not sure how to make it better or not.

Dalton, my server at Media Temple has this in their control panel, so I’m not sure your VPS will have it.

I’m wondering if it’s similar posts? I’ll try to find out.

Good stuff Ogre, I appreciate the help…I’m going to try and run the EXPLAIN thing on this query and see what happens.

This is what I see for query caching:

# query cache
query_cache_limit = 1048576
query_cache_size = 12M
query_cache_type = 1

Also, changing that query you said, it will just get wiped out in the next release I assume.

Not even sure what file that is in ??

Anyone?

More than a one person problem, but the plugin creator doesn’t seem to want to help solve it I guess.

I’m just forced not to use it.

The only other solution I think, is to use Disqus or Intense Debate and their javascript method of external comments, which might work.

Still doesn’t work all the time.

Just curious if the reason I get no response to this is because there is no way to fix it, or just no way to troubleshoot it?

I know I’m not the only one, but it feels like no one will respond to at least just tell me I’m screwed.

I did just update my HTACCESS file with what looks to be a different set of code than the previous version, not sure how I missed that.

But honestly, the comments have always been a problem.

We’ll see how this goes.

Just bumping this like the other one.

Would love to help troubleshoot this or something, just need some ideas on which way to go.

I don’t suppose I could get anymore help on this?

I really, really need to use this plugin, but if comments don’t update, I’m hosed.

Is there anyway to make it just manually delete the cached version if someone leaves a comment?

Where would I have to put that?

Please help! I am at a loss here and I know I’m not alone.

Well, I am talking about PopCritics.com, which we don’t use any plugins for commenting ??

Just an annoying problem for me I guess? ??