[FIXED] Deleting users don't remove user from useractivation.

[Stadler]

Well, I think the topic says it all: When your deleting or mass-pruning users, their entrys aren't removed from the 'useractivation'-table.

Bug?

btw: I've used the following query to spot them:SELECT useractivation.* FROM useractivation AS useractivation LEFT JOIN user AS user USING (userid) WHERE user.userid IS NULLMaybe you want to add a feature to admin/misc.php to remove them from the database :)

[Stadler]

No one?

[Steve Machol]

Moved to Bugs for a Dev to check.

[Scott MacVicar]

fixed

[Stadler]

fine :)

Is there a new function to remove them in /admin/misc.php?

If not: I'm not sure, but would this query spot all invalid entrys:SELECT useractivation.* FROM useractivation AS useractivation LEFT JOIN user AS user USING (userid) WHERE user.usergroupid != 3 OR user.userid IS NULLIt checks for not existing users and users not in the Awaiting Confirmation-Group

[ManagerJosh]

shouldn't someone edit the thread title to say fixed? :D