Ticket #306 (closed defect: fixed)
Fehlermeldung bei Suchfunktion
| Reported by: | anonymous | Owned by: | poelzi |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | Frontend | Version: | beta13 |
| Keywords: | Cc: |
Description
Bei "suche Themen" und eingabe einer zahl, erschein nach klik auf OK folgende fehlermeldung. habe es mal mit den zahllen 3,4,und 232 probiert.
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 = 'Ky4qjTdKZonCeazZiG24PEnslEwpOXpm') LIMIT 1;
o
/main/_filter/21_auth.lua
+ SELECT "member".* FROM "member" WHERE ("member"."id" IN (53));
+ 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 = 53 AND key = 'liquidfeedback_frontend_stylesheet_url') LIMIT 1;
# SELECT "setting".* FROM "setting" WHERE (member_id = 53 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 = 53 WHERE ("initiative"."text_search_data" @@ "text_search_query"('3') OR "draft"."text_search_data" @@ "text_search_query"('3')) 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
Attachments
Change History
comment:3 Changed 3 years ago by poelzi
- Status changed from assigned to closed
- Resolution set to fixed
comment:4 Changed 3 years ago by reverse phone lookup
[ http://the-reversephone.com/ reverse phone lookup - great
[ http://ezinearticles.com/?Do-Reverse-Phone-Lookups-Really-Work?&id=3514214 reverse phone lookup - use now
comment:5 Changed 3 years ago by reverse phone lookup
[ http://the-reversephone.com/ reverse phone lookup -
[ http://www.buzzle.com/articles/making-use-of-reverse-phone-lookup-services.html -
comment:6 Changed 3 years ago by reverse phone lookup
[ http://the-reversephone.com/ reverse phone lookup -
[ http://www.buzzle.com/articles/making-use-of-reverse-phone-lookup-services.html reverse phone lookup -
<a href=" http://the-reversephone.com">reverse phone lookup</a>

fixe, dup