Fehler bei Sortierung ändern bei AbstimmDetails

[etienne.mbx@…]

Wenn man auf der Seite mit den Abstimmdetails die Sortierung ändern möchte nach "Delegationen" kommt eine Fehlermeldung.

Software Version Lizenz
LiquidFeedback Frontend beta30+pt_br MIT/X11
LiquidFeedback Core 1.3.0 MIT/X11
WebMCP 1.1.2 MIT/X11
Lua 5.1 MIT/X11
PostgreSQL 8.3.14 BSD

Database error of class SyntaxErrorOrAccessRuleViolation occured:
missing FROM-clause entry in subquery for table "_member_listdelegating_interest"

Stack trace follows:
[C]: in function 'escalate'
../lib/mondelefant.lua:772: in function 'exec'
../env/ui/paginate.lua:26: in function 'paginate'
...opt/liquid_feedback/webapp/app/main/member/_list.lua:58: in function 'content'
../env/ui/filters.lua:137: in function 'content'
../env/ui/tag.lua:38: in function <../env/ui/tag.lua:15>
(tail call): ?
../env/ui/filters.lua:134: in function 'filters'
...opt/liquid_feedback/webapp/app/main/member/_list.lua:53: in function 'func'
../env/execute/file_path.lua:24: in function 'file_path'
...
../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:358: in function <webmcp.lua:235>
[C]: in function 'xpcall'
webmcp.lua:234: 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: initiative/show
/main/_filter/20_session.lua

SELECT "session".* FROM "session" WHERE (ident = 'y3fOBhMbsqey2kh1SLbGKmSiPw03cIqt') LIMIT 1;
/main/_filter/21_auth.lua

SELECT "member".* FROM "member" WHERE ("member"."id" IN (921));
SELECT "setting".* FROM "setting" WHERE (member_id = 921 AND key = 'usage_terms_not_accepted') LIMIT 1;
SELECT "setting".* FROM "setting" WHERE (member_id = 921 AND key = 'usage_terms_not_accepted') LIMIT 1;
No authentication needed.
/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 = 921 AND key = 'liquidfeedback_frontend_stylesheet_url') LIMIT 1;
SELECT "setting".* FROM "setting" WHERE (member_id = 921 AND key = 'tab_mode') LIMIT 1;
/main/_filter_view/35_openid.lua

/main/_filter_view/36_html_title.lua

EXECUTE VIEW: initiative/show

SELECT "initiative".* FROM "initiative" WHERE (id = 1412) LIMIT 1;
EXECUTE VIEW: initiative/show_static

SELECT "issue".* FROM "issue" WHERE ("issue"."id" IN (656));
SELECT count(1) FROM (SELECT "initiative".* FROM "initiative" WHERE (issue_id = 656)) AS "subquery" LIMIT 1;
EXECUTE VIEW: issue/_show_head

SELECT "direct_voter".* FROM "direct_voter" WHERE (issue_id = 656 AND member_id = 921) LIMIT 1;
SELECT "area".* FROM "area" WHERE ("area"."id" IN (11));
SELECT "issue".* FROM "issue" WHERE (issue.area_id = 11) AND (issue.closed NOTNULL AND issue.fully_frozen NOTNULL);
SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (656));
EXECUTE VIEW: interest/_show_box

SELECT "interest".* FROM "interest" WHERE (issue_id = 656 AND member_id = 921) LIMIT 1;
SELECT "membership".* FROM "membership" WHERE (area_id = 11 AND member_id = 921) LIMIT 1;

EXECUTE VIEW: issue/_show_vote_later_box
EXECUTE VIEW: issue/_show_box

SELECT "policy".* FROM "policy" WHERE ("policy"."id" IN (9));
SELECT NULL::timestamp + NULL::interval - CURRENT_TIMESTAMP(0) as time_left;

EXECUTE VIEW: initiative/show_partial

SELECT "initiator".* FROM "initiator" WHERE (initiative_id = 1412) AND (member_id = 921) LIMIT 1;
EXECUTE VIEW: initiative/_show

SELECT "setting".* FROM "setting" WHERE (member_id = 921 AND key = 'liquidfeedback_frontend_hidden_help_initiative.show') LIMIT 1;
SELECT "supporter".* FROM "supporter" WHERE ("supporter"."member_id" IN (921)) AND (initiative_id = 1412) LIMIT 1;
EXECUTE VIEW: initiative/show_support

SELECT "initiator".* FROM "initiator" WHERE (initiative_id = 1412) AND (member_id = 921) LIMIT 1;
EXECUTE VIEW: supporter/_show_box

SELECT "supporter".* FROM "supporter" WHERE (initiative_id = 1412) AND (member_id = 921) LIMIT 1;

