Error 500 when visit /issues and /pulls (too many SQL variables) #3729

Closed
opened 2025-11-02 05:23:19 -06:00 by GiteaMirror · 4 comments
Owner

Originally created by @ghost on GitHub (Aug 4, 2019).

  • Gitea version (or commit ref): 1.9.0 / 76408d50fb
  • Git version: 2.20.1
  • Operating system: macOS
  • 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:
routers/user/home.go:269:Issues() [E] CountIssuesByRepo: too many SQL variables

Description

The above error should be able to explain this issue.

cd238bc415/models/issue.go (L1357-L1366)

cd238bc415/models/issue.go (L1649-L1658)

cd238bc415/models/issue.go (L1708-L1710)

Originally created by @ghost on GitHub (Aug 4, 2019). - Gitea version (or commit ref): 1.9.0 / 76408d50fb - Git version: 2.20.1 - Operating system: macOS - Database (use `[x]`): - [ ] PostgreSQL - [ ] MySQL - [ ] MSSQL - [x] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [x] Not relevant - Log gist: ``` routers/user/home.go:269:Issues() [E] CountIssuesByRepo: too many SQL variables ``` ## Description The above error should be able to explain this issue. https://github.com/go-gitea/gitea/blob/cd238bc41598e69a78b4d17370c8929911c5f249/models/issue.go#L1357-L1366 https://github.com/go-gitea/gitea/blob/cd238bc41598e69a78b4d17370c8929911c5f249/models/issue.go#L1649-L1658 https://github.com/go-gitea/gitea/blob/cd238bc41598e69a78b4d17370c8929911c5f249/models/issue.go#L1708-L1710
GiteaMirror added the issue/confirmedtype/bug labels 2025-11-02 05:23:19 -06:00
Author
Owner

@stale[bot] commented on GitHub (Oct 4, 2019):

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs during the next 2 weeks. Thank you for your contributions.

@stale[bot] commented on GitHub (Oct 4, 2019): This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs during the next 2 weeks. Thank you for your contributions.
Author
Owner

@lunny commented on GitHub (Oct 5, 2019):

This should be closed by #8347

@lunny commented on GitHub (Oct 5, 2019): This should be closed by #8347
Author
Owner

@guillep2k commented on GitHub (Oct 8, 2019):

This should be reopened as per #8427

@guillep2k commented on GitHub (Oct 8, 2019): This should be reopened as per #8427
Author
Owner

@stale[bot] commented on GitHub (Dec 31, 2019):

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs during the next 2 weeks. Thank you for your contributions.

@stale[bot] commented on GitHub (Dec 31, 2019): This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs during the next 2 weeks. Thank you for your contributions.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#3729