The mystery of roleless users

[viktorcsimma]

Before the application period this year, the accounts of some campers had no roles whatsoever (not even a tenant role) and therefore, they did not get redirected either to the application page or to the tenant update page (where they could have applied). We have received many complaints about this.

My temporary solution then was to give each of them a tenant role. But this should not have happened...

The query which returned them quite accurately:

SELECT id, name FROM users
WHERE id NOT IN (SELECT user_id FROM role_users)
AND id NOT IN (SELECT user_id FROM applications)
AND id NOT IN (SELECT user_id FROM internet_accesses WHERE has_internet_until > '2024-07-29 00:00:00')
AND created_at > '2024-01-01 00:00:00';