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?
  • I say safe to nuke all four, no activity whatsoever. Commented Oct 28, 2023 at 14:58
  • 2
    Looks like all of them were created on 2022-09-21 (00:36-01:53)? I wonder if something happened on that period... Commented Oct 28, 2023 at 15:39
  • @MetaAndrewT. Hmm, I didn't look that far. Maybe a rogue build that got reversed.
    – rene
    Commented Oct 28, 2023 at 15:42
  • 1
    @MetaAndrewT. or database hiccups, causing some of the queries to fail without crashing the whole code, so the code thought it was successful while it wasn't. Commented Oct 28, 2023 at 15:54
  • 5
  • Some answers have the exact same timestamp as the question (probably unrelated). Commented Oct 29, 2023 at 23:56
  • @This_is_NOT_a_forum probably the OP did post the answer at the same time, by ticking the "Answer your own question – share your knowledge, Q&A-style" checkbox on the Ask Question page. Commented Nov 4, 2023 at 10:13


You must log in to answer this question.

Browse other questions tagged .