XF 2.1 Rogue admin account. Not an admin

[Stuart Wright]

This account made by Jake Bunce to help us migrate from vBulletin in 2013 still exists with him showing as an Administrator

even though he's not listed as an admin in the admin page and he's not even in the administrator user group.
Where does this title come? How can I revert it to normal, please?

 

[beerForo]

Custom user title?

 

[Ozzy47]

Have you tried saving it (without him being admin) to update the DB?

 

[CypherForums]

Goto admin panel -> Groups & permissions -> Administrators , check in there that user will be listed there just removed it from there and you will be good to go

 

[Harpers Tate]

@beerForo No. This is in the heading on the AdminCP, not a User Title
@Ozzy47 Yes. No effect
@CypherForums It's not listed there.
So, the point is - it's not an Admin, but this label is still present on his AdminCP User Profile (only) as far as we can see.

 

[Chris D]

It will likely be coming from the is_admin flag in the xf_user table.

I would presume that if you add him as an admin and then remove him as an admin it should fix the discrepancy.

 

[andybond]

This account made by Jake Bunce to help us migrate from vBulletin in 2013 still exists with him showing as an Administrator
View attachment 242188
even though he's not listed as an admin in the admin page and he's not even in the administrator user group.
Where does this title come? How can I revert it to normal, please?

I wonder if that is a throwback to the "superadmin" option that we had in XF1?

 

[Ozzy47]

I wonder if that is a throwback to the "superadmin" option that we had in XF1?

No, I tested that theory and that's not the case.

 

[Harpers Tate]

It will likely be coming from the is_admin flag in the xf_user table.

I would presume that if you add him as an admin and then remove him as an admin it should fix the discrepancy.

Thanks. Tried that and....
"The specified user is already an administrator."
so can't try it.

 

[Chris D]

It’s just going to need a little database tweak then on the aforementioned column.

It’s likely too much time has passed to ascertain what might have gone wrong.

 

[Harpers Tate]

OK Thx. One for @Stuart Wright

 

[Stuart Wright]

Confirmed that is_admin was 1 causing it.
Since Jake hasn't visited the forum again since he helped migrate to Xenforo in 2013, I've delete the account.
Mystery solved, thanks.

 

[Wildcat Media]

Another though...was his user ID listed in the config.php file as a "super admin"?

 

[Chris D]

It’s irrelevant.

In XF 1.x being listed as a super admin does not make you an admin and being a super admin or not does not show or hide that label. You had to actually be an Admin.

In XF 2.x that config entry is unused entirely.