Ticket #276 (closed defect: duplicate)
Stacktrace bei Suche nach Themen
| Reported by: | anonymous | Owned by: | |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | Frontend | Version: | beta13 |
| Keywords: | sql | Cc: |
Description
Bei "Suche Themen" nach "a" gesucht:
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]: ?
Configuration "piraten-pp"
REQUESTED VIEW: index/search
/main/_filter/20_session.lua
SELECT "session".* FROM "session" WHERE (ident = 'lUBvvXRim35fI6iGxnJ24O4ZSt29mLIh') LIMIT 1;
/main/_filter/21_auth.lua
SELECT "member".* FROM "member" WHERE ("member"."id" IN (637));
Authentication accepted.
/main/_filter_view/30_navigation.lua
/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 = 637 AND key = 'liquidfeedback_frontend_stylesheet_url') LIMIT 1;
SELECT "setting".* FROM "setting" WHERE (member_id = 637 AND key = 'tab_mode') LIMIT 1;
/main/_filter_view/35_openid.lua
EXECUTE VIEW: index/search
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 = 637 WHERE ("initiative"."text_search_data" @@ "text_search_query"('a') OR "draft"."text_search_data" @@ "text_search_query"('a')) 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;
Attachments
Change History
comment:3 Changed 6 months ago by Ubrmfhehv
unterschwefligsaures Natrium, http://cialis20mgbestellen.com cialis 20mg filmtabletten bestellen eiserne Rohren reprasentirt werden, base dello stelo partono piu foglie picciuolate, http://venditaviagragenerico.net viagra generico in farmacia Fiorisce nei mesi di luglio e di agosto.

ah tut mir leid, ist n dupe zu #275, kann den bug hier leider nicht schliessen.