Delete Members Directly from Database?

[jaeitee]

Curious if there's any issue deleting Members directly from the database?  We have just migrated to IPS and have a heap of spam accounts we would like to delete, however searching for them in the AdminCP then "Prune" all the results isn't working.  So is there any negative impact just deleting them directly from the members table in SQL?

[Marcher Technologies]

Please don't do that. Yes, there is a very real immediate negative impact, you would be leaving behind data in multiple tables attached to those members. As a result you would have lost your database's referential integrity, which is something not easily repaired(I have had to do it, it takes a developer that knows the software inside and out to do it properly, it is very time consuming and best avoided).

I would recommend submitting a ticket to have the inbuilt tool failing investigated and fixed.