- Posts: 13
- Thank you received: 0
Blank subscribers
- Neal Barnett
- Topic Author
- Offline
- New Member
-
Less
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
Thanks,
Neal
- Tuan Pham Ngoc
- Away
- Administrator
-
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
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
-
Less
More
- Posts: 13
- Thank you received: 0
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
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
-
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
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.
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.