A query crash my site!!!!

  • My blog crashes several times a day for this query!!! Anyone knows hot to fix it???? I use wordepress 2.9.2 with Mistique theme and w3 total cache plugin…

    Please help me!

    Query SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN (select distinct tr.object_id, t.name from wp_term_relationships tr inner join wp_term_taxonomy tt on tt.term_taxonomy_id = tr.term_taxonomy_id inner join wp_terms t on t.term_id = tt.term_id) tr on wp_posts.ID = tr.object_id WHERE 1=1 A

Viewing 4 replies - 16 through 19 (of 19 total)
  • Thread Starter diablo010473

    (@diablo010473)

    after 2 days it crashes again!!!!! Is it possible that disinstalling e reinstalling it could solve the problem???

    Moderator James Huff

    (@macmanx)

    Have you tried the rest of Esmi’s suggestions?

    Thread Starter diablo010473

    (@diablo010473)

    mcmanix…..i try all suggestions!! the problem is THAT query!

    SQL_CALC_FOUND_ROWS SELECT DISTINCT wp_posts .* FROM wp_posts LEFT JOIN (SELECT DISTINCT tr.object_id, t.name from wp_term_relationships tr tt inner join wp_term_taxonomy on tt.term_taxonomy_id = tr.term_taxonomy_id inner join t on wp_terms t.term_id = tt.term_id) on tr tr.object_id = wp_posts.ID WHERE 1 = 1 AND (((((wp_posts.post_title LIKE ‘% KiteGen%’) OR
    (Wp_posts.post_content LIKE ‘% KiteGen %’))) AND (wp_posts.post_password =”) AND wp_posts.post_type =’ post ‘AND (wp_posts.post_status =’ publish ‘)) AND post_type! =’ Revision ‘) AND post_status! = ‘future’ OR (tr.name LIKE ‘%% KiteGen’ AND post_status = ‘publish’ AND post_type = ‘Post’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 13;

    That looks like a basic search query to me. What version of WordPress are you running?

Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘A query crash my site!!!!’ is closed to new replies.