Ticket #1035 (new defect)
Opened 2 years ago
Leider ist ein Systemfehler aufgetreten (blue)
| Reported by: | anonymous | Owned by: | dark |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | API | Version: | beta33 |
| Keywords: | Cc: |
Description
beim ausproberen von blue ist folgender fehler gekommen.
Leider weiß ich nicht mehr, wie ich ihn ausgelöst habe, die url heißt aber http://dev.liquidfeedback.org/alpha/issue/show/7.html
Leider ist ein Systemfehler aufgetreten
Du hast vermutlich gerade einen Fehler in der Software entdeckt. Das ist kein Grund zur Panik, dir bleiben die folgenden Optionen:
Weiter zur Startseite Anfrage wiederholen Fehlerbericht erstellen
If you write a bug report, please include the following output in your bug report.
Falls Du einen Fehlerbericht erstellst, füge bitte die folgenden Ausgaben mit ein.
Database error of class SyntaxErrorOrAccessRuleViolation occured:
table name "issue" specified more than once
Stack trace follows:
[C]: in function 'escalate'
../lib/mondelefant.lua:772: in function 'exec'
../lib/mondelefant.lua:792: in function 'count'
...iquid_feedback-alpha/app/app/main/issue/show_tab.lua:35: in function 'func'
../env/execute/file_path.lua:24: in function 'file_path'
../env/execute/view.lua:17: in function 'view'
...pt/liquid_feedback-alpha/app/app/main/issue/show.lua:58: in function 'func'
../env/execute/file_path.lua:24: in function 'file_path'
../env/execute/view.lua:17: in function 'view'
../env/execute/filtered_view.lua:31: in function <../env/execute/filtered_view.lua:30>
...
../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'
...ck-alpha/webmcp/framework/cgi-bin/webmcp-wrapper.lua:7: in main chunk
[C]: ?
Configuration "alpha"
Configuration "default"
REQUESTED VIEW: issue/show
/main/_filter/20_session.lua
SELECT "session".* FROM "session" WHERE (ident = 'RyBQvyaMxCivq0fMAAX4Xb49ttDVPDcN') LIMIT 1;
/main/_filter/21_auth.lua
SELECT "member".* FROM "member" ORDER BY member.name;
SELECT "member".* FROM "member" WHERE ("member"."id" IN (81));
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 = 81 AND key = 'liquidfeedback_frontend_stylesheet_url') LIMIT 1;
SELECT "setting".* FROM "setting" WHERE (member_id = 81 AND key = 'tab_mode') LIMIT 1;
/main/_filter_view/35_openid.lua
/main/_filter_view/36_html_title.lua
EXECUTE VIEW: issue/show
SELECT "issue".* FROM "issue" WHERE (id = 7) LIMIT 1;
EXECUTE VIEW: issue/_show_head
SELECT "direct_voter".* FROM "direct_voter" WHERE (issue_id = 7 AND member_id = 81) LIMIT 1;
SELECT "area".* FROM "area" WHERE ("area"."id" IN (1));
SELECT "issue".* FROM "issue" WHERE (issue.area_id = 1);
EXECUTE VIEW: interest/_show_box
SELECT "interest".* FROM "interest" WHERE (issue_id = 7 AND member_id = 81) LIMIT 1;
SELECT "membership".* FROM "membership" WHERE (area_id = 1 AND member_id = 81) LIMIT 1;
EXECUTE VIEW: delegation/_show_box
SELECT "issue".* FROM "issue" WHERE (id = 7) LIMIT 1;
SELECT "delegation".* FROM "delegation" WHERE (truster_id = 81) AND (unit_id ISNULL) AND (area_id = 7) AND (issue_id ISNULL ) LIMIT 1;
SELECT "delegation".* FROM "delegation" WHERE (truster_id = 81) AND (unit_id = 1) AND (area_id ISNULL) AND (issue_id ISNULL ) LIMIT 1;
SELECT "delegation".* FROM "delegation" WHERE (truster_id = 81) AND (unit_id ISNULL) AND (area_id ISNULL) AND (issue_id ISNULL ) LIMIT 1;
EXECUTE VIEW: issue/_show_vote_later_box
SELECT "interest".* FROM "interest" WHERE (issue_id = 7 AND member_id = 81) LIMIT 1;
EXECUTE VIEW: issue/_show_box
SELECT "policy".* FROM "policy" WHERE ("policy"."id" IN (1));
SELECT '2011-02-28 07:12:59'::timestamp + '14 days'::interval - CURRENT_TIMESTAMP(0) as time_left;
SELECT "setting".* FROM "setting" WHERE (member_id = 81 AND key = 'liquidfeedback_frontend_hidden_help_issue.show') LIMIT 1;
EXECUTE VIEW: initiative/_list
SELECT count(1) FROM (SELECT "initiative".*, (_initiator.member_id NOTNULL) AS "is_initiator", (_supporter.member_id NOTNULL) AND NOT EXISTS(SELECT 1 FROM opinion WHERE opinion.initiative_id = initiative.id AND opinion.member_id = 81 AND ((opinion.degree = 2 AND NOT fulfilled) OR (opinion.degree = -2 AND fulfilled))) AS "is_supporter", EXISTS(SELECT 1 FROM opinion WHERE opinion.initiative_id = initiative.id AND opinion.member_id = 81 AND ((opinion.degree = 2 AND NOT fulfilled) OR (opinion.degree = -2 AND fulfilled))) AS "is_potential_supporter" FROM "initiative" INNER JOIN issue ON issue.id = initiative.issue_id LEFT OUTER JOIN initiator AS "_initiator" ON _initiator.initiative_id = initiative.id AND _initiator.member_id = 81 AND _initiator.accepted LEFT OUTER JOIN supporter AS "_supporter" ON _supporter.initiative_id = initiative.id AND _supporter.member_id = 81 WHERE ("initiative"."issue_id" IN (7)) ORDER BY initiative.rank, initiative.admitted ISNULL, initiative.admitted DESC, initiative.positive_votes::float / initiative.negative_votes::float DESC, initiative.supporter_count DESC) AS "subquery" LIMIT 1;
SELECT count(1) FROM (SELECT "initiative".*, (_initiator.member_id NOTNULL) AS "is_initiator", (_supporter.member_id NOTNULL) AND NOT EXISTS(SELECT 1 FROM opinion WHERE opinion.initiative_id = initiative.id AND opinion.member_id = 81 AND ((opinion.degree = 2 AND NOT fulfilled) OR (opinion.degree = -2 AND fulfilled))) AS "is_supporter", EXISTS(SELECT 1 FROM opinion WHERE opinion.initiative_id = initiative.id AND opinion.member_id = 81 AND ((opinion.degree = 2 AND NOT fulfilled) OR (opinion.degree = -2 AND fulfilled))) AS "is_potential_supporter" FROM "initiative" INNER JOIN issue ON issue.id = initiative.issue_id LEFT OUTER JOIN initiator AS "_initiator" ON _initiator.initiative_id = initiative.id AND _initiator.member_id = 81 AND _initiator.accepted LEFT OUTER JOIN supporter AS "_supporter" ON _supporter.initiative_id = initiative.id AND _supporter.member_id = 81 WHERE ("initiative"."issue_id" IN (7)) ORDER BY initiative.rank, initiative.admitted ISNULL, initiative.admitted DESC, initiative.positive_votes::float / initiative.negative_votes::float DESC, initiative.supporter_count DESC, initiative.supporter_count::float / issue.population::float DESC, initiative.id) AS "subquery" LIMIT 1;
SELECT "initiative".*, (_initiator.member_id NOTNULL) AS "is_initiator", (_supporter.member_id NOTNULL) AND NOT EXISTS(SELECT 1 FROM opinion WHERE opinion.initiative_id = initiative.id AND opinion.member_id = 81 AND ((opinion.degree = 2 AND NOT fulfilled) OR (opinion.degree = -2 AND fulfilled))) AS "is_supporter", EXISTS(SELECT 1 FROM opinion WHERE opinion.initiative_id = initiative.id AND opinion.member_id = 81 AND ((opinion.degree = 2 AND NOT fulfilled) OR (opinion.degree = -2 AND fulfilled))) AS "is_potential_supporter" FROM "initiative" INNER JOIN issue ON issue.id = initiative.issue_id LEFT OUTER JOIN initiator AS "_initiator" ON _initiator.initiative_id = initiative.id AND _initiator.member_id = 81 AND _initiator.accepted LEFT OUTER JOIN supporter AS "_supporter" ON _supporter.initiative_id = initiative.id AND _supporter.member_id = 81 WHERE ("initiative"."issue_id" IN (7)) ORDER BY initiative.rank, initiative.admitted ISNULL, initiative.admitted DESC, initiative.positive_votes::float / initiative.negative_votes::float DESC, initiative.supporter_count DESC, initiative.supporter_count::float / issue.population::float DESC, initiative.id LIMIT 10 OFFSET 0;
EXECUTE VIEW: initiative/_list_element
EXECUTE VIEW: issue/show_tab
SELECT count(1) FROM (SELECT "member".*, direct_interest_snapshot.weight FROM "member" INNER JOIN direct_interest_snapshot ON direct_interest_snapshot.member_id = member.id AND direct_interest_snapshot.issue_id IN (7) INNER JOIN issue ON direct_interest_snapshot.issue_id = issue.id AND direct_interest_snapshot.event = issue.latest_snapshot_event INNER JOIN issue ON issue.id = direct_interest_snapshot.issue_id WHERE (direct_interest_snapshot.event = issue.latest_snapshot_event) ORDER BY direct_interest_snapshot.weight DESC) AS "subquery" LIMIT 1;
UNEXPECTED ERROR
Finished after 169.1 ms (80.0 ms CPU)
