Help – It’s Critical

  • Resolved DG

    (@dg)


    17 years ago

    I’m in need of WordPress community help. I’ve just received an email from my Host (DreamHost), that a query is causing high load and they’ve disabled my site, utill the error is fixed. Here’s is the query:

    SELECT DISTINCT wp_posts.*, (meta_value+0) AS views FROM wp_posts LEFT
JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID WHERE post_date <
'2007-10-30 08:03:34' AND post_type = 'post' AND post_status = 'publish'
AND meta_key = 'views' AND post_password = '' ORDER  BY views DESC LIMIT
10;

    I tried to find the cause, but to no avail, can anyone please advice me what could be the cuase of the error?

    thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)
  • MichaelH

    (@michaelh)

    Some kind of views plugin? Maybe disable plugins one-by-one if you don’t have a views plugin to disable.

    Thread Starter DG

    (@dg)

    Hi Michael,

    Thanks for the reply. And sorry! I didn’t updated, actually, right after posting, I had traced the plugin, but couldn’t reply as my site was disabled by DH and I was sending/receiving emails from DH support.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Help – It’s Critical’ is closed to new replies.