gitea doctor: pq: syntax error at or near "." whilst counting Orphaned Stopwatches without existing User #9083

New Issue

GiteaMirror · 2025-11-02T08:28:47-06:00

GiteaMirror commented

2025-11-02 08:28:47 -06:00

Originally created by @Fogapod on GitHub (Jun 18, 2022).

Description

Full doctor output:

git@localhost:/var/lib/gitea$ gitea doctor --all --config /etc/gitea/app.ini -w . -C ./custom --fix
[1] Check paths and basic configuration
 - [I] Configuration File Path:    "/etc/gitea/app.ini"
 - [I] Repository Root Path:       "/var/lib/gitea/data/gitea-repositories"
 - [I] Data Root Path:             "data"
 - [I] Custom File Root Path:      "custom"
 - [I] Work directory:             "."
 - [I] Log Root Path:              "/var/lib/gitea/log"
OK
[2] Check if there is garbage storage files
OK
[3] Check Database Version
OK
[4] Check consistency of database
 - [C] Error: pq: syntax error at or near "." whilst counting Orphaned Stopwatches without existing User
ERROR
[5] Check if user with wrong type exist
OK
[6] Check if OpenSSH authorized_keys file is up-to-date
OK
[7] Check if SCRIPT_TYPE is available
 - [I] ScriptType bash is on the current PATH at /usr/bin/bash
OK
[8] Check if hook files are up-to-date and executable
OK
[9] Recalculate Stars number for all user
 - [I] Updated User Stars numbers.
OK
[10] Check old archives
 - [I] 0 / 0 old archives in repository deleted
OK
[11] Check that all git repositories have receive.advertisePushOptions set to true
 - [I] Enabled push options for 4 repositories.
OK
[12] Check for incorrectly dumped repo_units (See #16961)
 - [I] Fixed 0 broken repo_units
OK
[13] Recalculate merge bases
 - [I] 0 PR mergebases updated of 16 PRs total in 4 repos
OK
[14] Check git-daemon-export-ok files
 - [I] Updated git-daemon-export-ok files for 0 of 4 repositories.
OK
[15] Check if users has an valid email address
 - [I] All users have a valid e-mail.
OK

Gitea Version

1.17.0+dev-751-g433443ffa built with GNU Make 4.3, go1.18.1 : bindata

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

No response

Operating System

No response

How are you running Gitea?

Locally compiled binary

Database

PostgreSQL

Originally created by @Fogapod on GitHub (Jun 18, 2022). ### Description Full doctor output: ```sh git@localhost:/var/lib/gitea$ gitea doctor --all --config /etc/gitea/app.ini -w . -C ./custom --fix [1] Check paths and basic configuration - [I] Configuration File Path: "/etc/gitea/app.ini" - [I] Repository Root Path: "/var/lib/gitea/data/gitea-repositories" - [I] Data Root Path: "data" - [I] Custom File Root Path: "custom" - [I] Work directory: "." - [I] Log Root Path: "/var/lib/gitea/log" OK [2] Check if there is garbage storage files OK [3] Check Database Version OK [4] Check consistency of database - [C] Error: pq: syntax error at or near "." whilst counting Orphaned Stopwatches without existing User ERROR [5] Check if user with wrong type exist OK [6] Check if OpenSSH authorized_keys file is up-to-date OK [7] Check if SCRIPT_TYPE is available - [I] ScriptType bash is on the current PATH at /usr/bin/bash OK [8] Check if hook files are up-to-date and executable OK [9] Recalculate Stars number for all user - [I] Updated User Stars numbers. OK [10] Check old archives - [I] 0 / 0 old archives in repository deleted OK [11] Check that all git repositories have receive.advertisePushOptions set to true - [I] Enabled push options for 4 repositories. OK [12] Check for incorrectly dumped repo_units (See #16961) - [I] Fixed 0 broken repo_units OK [13] Recalculate merge bases - [I] 0 PR mergebases updated of 16 PRs total in 4 repos OK [14] Check git-daemon-export-ok files - [I] Updated git-daemon-export-ok files for 0 of 4 repositories. OK [15] Check if users has an valid email address - [I] All users have a valid e-mail. OK ``` ### Gitea Version 1.17.0+dev-751-g433443ffa built with GNU Make 4.3, go1.18.1 : bindata ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version _No response_ ### Operating System _No response_ ### How are you running Gitea? Locally compiled binary ### Database PostgreSQL

GiteaMirror added the type/bug label 2025-11-02 08:28:47 -06:00

GiteaMirror closed this issue

2025-11-02 08:28:47 -06:00

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#9083