We know account creation is finicky from answers to questions like Why is my profile messed up on a single site and how can I revert it? among others.
In some of these cases you end-up with a user-profile but no network account. In technical terms: The accountid for that User in the Users table is null.
Somehow 4 "users"(?) managed to create user profiles on two different sites with the accountid being 0. So that is not null, but it is not working either. These users do have a network profile button, but clicking it brings you to the panda.
Here is the query:
select 'photo.se' site
, id
, accountid
, displayname
, concat('https://photo.stackexchange.com/users/', id, '|',displayname) [link]
from [StackExchange.Photography].dbo.Users
where accountid = 0
union all
select 'math.se'
, id
, accountid
, displayname
, concat('https://math.stackexchange.com/users/', id, '|',displayname)
from [StackExchange.math].dbo.Users
where accountid = 0
I have two questions:
- Can / Should these accounts be fixed?
- Is having no network account / aka no accountid in the Users table a valid case?