Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...changing user registration type via MSSQLchanging user registration type via MSSQL
Previous
 
Next
New Post
6/3/2014 11:55 AM
 
gopher49


Joined: 4/3/2012
Posts: 17
It seems I'm being spammed for thousands of people are registering on my DNN 7.2.2 site.  It's set for public registration right now.. Whenever I change it to verified user registration or even none it gets turned back to public.  How can I change this in the MSSQL DB?  Also, is there a chance the module NB_Store is overridding this setting or putting it back?  It supports various user authentication settings for easy checkout but I don't have any of those enabled.
 
New Post
6/3/2014 12:11 PM
 

Joined: 1/1/0001
Posts: 0

It's probably not the store module... at least that hasn't been my experience.

Also,How can I change this in the MSSQL DB?
If you know some SQL you can change this using >Host >SQL.

Check these links for some spam insights:

http://www.dnnsoftware.com/community-blog/cid/154984/spammer-registrations 

http://www.dnnsoftware.com/wiki/page/replacing-registration-page-with-custom-and-blocking-the-default-register-page

http://support.managed.com/kb/a2000/how-to-prevent-stop-registration-spam-from-fake-accounts-dnn.aspx?KBSearchID=31476 

  

Regards
Mike
 
New Post
6/3/2014 12:33 PM
 
gopher49


Joined: 4/3/2012
Posts: 17
What field do I change?  I changed the 'User Registration' field to '4' instead of the '1' that was in there and it didn't change it.. Where do I change the user registration in the DB?  I have SQL Manager pulled up right now.  I can't change via the GUI for it goes right back.
 
New Post
6/3/2014 1:36 PM
 
gopher49


Joined: 4/3/2012
Posts: 17

I fixed it..  I went to the dbo.portals table and edited the 'User Registration' field to 3.  It seems it's 0-3 for options..  3 being verified.  For some reason the GUI wouldn't let me change it.. 

 But..  It seems CAPTA can be skipped by simply using the URL registration method..  I enabled CAPTA for registration and for logging in.. They where still able to register..  Is this normal?  

 
New Post
6/3/2014 3:30 PM
 
gopher49


Joined: 4/3/2012
Posts: 17
People are still spamming my registration even with verified turned on?! I went to the dbo.portals table and edited the 'User Registration' field to 3. It seems it's 0-3 for options.. 3 being verified. For some reason the GUI wouldn't let me change it.. But.. Now.. They are still spamming me even with verification turned on and CAPTCHA turned on.
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...changing user registration type via MSSQLchanging user registration type via MSSQL


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out