diff options
| author | pitpalme <pitpalme@users.noreply.github.com> | 2023-11-24 20:54:14 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-11-24 14:54:14 -0500 |
| commit | 7cae4dfc0048db02bef34ff1b8726e82b052fb85 (patch) | |
| tree | 1eac107d6f7a0e70e299250149bf27da0d816181 | |
| parent | 28b8e0b43e0cd4059912db6025b2e9ad9ee7fbdf (diff) | |
| download | gitea-7cae4dfc0048db02bef34ff1b8726e82b052fb85.tar.gz gitea-7cae4dfc0048db02bef34ff1b8726e82b052fb85.zip | |
Fix delete-orphaned-repos (#28200) (#28202)
Backport #28200
gitea doctor failed at checking and fixing 'delete-orphaned-repos',
because table name 'user' needs quoting to be correctly recognized by at
least PostgreSQL.
fixes #28199
| -rw-r--r-- | modules/doctor/repository.go | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/modules/doctor/repository.go b/modules/doctor/repository.go index 6569378cbe..46c64f9f4b 100644 --- a/modules/doctor/repository.go +++ b/modules/doctor/repository.go @@ -26,7 +26,7 @@ func handleDeleteOrphanedRepos(ctx context.Context, logger log.Logger, autofix b // countOrphanedRepos count repository where user of owner_id do not exist func countOrphanedRepos(ctx context.Context) (int64, error) { - return db.CountOrphanedObjects(ctx, "repository", "user", "repository.owner_id=user.id") + return db.CountOrphanedObjects(ctx, "repository", "user", "repository.owner_id=`user`.id") } // deleteOrphanedRepos delete repository where user of owner_id do not exist @@ -39,7 +39,7 @@ func deleteOrphanedRepos(ctx context.Context) (int64, error) { for { var ids []int64 if err := e.Table("`repository`"). - Join("LEFT", "`user`", "repository.owner_id=user.id"). + Join("LEFT", "`user`", "repository.owner_id=`user`.id"). Where(builder.IsNull{"`user`.id"}). Select("`repository`.id").Limit(batchSize).Find(&ids); err != nil { return deleted, err |