Suffering so much for spam comments

ytpromo75 Level 3

September 30, 2013, 11:52 am

16

Write the reason you're deleting this FAQ

Suffering so much for spam comments

Do anyone know why the youtube comments are being spams? I am just tired of posting comments. All the comments are being flagged as spam. Need a solution quickly.

Comments

Please login or sign up to leave a comment

Join

angie828

Are all of your comments being flagged as spam? Maybe it is your email that they are associating with spam or your IP address?

13 years ago

Are you sure you want to delete this post?

Beverly

Are you posting as part of an SEOClerks service? It's possible you should post as a different username on Youtube, maybe someone is trolling your current username for malicious reasons.

13 years ago

Are you sure you want to delete this post?

robertman11

Are you posting spam or spun comments?

13 years ago

Are you sure you want to delete this post?

Miken34

Check your user name. Sometimes your user name or email are associated with spam.

13 years ago

Are you sure you want to delete this post?

loulou

I know that if you have to use an email address sometimes they use this to see if you have spammed on other sites. get a new email address.

13 years ago

Are you sure you want to delete this post?

mqss

Because you don't make quality comments, simple as that. There's a war going on on Youtube, if you have 10 accounts, you can flag any comment and make it flagged as spam. If you are promoting competitive products, your competition will do that to you.

13 years ago

Are you sure you want to delete this post?

ricky44

Because you don't make quality comments, simple as that. There's a war going on on Youtube, if you have 10 accounts, you can flag any comment and make it flagged as spam. If you are promoting competitive products, your competition will do that to you.

This is very interesting to know. I do hope that someone would only flag it if it needed to be but there are some real big snakes out there.

13 years ago

Are you sure you want to delete this post?

mqss

This is very interesting to know. I do hope that someone would only flag it if it needed to be but there are some real big snakes out there.

Here are some even more interesting things about YT spamming:
I know a guy that runs more than 50.000 YT accounts every day for posting comments, upvoting and flagging competition's top comments. Every account needs it's own IP and all have to be phone verified, so that doesn't come cheap at all. I was amazed on how big his spam network is, but he told me he's a small fish compared to big time Youtube spam players and there is a war going on on Youtube.

So, you need 50 comment likes on average when spamming on most viewed videos, but you only need 5-10 flags to mark comment as a spam and get it off top comments section. Accounts get banned easily and new and new Youtube accounts have to be created. Estimation is that top Youtube spammers run about a million accounts for spamming.

For the OP: If you post a link through your comments, they will be marked as spam very fast. Best idea if you promote a website is to have a unique domain name that ranks #1 for it's EM name and instead of posting url, post "...search for (EMD) on Google..."

13 years ago

Are you sure you want to delete this post?

Kat1

Check your user name. Sometimes your user name or email are associated with spam.

Really? This can happen? Amazing that these are associated with spam but I guess that it does make sense.

13 years ago

Are you sure you want to delete this post?

Justin

Really? This can happen? Amazing that these are associated with spam but I guess that it does make sense.

Wonder how much money that would cost to run such a huge network of spam accounts.

13 years ago

Are you sure you want to delete this post?

evie

How is this going for you? Have you found a solution to your issues that you were having?

13 years ago

Are you sure you want to delete this post?

ralph101

Just a quick question for you. Do you add comments that are high in value? If not then this might be why you are seen as spamming.

12 years ago

Are you sure you want to delete this post?

blueeyes

Ralph great suggestion. If your comments are not good you will be flagged as spam so make sure the comments are useful and add value.

12 years ago

Are you sure you want to delete this post?

tionna

Do anyone know why the youtube comments are being spams? I am just tired of posting comments. All the comments are being flagged as spam. Need a solution quickly.

Are they spam? Are they relevant to what the video is about?

12 years ago

Are you sure you want to delete this post?

tangee

Can you add comments to youtube now? I have not been able to add them for a while but I read that you also have to be logged into G+ to leave comments.

12 years ago

Are you sure you want to delete this post?

Jolie

Can you add comments to youtube now? I have not been able to add them for a while but I read that you also have to be logged into G+ to leave comments.

Aren't you automatically logged into Google+ if you are also logged into Gmail or Youtube? This should use the same username and will be a big convenience for Youtube users.

12 years ago

Are you sure you want to delete this post?

Process Time: 0.12689900398254

Possible Duplicate queries found!

Match	Count	SQL	Script
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='14483'	1	SELECT 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='14483'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='81318'	1	SELECT * FROM seoclerks.members WHERE USERID='81318'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM categories_faq WHERE CATID='36'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='36'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM categories_faq WHERE CATID='30'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='30'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM seoclerks.members WHERE USERID=81318	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=81318	/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=14483 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=14483 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='14483' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT 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='14483' 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=75761 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75761 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=75762 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75762 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=75763 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75763 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=75764 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75764 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=75765 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75765 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=75766 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75766 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=75767 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75767 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=75768 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75768 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=75769 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75769 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=75770 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75770 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=75771 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75771 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=75772 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75772 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=75773 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75773 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=75774 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75774 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=75775 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75775 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=75776 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75776 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='14483'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='14483'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='14483' AND status='1' AND (question like '%Suffering spam comments%' OR question like '%Suffering%' OR question like '%spam%' OR question like '%comments%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='14483' AND status='1' AND (question like '%Suffering spam comments%' OR question like '%Suffering%' OR question like '%spam%' OR question like '%comments%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='17457' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17457' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='4987' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='4987' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='672' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='672' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='11099' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='11099' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='10230' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='10230' 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=14483%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=14483%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * 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 asc	1	select * 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 asc	1	select * 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='632.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='632.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='147.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='147.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='9.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='9.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='2077.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2077.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time	Count	SQL	Max	Min
0.410882	1	SELECT 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 (93) AND gtags like'%Convert%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.410882	0.410882