vorpal-buildbot
commented
5 years ago 500 error at /image/Curse of Chaos/
Failed to execute SELECT * FROM _cache_card AS c WHERE ((1 = 1) AND c.name IN ('Curse of Chaos')) with [] because of (1146, "Table 'cards._cache_card' doesn't exist")
Reported on decksite by wizzardofoz
Request Data
``` Request Method: GET Path: /image/Curse of Chaos/? Cookies: {'__cfduid': 'd63b5d7c015853123c363c84c13b940b91555687535', 'hide_intro': 'True', 'deck_id': '51929', 'session': '.eJx9UctuwjAQ_BefIxTixAGOBVpVAkppVSqqKjKx8wAnTvxQmiD-vRsk4FCpN8_O7szu-ISiiquClrw0aGKU5Q6irMhLNEmo0IAYL_JCsjvOdSwVi3IoIez7I49gjH0SDodBgF3koH-YMkptLtjVScg05azfQMvyouiREXZQYVIZWc1VSQsOYk3edVQxmcgOVCS1JvMibajpyVXzNmvilu6L7EnUr--bz4WqhV0SOw6bxb3fyCOHs06IxjHX-orRfO7baiYZWa5ZOF37B5FU7UbQ-kUV-xTm-U-VK64jCgnBJQQH4xCTwZi4BA_Jne9DI64_cl0HKZ5AKbuZdPUza48f_uqBzQPlrbcyk2K3baaP2NtlYAKhVnDNF6QHX5EnLdQuWenbY3CQYPHtoItoZNp-AD1wqrhCZwf9idFQlXJYurRCnH8BsC-gAA.D9_CRw.27QW5K_gwrpNEM7vS7RpYtZPhQA'} Endpoint: image View Args: {'c': 'Curse of Chaos'} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/cards/Wild%20Pair/ Request Data: {} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 2001:8a0:feec:5500:fc85:c4cb:d182:5bcc, 141.101.98.150 Cf-Ray: 4e4aa8825cbbce6f-LHR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36 Dnt: 1 Accept: image/webp,image/apng,image/*,*/*;q=0.8 Referer: https://pennydreadfulmagic.com/cards/Wild%20Pair/ Accept-Language: en-GB,en;q=0.9,pt-PT;q=0.8,pt;q=0.7,fr;q=0.6,nl;q=0.5 Cookie: __cfduid=d63b5d7c015853123c363c84c13b940b91555687535; hide_intro=True; deck_id=51929; session=.eJx9UctuwjAQ_BefIxTixAGOBVpVAkppVSqqKjKx8wAnTvxQmiD-vRsk4FCpN8_O7szu-ISiiquClrw0aGKU5Q6irMhLNEmo0IAYL_JCsjvOdSwVi3IoIez7I49gjH0SDodBgF3koH-YMkptLtjVScg05azfQMvyouiREXZQYVIZWc1VSQsOYk3edVQxmcgOVCS1JvMibajpyVXzNmvilu6L7EnUr--bz4WqhV0SOw6bxb3fyCOHs06IxjHX-orRfO7baiYZWa5ZOF37B5FU7UbQ-kUV-xTm-U-VK64jCgnBJQQH4xCTwZi4BA_Jne9DI64_cl0HKZ5AKbuZdPUza48f_uqBzQPlrbcyk2K3baaP2NtlYAKhVnDNF6QHX5EnLdQuWenbY3CQYPHtoItoZNp-AD1wqrhCZwf9idFQlXJYurRCnH8BsC-gAA.D9_CRw.27QW5K_gwrpNEM7vS7RpYtZPhQA Cf-Connecting-Ip: 2001:8a0:feec:5500:fc85:c4cb:d182:5bcc Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive ```DatabaseException Failed to execute `SELECT * FROM _cache_card AS c WHERE ((1 = 1) AND c.name IN ('Curse of Chaos'))` with `[]` because of `(1146, "Table 'cards._cache_card' doesn't exist")`
Stack Trace: ```Python traceback File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2328, in __call__ return self.wsgi_app(environ, start_response) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2314, in wsgi_app response = self.handle_exception(e) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2311, in wsgi_app response = self.full_dispatch_request() File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1834, in full_dispatch_request rv = self.handle_user_exception(e) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1737, in handle_user_exception reraise(exc_type, exc_value, tb) File "/home/discord/.local/lib/python3.6/site-packages/flask/_compat.py", line 36, in reraise raise value File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1832, in full_dispatch_request rv = self.dispatch_request() File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1818, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "./decksite/main.py", line 474, in image requested_cards = oracle.load_cards(names) File "./magic/oracle.py", line 44, in load_cards rs = 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: 10a8e4b74c719b0ea2734a7a5c2a7a1e18964e79
Labels: decksite; DatabaseException
Failed to execute
SELECT * FROM _cache_card AS c WHERE ((1 = 1) AND c.name IN ('Teysa, Envoy of Ghosts'))with[]because of(1146, "Table 'cards._cache_card' doesn't exist")Reported on decksite by logged_out
Request Data
``` Request Method: GET Path: /image/Teysa, Envoy of Ghosts/? Cookies: {} Endpoint: image View Args: {'c': 'Teysa, Envoy of Ghosts'} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 207.46.13.141, 162.158.107.27 Cf-Ray: 4e31f1baec9cc989-SEA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.com User-Agent: Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Cf-Connecting-Ip: 207.46.13.141 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive ```DatabaseException Failed to execute `SELECT * FROM _cache_card AS c WHERE ((1 = 1) AND c.name IN ('Teysa, Envoy of Ghosts'))` with `[]` because of `(1146, "Table 'cards._cache_card' doesn't exist")`
Stack Trace: ```Python traceback File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2328, in __call__ return self.wsgi_app(environ, start_response) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2314, in wsgi_app response = self.handle_exception(e) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2311, in wsgi_app response = self.full_dispatch_request() File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1834, in full_dispatch_request rv = self.handle_user_exception(e) File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1737, in handle_user_exception reraise(exc_type, exc_value, tb) File "/home/discord/.local/lib/python3.6/site-packages/flask/_compat.py", line 36, in reraise raise value File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1832, in full_dispatch_request rv = self.dispatch_request() File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1818, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "./decksite/main.py", line 474, in image requested_cards = oracle.load_cards(names) File "./magic/oracle.py", line 44, in load_cards rs = 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: 10a8e4b74c719b0ea2734a7a5c2a7a1e18964e79