Error: pq: syntax error at or near "." whilst counting Collaborations without existing user

[frnmst]

Gitea Version

1.15.6

Git Version

git version 2.20.1

Operating System

Debian 10

How are you running Gitea?

using deb [arch=amd64] https://packaging.gitlab.io/gitea buster stable as APT source

Database

PostgreSQL

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Description

I migrated from Gitea 1.15.2 directly to 1.15.6. If I run the following I get the error.

HOME=/var/lib/gitea GITEA_WORK_DIR=/var/lib/gitea /usr/bin/gitea -c /etc/gitea/app.ini doctor --all --fix

[1] Check paths and basic configuration
 - [I] Configuration File Path:    "/etc/gitea/app.ini"
 - [I] Repository Root Path:       "/var/lib/gitea/repos"
 - [I] Data Root Path:             "data"
 - [I] Custom File Root Path:      "/var/lib/gitea/custom"
 - [I] Work directory:             "/var/lib/gitea"
 - [I] Log Root Path:              "/var/log/gitea"
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 Collaborations 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

[... continues normally ...]

Anyway, everthing seems to be working fine. The collaboration table in the database is empty.

Screenshots

No response

[clarfonthey]

Are you sure that this is fixed? I'm still getting the error even though I'm running 1.15.7, which supposedly has the fix.

[zeripath]

Is it still the same warning exactly?

[zeripath]

gitea/modules/doctor/dbconsistency.go

Line 170 in a9ed1c5

"collaboration", "user", "collaboration.user_id=user.id"),

user needs to be backticked in the query at the end

[clarfonthey]

Yeah, unfortunately there's no specific clarification on the error that lets you see what the specific syntax error is, and it shows up as the same. Maybe worth fixing that as well as the underlying issue.