Ticket #85 (closed defect: fixed)
Fehler bei Suche nach "Lizenz"
| Reported by: | rka | Owned by: | |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | Frontend | Version: | beta9 |
| Keywords: | Cc: |
Description
Database error of class SyntaxErrorOrAccessRuleViolation occured:
column "_interest.member_id" must appear in the GROUP BY clause or be used in an aggregate function
Stack trace follows:
[C]: in function 'escalate'
../lib/mondelefant.lua:417: in function 'exec'
../env/ui/paginate.lua:25: in function 'ui_paginate'
/opt/liquid_feedback/webapp/app/main/issue/_list.lua:232: in function 'content'
/opt/liquid_feedback/webapp/env/ui/order.lua:39: in function 'content'
../env/ui/tag.lua:38: in function <../env/ui/tag.lua:15>
(tail call): ?
/opt/liquid_feedback/webapp/env/ui/order.lua:36: in function 'content'
../env/ui/tag.lua:38: in function <../env/ui/tag.lua:15>
(tail call): ?
...
../env/execute/wrapped.lua:21: in function <../env/execute/wrapped.lua:11>
(tail call): ?
(tail call): ?
../env/execute/filtered_view.lua:28: in function 'filtered_view'
webmcp.lua:354: in function <webmcp.lua:231>
[C]: in function 'xpcall'
webmcp.lua:230: in main chunk
[C]: in function 'pcall'
...feedback/webmcp/framework/cgi-bin/webmcp-wrapper.lua:7: in main chunk
[C]: ?
Configuration "piraten-be"
Configuration "piraten-default"
Configuration "default"
REQUESTED VIEW: index/search
/main/_filter/20_session.lua
SELECT "session".* FROM "session" WHERE (ident = '5mGKkt0NvHu7zDFx3H6CGMkTEtsnjlet') LIMIT 1;
/main/_filter/21_auth.lua
SELECT "member".* FROM "member" WHERE ("member"."id" IN (54));
Authentication accepted.
/main/_filter_view/30_navigation.lua
SELECT "setting".* FROM "setting" WHERE (member_id = 54 AND key = 'liquidfeedback_frontend_timeline_current_options') LIMIT 1;
/main/_filter_view/31_logout_button.lua
/main/_filter_view/32_searchbox.lua
/main/_filter_view/33_help_hidden.lua
/main/_filter_view/34_stylesheet.lua
SELECT "setting".* FROM "setting" WHERE (member_id = 54 AND key = 'liquidfeedback_frontend_stylesheet_url') LIMIT 1;
EXECUTE VIEW: index/search
EXECUTE VIEW: member/_list
SELECT count(1) FROM (SELECT "member".*, "highlight"("member"."name", 'lizenz') AS "name_highlighted" FROM "member" WHERE ("member"."text_search_data" @@ "text_search_query"('lizenz')) AND (active) ORDER BY created DESC, id DESC) AS "subquery" LIMIT 1;
SELECT "member".*, "highlight"("member"."name", 'lizenz') AS "name_highlighted" FROM "member" WHERE ("member"."text_search_data" @@ "text_search_query"('lizenz')) AND (active) ORDER BY created DESC, id DESC LIMIT 100 OFFSET -100;
EXECUTE VIEW: issue/_list
SELECT count(1) FROM (SELECT "issue".*, (_interest.member_id NOTNULL) AS "is_interested" FROM "issue" INNER JOIN "initiative" ON "initiative"."issue_id" = "issue"."id" INNER JOIN "draft" ON "draft"."initiative_id" = "initiative"."id" LEFT OUTER JOIN interest AS "_interest" ON _interest.issue_id = issue.id AND _interest.member_id = 54 WHERE ("initiative"."text_search_data" @@ "text_search_query"('lizenz') OR "draft"."text_search_data" @@ "text_search_query"('lizenz')) AND (issue.closed ISNULL) GROUP BY "issue"."id", "issue"."area_id", "issue"."policy_id", "issue"."created", "issue"."accepted", "issue"."half_frozen", "issue"."fully_frozen", "issue"."closed", "issue"."ranks_available", "issue"."snapshot", "issue"."latest_snapshot_event", "issue"."population", "issue"."vote_now", "issue"."vote_later", "issue"."voter_count" ORDER BY (SELECT max(supporter_count) FROM initiative WHERE initiative.issue_id = issue.id) DESC) AS "subquery" LIMIT 1;
UNEXPECTED ERROR
Finished after 45.5 ms (40.0 ms CPU)
close

Die Suche ist wohl derzeit komplett unbrauchbar. Unabhängig der Suchabfrage wird eine Fehlermeldung ausgegeben.