Jump to content

How can I delete blank members in the DB

Recommended Posts

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

Link to comment
Share on other sites


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

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...