SEOClerks

Clear
Sign In Join

How do you stop bots from posting spam in the comments section of your website?

  • cinnamonsugar Level 1
    • 20

    Write the reason you're deleting this FAQ

    How do you stop bots from posting spam in the comments section of your website?

    I used to have a blog, but sort of shut it down after the comment section got overrun by bots posting all sorts of spam and malicious links. I haven't really found a proper mechanism to deal with this, and Captcha doesn't seem to work all the time. Any thoughts on this?

    #Comments #Blog #Bots Web Development
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    Tronia

    Tronia

    You have different Anti-bot Captcha options. Which one did you try? the best one right now is Google's reCAPTCHA and trust me it fixes the bots issues. My friend had them flooding his forum and ever since he added the reCAPTCHA there's literally no bots.

    If interested take a look at this link: https://www.google.com/recaptcha/intro/

    Hope this helps you! How do you stop bots from posting spam in the comments section of your website?
    9 years ago

    Are you sure you want to delete this post?

    Okav1ator

    Okav1ator

    That's the exact same reCAPTCHA I use! I would definitely recommend using it. Ever since I started using it I haven't had problems with spam bots.
    9 years ago

    Are you sure you want to delete this post?

    lordrenly

    lordrenly

    Yeah, I have been using reCAPTCHA since they were released (around 2007 I think) and I am satisfied with how they handle spams. I think it is also not as complicated as other captchas for the users so reCAPTCHA is a good balance between security and usability.
    9 years ago

    Are you sure you want to delete this post?

    jeiss

    jeiss

    Yes, I totally agree with you here. reCAPTCHA is the best around. It is easy to install with less stress. It does the job just fine.

    Even a human trying to comment would always have to think twice before commenting when you have reCAPTCHA installed on your website. The security and validation process is like no other.
    9 years ago

    Are you sure you want to delete this post?

    Corzhens

    Corzhens

    Bots that posts spam are annoying and I think the captcha is one good way of blocking the entry of bots because they will fail in the registration. But what we normally do against spammers whether they are bots or humans is the blocking of the IP address. The bots couldn’t enter anymore and that also bars even the other bots coming from the same origin. Bots truly give us a headache.
    7 years ago

    Are you sure you want to delete this post?

    anwebservices

    anwebservices

    Simple using of WordPress plugins can save you a lot of time and headache by protecting your website from spam comments and registrations. I use plugin called "Zero Spam" and it works great for my websites, it also have option to temporary or permanently ban bot's IP address if you wish. There is also other spam protection plugins and you can browse them from your WP administration panel and install for free ;)
    9 years ago

    Are you sure you want to delete this post?

    keen2write

    keen2write

    Try using captcha screens and also if you're using WordPress you can switch the comments off easily in the dashboard area. There is also special plugins on WordPress which can also help. I find WordPress the best format really.
    9 years ago

    Are you sure you want to delete this post?

    joegirl

    joegirl

    Thanks for the tip. I'm having the same issue with my blog. It's constantly flooded with spam and its such a nuisance. Each time I have to login and delete the comments. I will try the suggested tip above.
    9 years ago

    Are you sure you want to delete this post?

    neilarmstrong

    neilarmstrong

    I use Akismet: Spam Protection for WordPress. It seems to be working pretty well. Sometimes I find that a few legit comments are marked as spams but the number of such comments is very low. I am quite satisfied with its performance so far.
    9 years ago

    Are you sure you want to delete this post?

    galegatling

    galegatling

    Yeah as what these other folks say, reCAPTCHA is the best anti-spam filter for your websites.
    Even I can't sometimes enter the words correctly because some captchas are so hard to read. x.x
    9 years ago

    Are you sure you want to delete this post?

    vinaya

    vinaya

    This is also my question because I get many bot comments on my blog posts and many bot traffic on my websites. I use word fence plugin on my wordpress sites, which stops unauthorized access to my websites, it even gives the source of bot traffic, however, it does not stop bot comments. I am yet to use any anti-bot plugins, however, I am considering to use anti-bot captcha plugin on my websites. The only thing that is holding me is captcha options will also drive away genuine commentators.
    9 years ago

    Are you sure you want to delete this post?

    hermessantos

    hermessantos

    I've had a lot of spam issues on my sites. There were many messages every day.

    I use Wordpress and downloaded the Disqus Comment System plugin. This plugin really solved my problem.
    9 years ago

    Are you sure you want to delete this post?

    zeedollar

    zeedollar

    Installing an extra security plugin can save you loads of head aches trust me, or you can integrate a capcha system to avoid bots from automatically posting in the comment section.
    9 years ago

    Are you sure you want to delete this post?

    goldlady

    goldlady

    Oh my god SO annoying! I hate when it happens to me. I have handled with this kind of issues since I have my blog years and years ago. I have triend many kinds of possible solutions, but the problem always comes back. I'm still looking for the right way to get rid of that spam but seems like it's kind of hard!
    9 years ago

    Are you sure you want to delete this post?

    ajlancer

    ajlancer

    Hi there,
    Thanks for your query. Yes! it is a serious issue to protect any blog or web against spam or bot. Specially many of bot comment poster becoming to blog for comment with spam url. I have a blog also but it is complete spam free. I used WordPress theme for my blog and it is very easy to control on wordpress blog, if you use few plugins for anti spam. One the top ZERO SPAM plugin. It is easy to install and work very good. You will get many other free plugin on WordPress. Google reCAPTCHA verification can protect any spam or bot from the blog. I have another suggestion, You can control your user for comments like without registration nobody can comment on any post. In this way you will get real user too.

    Regards by Ajlancer
    9 years ago

    Are you sure you want to delete this post?

    mybarya

    mybarya

    Aside from using Captchas and anti-spam plugins, you can also try modifying your .htaccess file to prevent spam comments. The .htaccess file can help toughen WordPress security. Short and simple lines of codes can really help to reduce spam comments. You can add the code below to your root .htaccess to deny bots with no referrer.

    # Protect from spam bots
    <IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteCond %{REQUEST_METHOD} POST
    RewriteCond %{REQUEST_URI} .wp-comments-post\.php*
    RewriteCond %{HTTP_REFERER} !.yourwebsite.com.* [OR]
    RewriteCond %{HTTP_USER_AGENT} ^$
    RewriteRule (.*) ^http://%{REMOTE_ADDR}/$ [R=301,L]
    </IfModule>


    Don't forget to replace “yourwebsite.com” with your blog URL. The above code only blocks SPAM BOTS and not humans who manually try to spam.
    9 years ago

    Are you sure you want to delete this post?

    limberg

    limberg

    I had this problem since I the first time I used WordPress. I also tried using Captcha but still, the issues with spam comments continue. I hope that installing Google's Recaptcha tool will eliminate these pesky bots from spreading spam. Hey, I'm wondering, is this plugin free? I hope it is...

    Anyways, what if I am also running Buddypress in one of my sites? Will it stop bots from posting spam in their wall?
    9 years ago

    Are you sure you want to delete this post?

    amazingsteven

    amazingsteven

    Try using WordPress ZERO SPAM plugin. Very easy to install and it work pretty well . You can also use Akismet it is also a great anti spam plugin. There are many many other free anti-spam plugin on WordPress. Google reCAPTCHA is another excellence anti-spam tool.
    9 years ago

    Are you sure you want to delete this post?

    Corzhens

    Corzhens

    My husband had experienced spam bots in the forum of their office website. I will not mention the brand but it’s the leather boots. What they did was to flag the IP addresses of the spammer. It’s not an easy task because the bots will just change their IP address. But since the forum has an active staff who watched the boards, they succeeded in blocking the spammer until it ran out of IP address. But if you don’t have the manpower to watch over your forum then I guess a captcha will do the trick although it will have an effect on the legitimate members of the community.
    8 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.31001710891724

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    		/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

    SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='23408'1SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='23408'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='601125'1SELECT * FROM seoclerks.members WHERE USERID='601125'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM categories_faq WHERE CATID='43'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='43'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()

    SELECT * FROM seoclerks.members WHERE USERID=6011251SELECT googleplus_profile FROM seoclerks.members WHERE USERID=601125

    		/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()

    SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=23408 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=23408 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='23408' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='23408' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc

    		/opt/clerks-staging/docroot/viewfaq.php 1245 () ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123206 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123206 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123246 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123246 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123313 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123313 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=127229 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=127229 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=172073 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=172073 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123337 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123337 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123254 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123254 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123274 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123274 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123277 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123277 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123407 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123407 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123566 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123566 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123737 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123737 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124096 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124096 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=125139 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=125139 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126286 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126286 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126620 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126620 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126991 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126991 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=127248 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=127248 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=157815 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=157815 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='23408'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='23408'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='23408' AND status='1' AND (question like '%How stop bots posting spam comments section website?%' OR question like '%stop%' OR question like '%bots%' OR question like '%posting%' OR question like '%spam%' OR question like '%comments%' OR question like '%section%' OR question like '%website?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='23408' AND status='1' AND (question like '%How stop bots posting spam comments section website?%' OR question like '%stop%' OR question like '%bots%' OR question like '%posting%' OR question like '%spam%' OR question like '%comments%' OR question like '%section%' OR question like '%website?%') -- ORDER BY RAND() LIMIT 15

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM seoclerks.members WHERE USERID='3250' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='147' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='147' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='7' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='7' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='840' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='840' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='1490' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=23408%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=23408%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM categories1SELECT * FROM categories

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * from categories_software order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

    select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

    select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

    SELECT * FROM seoclerks.members WHERE USERID='584702.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='584702.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='600577.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='600577.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='254580.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='322073.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='322073.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='599890.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='599890.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='598592.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='598592.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='585810.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='593814.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='593814.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='601783.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='601783.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='604318.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='604318.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='4987.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='601615.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='601615.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='583337.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='583337.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.4126371SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (22) AND gtags like'%Booster%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4126370.412637
    0.2154901SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (22) AND gtags like'%Booster%' AND type !=99 0.2154900.215490