How can I delete blank members in the DB

[Yan21]

 

 

 

In my forum many Fake member have registered. How can I delete this at once?

thaks Yan

[Adlago]

@Yan21 Try this:

Log in ACP

1. Create new members group, name 'fake members' - example.

2. Open Support - SQL Toolbox

Copy and paste command

UPDATE core_members
SET member_group_id = "XX"
WHERE ip_address = "2003:78:etc";

XX - ID group 'fake members'

in ip_address - write the entire fake ip address

Click 'Run Query'

All members of this fake IP address will be moved to the new group.

3. Open  Members->Groups and from the drop-down menu to the right of this group select 'Delete'.

This should deprive you of these fake members.