Users are missing from the webUI

[bram-nijenkamp]

• Gitea version (or commit ref): 1.14.0+dev-635-gf761c82c9
• Git version: 2.30.0
• Operating system: Docker latest
• Database (use [x]):
  • PostgreSQL
  • MySQL
  • MSSQL
  • SQLite
• Can you reproduce the bug at https://try.gitea.io:
  • Yes (provide example URL)
  • No

Description

Hello guys, I am currently having at least a user management problem. My main user is was once admin. Never having to look at it I just wanted to access the admin panel and nope, not admin anymore.

Thus I created a temporary admin account via the cli. The problem is that I don't see any users in the admin panel. When I list them in the cli they are thankfully still there. I can also still log into them. Does anybody know how to fix this?

I have also already tried to recreate all tables through the cli.

Updated:
I cheated my way with some url modification by changing the user_id. This way I was able to change the user to admin which I wanted. But now I only see the admin users incl. the new root user?
...

Screenshots

[zeripath]

agh... you were hit by the bug with #14387

[zeripath]

you're gonna need to look at a backup of your users table and restore it.

[6543]

sorry...! @FrozenSource if you need help on fixing DB just ask on Discord ...

[bram-nijenkamp]

sorry...! @FrozenSource if you need help on fixing DB just ask on Discord ...

Ok will do that then! I’m using a 2 week parity backup and have a long term hard backup. Putting those back didn’t solve it so I take it I will need to do it by hand.

[wULLSnpAXbWZGYDYyhWTKKspEQoaYxXyhoisqHf]

sorry...! @FrozenSource if you need help on fixing DB just ask on Discord ...

Ok will do that then! I’m using a 2 week parity backup and have a long term hard backup. Putting those back didn’t solve it so I take it I will need to do it by hand.

been there where you are, too.
unless your rollback method brings back the db in the exact state it was two weeks ago (if that's even desirable), you're left with missing data in the user table.. I had to manually put it back where it was, one by one (small instance so no worries). should you have a massive data set, it'd probably be worth it to write a little fix-up sql script to export only the missing data and have it automatically placed back where they belong.

as said above, pop a message in discord if you need help and glhf.

p.s. this was when I thanked myself for the backups :D

[techknowlogick]

Closing as this has been since handled in discord.