By Paul Towlson on

Is it possible to delete an account without blocking, saving, then deleting and confirming? It is not very convenient if a whole set of users have to be deleted. Otherwise, is it safe to simply delete users in a database manager (phpMyAdmin or the Drupal db manager) ?

Comments

Lam0r’s picture

Lam0r commented

^^kick

I never had problems deleting single users through database. Today I am facing another dilema. Apparently some prankster registered 4 user accounts on the site. Messing up my "unique user count". Last time I deleted 4 accounts the next counts registration continued from the last accounts number ( e.g user account 100) instead of 96 for example.

I want to delete 4 accounts from 669 to 673. The next user registration should start from 669. I hope someone can help me :D

tostinni’s picture

tostinni commented

When you delete users, you don't modify the sequence table, so you add to update it :
UPDATE sequence SET id='668' WHERE name='users_uid'

Lam0r’s picture

Lam0r commented

I managed to delete and the next user registration seamlesly started from 669

Thanks. I love to see my database neat :D withouth gaps

sami_k’s picture

sami_k commented

You're too picky, relax... :P