Guest User

CB

a guest
Dec 18th, 2015
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.27 KB | None | 0 0
  1. Internal server error
  2.  
  3. (OperationalError) no such table: revision u'SELECT anon_1.id AS anon_1_id, anon_1.entity_id AS anon_1_entity_id, anon_1.entity_type AS anon_1_entity_type, anon_1.user_id AS anon_1_user_id, anon_1.edits AS anon_1_edits, anon_1.is_draft AS anon_1_is_draft, anon_1.is_hidden AS anon_1_is_hidden, anon_1.license_id AS anon_1_license_id, anon_1.language AS anon_1_language, anon_1.source AS anon_1_source, anon_1.source_url AS anon_1_source_url, user_1.id AS user_1_id, user_1.display_name AS user_1_display_name, user_1.email AS user_1_email, user_1.created AS user_1_created, user_1.musicbrainz_id AS user_1_musicbrainz_id, user_1.show_gravatar AS user_1_show_gravatar, user_1.is_blocked AS user_1_is_blocked \nFROM (SELECT anon_2.id AS id, anon_2.entity_id AS entity_id, anon_2.entity_type AS entity_type, anon_2.user_id AS user_id, anon_2.edits AS edits, anon_2.is_draft AS is_draft, anon_2.is_hidden AS is_hidden, anon_2.license_id AS license_id, anon_2.language AS language, anon_2.source AS source, anon_2.source_url AS source_url \nFROM (SELECT DISTINCT review.id AS id, review.entity_id AS entity_id, review.entity_type AS entity_type, review.user_id AS user_id, review.edits AS edits, review.is_draft AS is_draft, review.is_hidden AS is_hidden, review.license_id AS license_id, review.language AS language, review.source AS source, review.source_url AS source_url \nFROM review \nWHERE review.is_draft = 0) AS anon_2 ORDER BY random()) AS anon_1 LEFT OUTER JOIN revision ON anon_1.id = revision.review_id LEFT OUTER JOIN (SELECT vote.revision_id AS revision_id, vote.vote AS vote, count(*) AS c \nFROM vote \nWHERE vote.rated_at > ? GROUP BY vote.revision_id, vote.vote) AS votes_pos ON votes_pos.revision_id = revision.id AND votes_pos.vote = 1 LEFT OUTER JOIN revision AS revision_1 ON revision_1.id = votes_pos.revision_id LEFT OUTER JOIN (SELECT vote.revision_id AS revision_id, vote.vote AS vote, count(*) AS c \nFROM vote \nWHERE vote.rated_at > ? GROUP BY vote.revision_id, vote.vote) AS votes_neg ON votes_neg.revision_id = revision_1.id AND votes_neg.vote = 0 LEFT OUTER JOIN user AS user_1 ON user_1.id = anon_1.user_id ORDER BY coalesce(votes_pos.c, ?) - coalesce(votes_neg.c, ?) DESC\n LIMIT ? OFFSET ?' ('2015-11-20 15:53:32.601607', '2015-11-20 15:53:32.601607', 0, 0, 24, 0)
Advertisement
Add Comment
Please, Sign In to add comment