Deleting Unconfirmed Members

Hi-

One time I selected "unconfirmed" members from the member option.

The selected "select all"

Then clicked "Delete"

and every member in the database was deleted. It seems like it should have just deleted the "unconfirmed members" from the database.

Fortunately I backed up just prior.

I am now on Dolphin 7.0.9 and don't really want to go through the hassle of restoring my database.

Has anybody else had this problem?

Peer

Wouldn't you want it automatic?

http://www.boonex.com/m/delete-unconfirmed-members

Check that out.

I have this and asked Dean about this and he said it only removes current users.
I have several of his products, and he installed them. Do you think he might be thinking that we are talking about different products?

Here is my screen shot..

Actually. I thought you were referring to the spam filtering.

No. The delete unconfirmed members mod will delete any unconfirmed members that have remained unconfirmed and have not logged in within the number of days you have set it for.

So for example. If you set it for 14 days, then it will delete all members that have remained unconfirmed for more than 14 days and have not logged in at all during those 14 days.

However it may have problems if trying to delete a large number of members. I have seen issues with cron on both this and the already existing inactive member delete when trying to remove a large number of members. The cron job may crap out due to memory problems. That is a problem internal to dolphin, it's cron script and the function thats called to delete a member. It's not something i can fix.

So it is still best if you have a large number to purge them by hand first.

How many unconfirmed do you have?


The purge days should be set high. Close to the date of the oldest unconfirmed member. Then as it starts purging which will only occurs once per night, lower it by one day each day.

I have a feeling it trying to remove to many at a time which dolphins cron system has problems doing.

Yea, just look at your last email of over 9000 unconfirmed users.

That's to many. Cron will fail to remove them. See if you can determine how old the oldest one is in days and set the purge time equal to that.

Wait 2 days, if the number does not start dropping, pm me with your login details and i will try adjusting the script to deal with the large number.

you are the best  and write awesome tools!

i will take all of your recomentations.

peer

The problem is with dolphins profile_delete function.

It works fine when an admin is logged in, but not from a cron job. The problem is when the alert is triggered. Apparently some of the profile delete alerts for some of the installed modules require a member be logged in and will attempt to prompt for login which of course can't be done from cron. So the delete fails.

This is a bug in dolphin that i need to report. I believe i can get around it, but i have to figure out which modules are causing this and find a way to deal with it. May take some time.

The good news is selecting all did not delete the entire database with this version.

I manually cleaned up the database and believe for the first time this problem is under control.

Thanks to all for your help. 

P.

So, 

I have a question. The filters seem to be working. This is great. One thing I don't understand is we are still getting emails that a user has been confirmed. It is fine that they don't show up in the list. I see them in the spam list.

But... How do the go from unconfirmed to the confirmed list if their are items in their profile that should get them blocked in the first place... :) Not complaining, just curious.... We are VERY happy!

Five stars again for Dean!

It's a trick some spammers are using. They initially sign up using clean information that passes the filters. Then the profile is edited after to put links in their profile description. So to catch this, a filter was added to check the profile after editing it.

However by that time dolphin has already sent out the emails about the new signup because they already made it by the filters during the initial join process. The log should show the reason. The stats will also show the number that edited the profile after signup.

Thanks for the explanation.

Again, you rock.

Peer

I think my stats may not be updating correctly.

If this is not the correct place to post these questions, please let me know. :)

Thanks!

Peer

 It's not. The product has it's own support forum here. http://www.boonex.com/forums/topic/Dolphin-Anti-Spam-support-forum-.htm

And no. Your stats do not appear to be updating properly. The cron job is not running. This does not necessarily mean it's a problem with the module. If dolphin is not running cron jobs, then the stats will not update.

Make sure you have the current version of the module. Uninstall and reinstall the module. Verify the cron jobs are running. Are you getting nightly reports from dolphin. Are uploaded videos processing, ect.