vorpal-buildbot
commented
5 years ago 500 error at /matchups/
Failed to execute ` SELECT d.id, d.finish, d.decklist_hash, cache.active_date, cache.wins, cache.losses, cache.draws, ct.name AS competition_type_name FROM deck AS d
LEFT JOIN
competition AS c ON d.competition_id = c.id
LEFT JOIN
competition_series AS cs ON cs.id = c.competition_series_id
LEFT JOIN
competition_type AS ct ON ct.id = cs.competition_type_id
LEFT JOIN
deck_cache AS cache ON d.id = cache.deck_id
LEFT JOIN
(
SELECT
`start`.id,
`start`.code,
`start`.start_date AS start_date,
`end`.start_date AS end_date
FROM
season AS `start`
LEFT JOIN
season AS `end` ON `end`.id = `start`.id + 1
) AS season ON season.start_date <= d.created_date AND (season.end_date IS NULL OR season.end_date > d.created_date)
WHERE
(d.id IN ()) AND (TRUE)
GROUP BY
d.id,
d.competition_id, -- Every deck has only one competition_id but if we want to use competition_id in the HAVING clause we need this.
season.id -- In theory this is not necessary as all decks are in a single season and we join on the date but MySQL cannot work that out so give it the hint it needs.
HAVING
1 = 1
ORDER BY
active_date DESC, d.finish IS NULL, d.finish
` with `[]` because of `(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (TRUE)\n GROUP BY\n d.id,\n d.competition_id, -' at line 38")`Reported on decksite by cluelessinnistradboi
Request Data
``` Request Method: GET Path: /matchups/?season_id=11&hero_archetype_id=73&hero_person_id=&hero_card=&enemy_archetype_id=64&enemy_person_id=&enemy_card= Cookies: {'session': '.eJx9UV1PwjAU_S_3eTH7YOvGmwiIURQlAokxS9kuo9K1o-2EQfjvdiTIg4mP59xzz7k9PUJaoSqpQGGga1SNDtC8ZAK6K8q1RTmWrJT5FTOdSZWnzFLgJYSQMPYDQtzIC2M3Bgf-mYi0qBnPL0lcZpSjVaOAFhUF5u09Woqzf-B3IgdKU8i01qgELVtxxmvkqDUTgmmjaL6UzK5LWpu1n2pDTataTPqHIXuq1UG93XvjPAjnu6a_mEaDSorxVW_kxqZ3j0CzzJpeMCzZeLTdD5v33WD3Uk0equfqjuGXuDW4cJXdx33FFOqU2uK8MPSS0A9898YlCYmS6Dpvu4zcTuy6DihcWWr9GxJ_Tx5f53zTmFkQ-6MtJdPecjIkvU0SztoQ23VlX_NhS7U_xFaN5c4Vavh04GyTmqaVQA-pQgUnB_40aKgq0J4pas5PPycZolY.D3fQxg.xq6VaycfwqaI3h3iig2_KxKPt2g', '__cfduid': 'db925bc028bc4091fcb127e8a9121a17f1553349912'} Endpoint: matchups View Args: {} Person: 197775823770615808 Referrer: https://pennydreadfulmagic.com/matchups/?season_id=11&hero_archetype_id=73&hero_person_id=&hero_card=&enemy_archetype_id=103&enemy_person_id=&enemy_card= Request Data: {} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: DE X-Forwarded-For: 87.188.81.224, 162.158.89.93 Cf-Ray: 4bc103c7befc96dc-FRA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:65.0) Gecko/20100101 Firefox/65.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Referer: https://pennydreadfulmagic.com/matchups/?season_id=11&hero_archetype_id=73&hero_person_id=&hero_card=&enemy_archetype_id=103&enemy_person_id=&enemy_card= Upgrade-Insecure-Requests: 1 Cookie: session=.eJx9UV1PwjAU_S_3eTH7YOvGmwiIURQlAokxS9kuo9K1o-2EQfjvdiTIg4mP59xzz7k9PUJaoSqpQGGga1SNDtC8ZAK6K8q1RTmWrJT5FTOdSZWnzFLgJYSQMPYDQtzIC2M3Bgf-mYi0qBnPL0lcZpSjVaOAFhUF5u09Woqzf-B3IgdKU8i01qgELVtxxmvkqDUTgmmjaL6UzK5LWpu1n2pDTataTPqHIXuq1UG93XvjPAjnu6a_mEaDSorxVW_kxqZ3j0CzzJpeMCzZeLTdD5v33WD3Uk0equfqjuGXuDW4cJXdx33FFOqU2uK8MPSS0A9898YlCYmS6Dpvu4zcTuy6DihcWWr9GxJ_Tx5f53zTmFkQ-6MtJdPecjIkvU0SztoQ23VlX_NhS7U_xFaN5c4Vavh04GyTmqaVQA-pQgUnB_40aKgq0J4pas5PPycZolY.D3fQxg.xq6VaycfwqaI3h3iig2_KxKPt2g; __cfduid=db925bc028bc4091fcb127e8a9121a17f1553349912 Cf-Connecting-Ip: 87.188.81.224 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive ```DatabaseException Failed to execute ` SELECT d.id, d.finish, d.decklist_hash, cache.active_date, cache.wins, cache.losses, cache.draws, ct.name AS competition_type_name FROM deck AS d LEFT JOIN competition AS c ON d.competition_id = c.id LEFT JOIN competition_series AS cs ON cs.id = c.competition_series_id LEFT JOIN competition_type AS ct ON ct.id = cs.competition_type_id LEFT JOIN deck_cache AS cache ON d.id = cache.deck_id LEFT JOIN ( SELECT `start`.id, `start`.code, `start`.start_date AS start_date, `end`.start_date AS end_date FROM season AS `start` LEFT JOIN season AS `end` ON `end`.id = `start`.id + 1 ) AS season ON season.start_date <= d.created_date AND (season.end_date IS NULL OR season.end_date > d.created_date) WHERE (d.id IN ()) AND (TRUE) GROUP BY d.id, d.competition_id, -- Every deck has only one competition_id but if we want to use competition_id in the HAVING clause we need this. season.id -- In theory this is not necessary as all decks are in a single season and we join on the date but MySQL cannot work that out so give it the hint it needs. HAVING 1 = 1 ORDER BY active_date DESC, d.finish IS NULL, d.finish ` with `[]` because of `(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (TRUE)\n GROUP BY\n d.id,\n d.competition_id, -' at line 38")`
Stack Trace: ``` Python traceback File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2309, in __call__ return self.wsgi_app(environ, start_response) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2295, in wsgi_app response = self.handle_exception(e) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2292, in wsgi_app response = self.full_dispatch_request() File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1815, in full_dispatch_request rv = self.handle_user_exception(e) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1718, in handle_user_exception reraise(exc_type, exc_value, tb) File "/home/discord/.local/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise raise value File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request rv = self.dispatch_request() File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "./decksite/main.py", line 279, in matchups results = mus.matchup(hero, enemy, season_id=season_id) if request.args else {} File "./decksite/data/matchup.py", line 51, in matchup results['hero_decks'] = deck.load_decks('d.id IN (' + ', '.join(results['hero_deck_ids']) + ')') File "./decksite/data/deck.py", line 94, in load_decks rows = db().select(sql) File "./shared/database.py", line 41, in select [_, rows] = self.execute_anything(sql, args) File "./shared/database.py", line 60, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```Exception_hash: 1ac391d11ae0cd854fbefe228536953999816739
Labels: decksite; DatabaseException
Failed to execute ` SELECT d.id, d.finish, d.decklist_hash, cache.active_date, cache.wins, cache.losses, cache.draws, ct.name AS competition_type_name FROM deck AS d
Reported on decksite by flac0
Request Data
``` Request Method: GET Path: /matchups/?season_id=11&hero_archetype_id=16&hero_person_id=1877&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: {'__cfduid': 'dc2f381085806ba8d88189016017565e61521681072', '_ga': 'GA1.2.1518460170.1521681078', 'hide_intro': 'True', '_gid': 'GA1.2.194635858.1552803868', 'session': '.eJx9UdFOgzAU_Zf7TEw7YMDeRLcgbGY6NSbGkK4U1tgCtmUBl_27Zcm2BxMfz7mn59x7eoC8ZUqSmtUGZkZ1zAFSSF7DrCRCW1QwyWVTnIcF17RRRc4tA56Hp6EfYBxEEx95oReCA_9M6rzquLh4iYYSwaya1TCiqmLFuI5u6pM_DoPAAWmqJu80UzWRo7gUhCKrb0hndpNcG2JGmr7OM71ISdujVerGt4OQcq76ZJlivuivetN82bjZAQilTOszBr1-un_erBu6HB7fgix2N2bYmqSLk_1-Fdn3rG-5YjontijsexMfI-T7N5Hr4SgKr_Oxu6k9GSEHFCsttbuEbLj7cJdu_R-aZaZ7D-nLVHilLFDyzYbShthyW3vNh23R_ggvB8udOtPw6cDJJjfDKIGYEcUUHB34U5khqmJ2zboT4vgLmAmbDg.D3B6xQ.CXLO5uai0jS3laU55B4x0Hh0NfY'} Endpoint: matchups View Args: {} Person: 441685711792504848 Referrer: https://pennydreadfulmagic.com/matchups/?season_id=&hero_archetype_id=&hero_person_id=1877&hero_card=&enemy_archetype_id=16&enemy_person_id=&enemy_card= Request Data: {} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: CA X-Forwarded-For: 184.147.60.148, 162.158.75.186 Cf-Ray: 4b932b468bf65588-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Referer: https://pennydreadfulmagic.com/matchups/?season_id=&hero_archetype_id=&hero_person_id=1877&hero_card=&enemy_archetype_id=16&enemy_person_id=&enemy_card= Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=dc2f381085806ba8d88189016017565e61521681072; _ga=GA1.2.1518460170.1521681078; hide_intro=True; _gid=GA1.2.194635858.1552803868; session=.eJx9UdFOgzAU_Zf7TEw7YMDeRLcgbGY6NSbGkK4U1tgCtmUBl_27Zcm2BxMfz7mn59x7eoC8ZUqSmtUGZkZ1zAFSSF7DrCRCW1QwyWVTnIcF17RRRc4tA56Hp6EfYBxEEx95oReCA_9M6rzquLh4iYYSwaya1TCiqmLFuI5u6pM_DoPAAWmqJu80UzWRo7gUhCKrb0hndpNcG2JGmr7OM71ISdujVerGt4OQcq76ZJlivuivetN82bjZAQilTOszBr1-un_erBu6HB7fgix2N2bYmqSLk_1-Fdn3rG-5YjontijsexMfI-T7N5Hr4SgKr_Oxu6k9GSEHFCsttbuEbLj7cJdu_R-aZaZ7D-nLVHilLFDyzYbShthyW3vNh23R_ggvB8udOtPw6cDJJjfDKIGYEcUUHB34U5khqmJ2zboT4vgLmAmbDg.D3B6xQ.CXLO5uai0jS3laU55B4x0Hh0NfY Cf-Connecting-Ip: 184.147.60.148 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive ```DatabaseException Failed to execute ` SELECT d.id, d.finish, d.decklist_hash, cache.active_date, cache.wins, cache.losses, cache.draws, ct.name AS competition_type_name FROM deck AS d LEFT JOIN competition AS c ON d.competition_id = c.id LEFT JOIN competition_series AS cs ON cs.id = c.competition_series_id LEFT JOIN competition_type AS ct ON ct.id = cs.competition_type_id LEFT JOIN deck_cache AS cache ON d.id = cache.deck_id LEFT JOIN ( SELECT `start`.id, `start`.code, `start`.start_date AS start_date, `end`.start_date AS end_date FROM season AS `start` LEFT JOIN season AS `end` ON `end`.id = `start`.id + 1 ) AS season ON season.start_date <= d.created_date AND (season.end_date IS NULL OR season.end_date > d.created_date) WHERE (d.id IN ()) AND (TRUE) GROUP BY d.id, d.competition_id, -- Every deck has only one competition_id but if we want to use competition_id in the HAVING clause we need this. season.id -- In theory this is not necessary as all decks are in a single season and we join on the date but MySQL cannot work that out so give it the hint it needs. HAVING 1 = 1 ORDER BY active_date DESC, d.finish IS NULL, d.finish ` with `[]` because of `(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (TRUE)\n GROUP BY\n d.id,\n d.competition_id, -' at line 38")`
Stack Trace: ``` Python traceback File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2309, in __call__ return self.wsgi_app(environ, start_response) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2295, in wsgi_app response = self.handle_exception(e) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2292, in wsgi_app response = self.full_dispatch_request() File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1815, in full_dispatch_request rv = self.handle_user_exception(e) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1718, in handle_user_exception reraise(exc_type, exc_value, tb) File "/home/discord/.local/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise raise value File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request rv = self.dispatch_request() File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "./decksite/main.py", line 279, in matchups results = mus.matchup(hero, enemy, season_id=season_id) if request.args else {} File "./decksite/data/matchup.py", line 51, in matchup results['hero_decks'] = deck.load_decks('d.id IN (' + ', '.join(results['hero_deck_ids']) + ')') File "./decksite/data/deck.py", line 94, in load_decks rows = db().select(sql) File "./shared/database.py", line 41, in select [_, rows] = self.execute_anything(sql, args) File "./shared/database.py", line 60, in execute_anything raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e)) ```Exception_hash: 1ac391d11ae0cd854fbefe228536953999816739