Ticket #275 (closed defect: fixed)
Error waehrend Themensuche
| Reported by: | anonymous | Owned by: | dark |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | Frontend | Version: | beta13 |
| Keywords: | Cc: |
Description
Hi,
Als eingeloggter User, in der Mitgliederliste, sortiert nach Namen, aufsteigend -> Themensuche nach Tempolimit.
Folgender Error:
Database error of class SyntaxErrorOrAccessRuleViolation occured:
column "issue.cleaned" must appear in the GROUP BY clause or be used in an aggregate function
Stack trace follows:
[C]: in function 'escalate'
../lib/mondelefant.lua:753: in function 'exec'
../env/ui/paginate.lua:25: in function 'ui_paginate'
/opt/liquid_feedback/webapp/app/main/issue/_list.lua:192: in function 'content'
/opt/liquid_feedback/webapp/app/main/issue/_list.lua:287: in function 'func'
../env/execute/file_path.lua:24: in function 'file_path'
../env/execute/view.lua:17: in function 'view'
...opt/liquid_feedback/webapp/app/main/index/search.lua:30: in function 'func'
../env/execute/file_path.lua:24: in function 'file_path'
../env/execute/view.lua:17: in function 'view'
...
../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]: ?
TRACE
*
Configuration "piraten-pp"
*
REQUESTED VIEW: index/search
*
/main/_filter/20_session.lua
o SELECT "session".* FROM "session" WHERE (ident = 'MZuEDB0S6b4chvrjNTilfIawuf0mvPM9') LIMIT 1;
o
/main/_filter/21_auth.lua
+ SELECT "member".* FROM "member" WHERE ("member"."id" IN (1938));
+ Authentication accepted.
+
/main/_filter_view/30_navigation.lua
#
/main/_filter_view/31_logout_button.lua
*
/main/_filter_view/32_searchbox.lua
o
/main/_filter_view/33_help_hidden.lua
+
/main/_filter_view/34_stylesheet.lua
# SELECT "setting".* FROM "setting" WHERE (member_id = 1938 AND key = 'liquidfeedback_frontend_stylesheet_url') LIMIT 1;
# SELECT "setting".* FROM "setting" WHERE (member_id = 1938 AND key = 'tab_mode') LIMIT 1;
#
/main/_filter_view/35_openid.lua
*
EXECUTE VIEW: index/search
o
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 = 1938 WHERE ("initiative"."text_search_data" @@ "text_search_query"('Tempolimit') OR "draft"."text_search_data" @@ "text_search_query"('Tempolimit')) 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", "issue"."admission_time", "issue"."discussion_time", "issue"."verification_time", "issue"."voting_time", "_interest"."member_id") AS "subquery" LIMIT 1;
+
UNEXPECTED ERROR
...ich hoffe, das hilft euch, den Fehler zu finden. ;-)
