I have encountered a weird problem in a Drupal site. Whenever I try to ban an abusive user, by going to the user's profile, change his status from active to blocked, and click save, the change does not take effect. Instead I just get a server time out message. There are a couple of thousands of users so disability to ban abusive ones is quite a hassle. Any suggestion to solve this?
Do it in the actual database, not via Drupal but via CLI, PHPMyAdmin, or whatever you have.
- Find out the user's ID.
- Go in to the raw database, i.e. not via Drupal but via CLI, PHPMyAdmin.
- Go the user table.
- Find their ID.
- Set the status field for that user to 0 (which means blocked).
The raw SQL would be something like (I haven't tested this):
UPDATE users SET status = 0 WHERE id = [user's id]
To block certain users in drupal6 go to the user management->access rules this will take to you www.yoursitename/admin/user/rules/list . In this click "Add Rule" tab and select "Deny" under access type and "Username" under Rule type (as you want to block the user) and enter the user name in the text field under the "Mask" and click "Add rule".