Error 500 can't open an issue or a pr #10235

New Issue

GiteaMirror · 2025-11-02T09:01:46-06:00

GiteaMirror commented

2025-11-02 09:01:46 -06:00

Originally created by @odybhoja on GitHub (Feb 7, 2023).

Description

The problem happen when opening a new issue i get the error 500 page. The same thing happen when i try to open a PR.
It's a brand new installation.

Gitea Version

1.18.3

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

699fae4753/gitea.log

Screenshots

Git Version

No response

Operating System

linux centos

How are you running Gitea?

from a docker image ( gitea/gitea )

Database

PostgreSQL

Originally created by @odybhoja on GitHub (Feb 7, 2023). ### Description The problem happen when opening a new issue i get the error 500 page. The same thing happen when i try to open a PR. It's a brand new installation. ### Gitea Version 1.18.3 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist https://gist.githubusercontent.com/0xOdy/071bdd821fca7dfb6a75bc564e4ccc1f/raw/699fae4753f8be9b620df802c0d2dd62d10e64c2/gitea.log ### Screenshots ![Screenshot from 2023-02-07 14-32-21](https://user-images.githubusercontent.com/80256731/217274868-cafe83e4-cf2c-4573-bc3e-8c9deae97f01.png) ### Git Version _No response_ ### Operating System linux centos ### How are you running Gitea? from a docker image ( gitea/gitea ) ### Database PostgreSQL

GiteaMirror added the type/bug label 2025-11-02 09:01:46 -06:00

GiteaMirror closed this issue

2025-11-02 09:01:46 -06:00

GiteaMirror commented

2025-11-02 09:01:47 -06:00

@jolheiser commented on GitHub (Feb 7, 2023):

What version of postgres do you have? Also are there postgres logs?

@jolheiser commented on GitHub (Feb 7, 2023): What version of postgres do you have? Also are there postgres logs?

GiteaMirror commented

2025-11-02 09:01:47 -06:00

@wxiaoguang commented on GitHub (Feb 7, 2023):

The answer is clear: the postgresql verson is too old.

I have talked with @lunny about this problem long ago, about adding database version checks

@wxiaoguang commented on GitHub (Feb 7, 2023): The answer is clear: the postgresql verson is too old. I have talked with @lunny about this problem long ago, about adding database version checks

GiteaMirror commented

2025-11-02 09:01:48 -06:00

@odybhoja commented on GitHub (Feb 7, 2023):

Thanks you,
Will be upgrading postgresql

@odybhoja commented on GitHub (Feb 7, 2023): Thanks you, Will be upgrading postgresql

GiteaMirror commented

2025-11-02 09:01:48 -06:00

@lunny commented on GitHub (Feb 8, 2023):

The answer is clear: the postgresql verson is too old.

I have talked with @lunny about this problem long ago, about adding database version checks

XORM now supported returning the database version, but I think many users maybe use a customized database. So we cannot prevent users to use Gitea according to that versions.

@lunny commented on GitHub (Feb 8, 2023): > The answer is clear: the postgresql verson is too old. > > I have talked with @lunny about this problem long ago, about adding database version checks XORM now supported returning the database version, but I think many users maybe use a customized database. So we cannot prevent users to use Gitea according to that versions.

GiteaMirror commented

2025-11-02 09:01:48 -06:00

@wxiaoguang commented on GitHub (Feb 8, 2023):

So we cannot prevent users to use Gitea according to that versions.

Then Gitea doesn't run well, how would the users think? It just hurts users.
Gitea itself already declared that "PostgreSQL (>=10)", https://docs.gitea.io/en-us/database-prep/

@wxiaoguang commented on GitHub (Feb 8, 2023): > So we cannot prevent users to use Gitea according to that versions. 1. Then Gitea doesn't run well, how would the users think? It just hurts users. 2. Gitea itself already declared that "PostgreSQL (>=10)", https://docs.gitea.io/en-us/database-prep/

GiteaMirror commented

2025-11-02 09:01:48 -06:00

@odybhoja commented on GitHub (Feb 8, 2023):

Working great after installing postgresql-server-12 on my system.
THnaks a lot.

@odybhoja commented on GitHub (Feb 8, 2023): Working great after installing postgresql-server-12 on my system. THnaks a lot.

GiteaMirror commented

2025-11-02 09:01:48 -06:00

@zeripath commented on GitHub (Feb 8, 2023):

Perhaps we can use SHOW server_version; and parse the output in someway in order to tell people they're running too old a version of Postgres?

@zeripath commented on GitHub (Feb 8, 2023): Perhaps we can use `SHOW server_version;` and parse the output in someway in order to tell people they're running too old a version of Postgres?

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/gitea#10235