Jump to content

How can I delete blank members in the DB

Featured Replies

Posted
 
 
 

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

thaks Yan

schaedlings.de_2016-11-20_12-31-44.png

schaedlings.de_2016-11-20_12-31-08.png

@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.

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.