Sorting by name on explore projects page renders a 500 error when logged in
Summary
On the Explore Projects page, sorting by name returns a 500 error when you are logged in. When you are logged out, sorting by name works fine.
Steps to reproduce
- Login to gitlab.com
- Go to: https://gitlab.com/explore/projects?sort=name_asc
What is the current bug behavior?
A 500 error page is shown
What is the expected correct behavior?
The explore projects page with all projects sorted by name should be shown
Relevant logs and/or screenshots
When running gitlab locally in development I get the following error about the generated SQL query:
ERROR: column reference "name" is ambiguous at character 605
STATEMENT:
SELECT "projects"."id"
FROM "projects"
LEFT OUTER JOIN "routes"
ON "routes"."source_id" = "projects"."id"
AND "routes"."source_type" = $1
LEFT OUTER JOIN "namespaces"
ON "namespaces"."id" = "projects"."namespace_id"
LEFT OUTER JOIN "routes" "routes_namespaces"
ON "routes_namespaces"."source_id" = "namespaces"."id"
AND "routes_namespaces"."source_type" = $2
WHERE ( EXISTS (SELECT 1
FROM "project_authorizations"
WHERE "project_authorizations"."user_id" = 1
AND ( project_authorizations.project_id = projects.id ))
OR projects.visibility_level IN ( 0, 10, 20 ) )
AND "projects"."archived" = $3
ORDER BY Lower(name) ASC
LIMIT 20 offset 0
Output of checks
This bug happens on GitLab.com
Possible fixes
the ORDER BY lower(name)
should be prefixed with the projects table to ORDER BY lower(projects.name)
Edited by Aram Visser