• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.

Delete multiple users

Skotina

Chevereto Member
Hello everyone,

I have a problem with a lot of registering users on my Chevereto installation and most of them have 0 images uploaded (for like years) and 90% of them look like spam registrations.
Is there any way to delete several users per click? Tired of opening their profiles and hitting delete & confirmation button.

Would appreciate your feedback. Thanks.
 
[DE]
Über das Dashboard ist das derzeit nicht möglich, aber Du kannst es mit zum Beispiel mit phpMyAdmin machen.
Folgender SQL Code zum finden: SELECT * FROM `chv_users` WHERE `user_album_count` = 0 AND `user_is_manager` = 0
Zum löschen von allen Benutzern ohne Uploads DELETE FROM `chv_users` WHERE `chv_users`.`user_album_count` = 0 AND `chv_users`.`user_is_manager` = 0

[EN]
This is currently not possible on the dashboard, but you can do it with phpMyAdmin, for example.
The following SQL code can be found: SELECT * FROM `chv_users` WHERE `user_album_count` = 0 AND `user_is_manager` = 0
To delete all users without uploads DELETE FROM `chv_users` WHERE `chv_users`.`user_album_count` = 0 AND `chv_users`.`user_is_manager` = 0
 
[EN]
This is currently not possible on the dashboard, but you can do it with phpMyAdmin, for example.
The following SQL code can be found: SELECT * FROM `chv_users` WHERE `user_album_count` = 0 AND `user_is_manager` = 0
To delete all users without uploads DELETE FROM `chv_users` WHERE `chv_users`.`user_album_count` = 0 AND `chv_users`.`user_is_manager` = 0

Thanks for the SQL code, DeCysos. Is it safe enough to run this? Won't simply deleting blank users (in terms of albums and images) affect other parts of the DB or web output? Thanks.
 
As long as the user(s) have not actually uploaded any images, it should not affect the rest.

But as always, one should create a backup of the database for such actions in order to be able to react quickly and safely if necessary.
 
Back
Top