Modify

Ticket #276 (closed defect: duplicate)

Opened 3 years ago

Last modified 6 months ago

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:1 Changed 3 years ago by anonymous

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

comment:2 Changed 3 years ago by dark

  • Status changed from new to closed
  • Resolution set to duplicate

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.

View

Add a comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.