Blank subscribers

  • Neal Barnett
  • Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 8 months ago #116788 by Neal Barnett
Blank subscribers was created by Neal Barnett
This morning, it appears that over 300 blank subscribers were added to the database in the osmembership_subscribers table (see screenshot), but the blank records don't appear in Users or Community Builder. Can you tell me how these may have gotten in there, and what the best way to remove them is?

Thanks,
Neal
Attachments:

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
6 years 8 months ago #116806 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Blank subscribers
Hi Neal

That's strange to me. Look like spam subscription somehow:

1. Do you have captcha enabled in Membership Pro? If not, please enable captcha to prevent these spam subscriptions

2. Are you using latest version of Membership Pro ? If not, please upgrade

Honestly, if you are using latest version, I don't know how these blank subscriptions come there because we have code to validate the subscription data before it's added to database

Tuan

Please Log in or Create an account to join the conversation.

  • Neal Barnett
  • Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 8 months ago #116814 by Neal Barnett
Replied by Neal Barnett on topic Blank subscribers
Hi Tuan -

We do have the latest version, and no we currently are not using Captcha (but perhaps we should).

What's the best way to remove these blank subscribers (about 300) and blank subscriptions (about 50)?

Thanks,
Neal

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
6 years 8 months ago #116817 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Blank subscribers
Hi Neal

The only way is delete data from database directly

Run this SQL commands and it should help;

DELETE FROM #__osmembership_subscribers WHERE first_name IS NULL

(#__osmembership_subscribers must be replaced with the correct table name in the database)

If you don't know how to do that, submit a support ticket sending us super admin account of your site so that we can check it

Tuan

Please Log in or Create an account to join the conversation.