EXECUTE VIEW: initiative/show_tab

SELECT "initiator".* FROM "initiator" WHERE (initiative_id = 1412) AND (member_id = 921) LIMIT 1;
SELECT count(1) FROM (SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."initiative_id" IN (1412))) AS "subquery" LIMIT 1;
SELECT count(1) AS count, sum(weight) AS weight FROM (SELECT "member".*, direct_supporter_snapshot."initiative_id" AS "mm_ref_", direct_interest_snapshot.weight, direct_supporter_snapshot.informed AS "is_informed" FROM "member" INNER JOIN direct_supporter_snapshot ON direct_supporter_snapshot."member_id" = "member"."id" INNER JOIN issue ON issue.id = direct_supporter_snapshot.issue_id INNER JOIN direct_interest_snapshot ON direct_interest_snapshot.event = issue.latest_snapshot_event AND direct_interest_snapshot.issue_id = issue.id AND direct_interest_snapshot.member_id = member.id WHERE (direct_supporter_snapshot."initiative_id" IN (1412)) AND (direct_supporter_snapshot.event = issue.latest_snapshot_event) AND (direct_supporter_snapshot.satisfied)) as subquery;
SELECT count(1) AS count, sum(weight) AS weight FROM (SELECT "member".*, direct_supporter_snapshot."initiative_id" AS "mm_ref_", direct_interest_snapshot.weight, direct_supporter_snapshot.informed AS "is_informed" FROM "member" INNER JOIN direct_supporter_snapshot ON direct_supporter_snapshot."member_id" = "member"."id" INNER JOIN issue ON issue.id = direct_supporter_snapshot.issue_id INNER JOIN direct_interest_snapshot ON direct_interest_snapshot.event = issue.latest_snapshot_event AND direct_interest_snapshot.issue_id = issue.id AND direct_interest_snapshot.member_id = member.id WHERE (direct_supporter_snapshot."initiative_id" IN (1412)) AND (direct_supporter_snapshot.event = issue.latest_snapshot_event) AND (NOT direct_supporter_snapshot.satisfied)) as subquery;
SELECT count(1) FROM (SELECT "member".*, "initiator"."initiative_id" AS "mm_ref_", initiator.accepted AS "accepted" FROM "member" INNER JOIN "initiator" ON "initiator"."member_id" = "member"."id" WHERE ("initiator"."initiative_id" IN (1412)) AND (initiator.accepted)) AS "subquery" LIMIT 1;
SELECT count(1) FROM (SELECT "draft".* FROM "draft" WHERE ("draft"."initiative_id" IN (1412)) ORDER BY "id" DESC) AS "subquery" LIMIT 1;
SELECT "draft".* FROM "draft" WHERE ("draft"."initiative_id" IN (1412)) ORDER BY "id" DESC;
EXECUTE VIEW: initiative/_show_voting

EXECUTE VIEW: initiative/_battles

SELECT "initiative".*, winning_battle.count AS "winning_count", losing_battle.count AS "losing_count" FROM "initiative" INNER JOIN battle AS "winning_battle" ON winning_battle.winning_initiative_id = 1412 AND winning_battle.losing_initiative_id = initiative.id INNER JOIN battle AS "losing_battle" ON losing_battle.losing_initiative_id = 1412 AND losing_battle.winning_initiative_id = initiative.id ORDER BY rank;
SELECT count(1) FROM (SELECT "initiative".* FROM "initiative" WHERE (issue_id = 656) AND (admitted)) AS "subquery" LIMIT 1;

EXECUTE VIEW: member/_list

SELECT count(1) FROM (SELECT "member".*, direct_voter."issue_id" AS "mm_ref_", direct_voter.weight as voter_weight, coalesce(vote.grade, 0) as grade, _member_listdelegating_voter.delegate_member_ids AS "delegate_member_ids" FROM "member" INNER JOIN direct_voter ON direct_voter."member_id" = "member"."id" LEFT OUTER JOIN vote ON vote.initiative_id = 1412 AND vote.member_id = member.id INNER JOIN initiative ON initiative.id = vote.initiative_id INNER JOIN issue ON issue.id = initiative.issue_id LEFT OUTER JOIN delegating_voter AS "_member_listdelegating_voter" ON _member_listdelegating_voter.issue_id = issue.id AND _member_listdelegating_voter.member_id = 921 WHERE (direct_voter."issue_id" IN (656)) ORDER BY ⇒_member_listdelegating_interest.weight DESC) AS "subquery" LIMIT 1;
UNEXPECTED ERROR

Finished after 91.7 ms (70.0 ms CPU)