Organization Dashboard Error On MSSQL #612

Closed
opened 2025-11-02 03:29:56 -06:00 by GiteaMirror · 0 comments
Owner

Originally created by @Trcx528 on GitHub (Apr 4, 2017).

Originally assigned to: @lunny on GitHub.

  • Gitea version (or commit ref):
  • Git version: gitea-1.1-windows-4.0-amd64
  • Operating system: Windows Server 2012 R2
  • Database (use [x]):
    • PostgreSQL
    • MySQL
    • MSSQL
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • No
    • Not relevant
  • Log gist:

2017/04/04 08:40:09 [...routers/user/home.go:132 Dashboard()] [E] env.MirrorRepos: mssql: Column 'repository.owner_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Description

Setup and configured a new gitea instance using MSSQL backend. Created a new organization and the dashboard for that organization fails to load and gives a 500 error.

Screenshots

image

Originally created by @Trcx528 on GitHub (Apr 4, 2017). Originally assigned to: @lunny on GitHub. - Gitea version (or commit ref): - Git version: gitea-1.1-windows-4.0-amd64 - Operating system: Windows Server 2012 R2 - Database (use `[x]`): - [ ] PostgreSQL - [ ] MySQL - [x] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [x] Not relevant - Log gist: 2017/04/04 08:40:09 [...routers/user/home.go:132 Dashboard()] [E] env.MirrorRepos: mssql: Column 'repository.owner_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. ## Description Setup and configured a new gitea instance using MSSQL backend. Created a new organization and the dashboard for that organization fails to load and gives a 500 error. ## Screenshots ![image](https://cloud.githubusercontent.com/assets/1213427/24660964/9d5732c0-1916-11e7-808b-9d313f67a1a5.png)
GiteaMirror added the type/bug label 2025-11-02 03:29:56 -06:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#612