Blog Comment Spam

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
8/25/2011 10:56:28 AM
Gravatar
Total Posts 7

Blog Comment Spam

So I just noticed I had 206 comments.. this came as news to me as I did not have email notifications turned on.

Looking at the comments, they are most assuredly spam. So I came here looking for something to block the spam, and saw there was a setting... I checked mine and it is most assuredly turned on.  Yet, I have 206 spam comments!

Am I missing something?

 

Great system BTW, I love my mojo.

http://www.chariotswheels.com

 

 

8/25/2011 11:21:16 AM
Gravatar
Total Posts 18439

Re: Blog Comment Spam

Using a Captcha generally prevents spam from automated bots but sometime they can manage to crack the captcha, you might try using a different one such as Recaptcha. But also consider that the spam may be entered by real people and a captcha will not prevent that.

Hope that helps,

Joe

8/25/2011 11:38:10 AM
Gravatar
Total Posts 1204
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Blog Comment Spam

Recaptcha definitely seems to be a better solution at the moment. After we switched from Subkismet to Recaptcha, we noticed a big drop in spam comments on blogs.

Jamie

8/29/2011 8:35:07 AM
Gravatar
Total Posts 7

Re: Blog Comment Spam

I'll look at Recaptcha... for some reason I think that has a fee involved?

 

Anyway, for the moment, I am requiring comments restricted to authenticated users.

I went to the database and wiped the contents of the mp_BlogComments table, because I got tired of deleting them by hand.

I'd really like to reset the stats... is there a way to accomplish this? I can't open the tables for some reason... I just get a developer tools error when I try

 

8/29/2011 8:43:14 AM
Gravatar
Total Posts 7

Re: Blog Comment Spam

So I was wrong about recaptcha... no fee, free service.

Signed myself up, added the keys and logged out.

 

Input error: k: Format of site key was invalid

 

Now I can't log back in!!!

Anyway to fix this when I can't log in?

 

8/29/2011 9:20:44 AM
Gravatar
Total Posts 18439

Re: Blog Comment Spam

If you have the captcha enabled on the login page and that is preventing you from logging in then you would have to update the database:

UPDATE mp_SiteSettingsEx
SET KeyValue = 'False'
WHERE KeyName = 'RequireCaptchaOnLogin'

then you would need to touch Web.config file or recycle the app pool to clear the SiteSettings from cache

Hope that helps,

Joe

8/29/2011 9:55:17 AM
Gravatar
Total Posts 7

Re: Blog Comment Spam

I updated to recaptcha, is the SQL syntax the same?

 

Thanks, Joe.

8/29/2011 10:04:31 AM
Gravatar
Total Posts 18439

Re: Blog Comment Spam

I don't understand your question. The sql I provided was to change your site so it doesn't require captcha for login so you could login again. You don't need to use sql for anything else. You can specify the racaptcha keys from the Site Settings page. Just make sure you put them in correctly.

Hope that helps,

Joe

8/29/2011 12:51:13 PM
Gravatar
Total Posts 7

Re: Blog Comment Spam

the key you mentioned says "captcha"...

I'm guessing from your response that that includes any of the possible options for solutions and is agnostic.

 

I thought there might be different keys for kismet, or recaptcha...

8/29/2011 12:58:58 PM
Gravatar
Total Posts 18439

Re: Blog Comment Spam

No, that key is a true or false about whether a captcha is required on the login page. The setting for which kind of captcha is used is in a different table and field, it is best updated from the web ui in Site Settings not by directly accessing the database. I mean it could be updated by a query but it would be a different query and there is no reason to do it that way once you can login it is far easier to do it from the UI.

Best,

Joe

8/29/2011 1:17:45 PM
Gravatar
Total Posts 7

Re: Blog Comment Spam

Ok!

That worked like a charm.

Something definitely being funky with recaptcha, though.  Got my keys entered correctly, but login fails every time.

I'll keep playing with it, see if I can figure it out.  If all else fails, I'm post in an appropriate spot.

 

Thanks again, Joe.

You must sign in to post in the forums. This thread is closed to new posts.