NginxProxyManager / NginxProxyManager/nginx-proxy-manager
Posgresql error when fetch proxy host
Open
Nobody has claimed this yet.
bug
stale
- Dominant language
- TypeScript
- Stars
- 34.2k
- Forks
- 3.9k
- Avg merge
- 21h 12m
- Merged PRs (30d)
- 20
Description
After convert the DB from mysql into postgres, every thing works well, except access proxy hosts page.
The error log:
select "proxy_host".* from "proxy_host" where "is_deleted" = $1 group by "id" order by CAST("domain_names" AS text) ASC
- column "proxy_host.created_on" must appear in the GROUP BY clause or be used in an aggregate function
I think maybe this is a simillar issue to #4274
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start at the proxy hosts page and trace the query shown in the error log, then compare the behavior with issue #4274. Done means the proxy hosts page loads successfully after migrating to PostgreSQL without the GROUP BY error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, typescript
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100