Subject: SQL to correctly delete users

Posted on: 25/05/08 06:43pm
By: ScurvyDawg

I just updated a really old install of GL.

I ended up with gobs and gobs of spammy users in my DB.

To remove these manually will be a trying task.

What is the correct SQL to safely remove these users and all their settings.

Thanks so much
:chestslam:

Re: SQL to correctly delete users

Posted on: 25/05/08 06:50pm
By: ScurvyDawg

want to delete

UID 329 to UID 13170

thought some clarity might help.

Re: SQL to correctly delete users

Posted on: 26/05/08 01:50am
By: Dirk

Since this involves several tables, there is no single SQL statement for that.

Did you see the "Batch Admin" option in the admin's Users panel? You can mass-delete users from there.

bye, Dirk

Re: SQL to correctly delete users

Posted on: 26/05/08 10:36am
By: ScurvyDawg

I had not noticed the batch admin stuff.

Just what I needed, thank much.

:banana:

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=82875