User Dashboard: Repository overview not showing all repositories

[Wyall]

• Gitea version (or commit ref): 1.12.1 Docker
• Database (use [x]):
  • PostgreSQL
  • MySQL
  • MSSQL
  • SQLite
• Can you reproduce the bug at https://try.gitea.io:
  • Yes (provide example URL)
  • No
  • Not relevant

Description

I have 3 Repos, all are not archived. It seems like the filter settings in the repository view on the top right are misbehaving. See the screenshots. I would expect that all 3 show up in the first picture, but only 2 do. But maybe I am missing something and this works as intended. All 3 show up with the settings in the third screenshot.

Screenshots

[jangxx]

I had the the same problem just now. Apparently, for some of my repos, the is_archived column in the database was set to NULL instead of 0. I fixed it by simply running

UPDATE gitea.repository SET is_archived=0 WHERE is_archived IS NULL

on the database and now the repo overview is working again.

[6543]

there is a migration task wo take care of when migrating to v1.13.0 and gitea doctor is also able to fix this :) right with gitea >= 1.12.0

#11859

[6543]

@Wyall is is hard to find reverences to the doctor comand?

[6543]

./gitea doctor --run check-db-consistency --fix would do it

[warnat]

seems like it will be/was fixed with one of the next migrations here #11853
and here : b9e2812

So, if the problem itself is not acute right now, please close.

[Wyall]

Then let's see