vorpal-buildbot
commented
5 years ago 500 error at /seasons/3/cards/Rags // Riches/
Failed to execute SELECT * FROM _cache_card AS c WHERE ((1 = 1) AND c.name IN ('Rags // Riches')) with [] because of (1146, "Table 'cards._cache_card' doesn't exist")
Reported on decksite by logged_out
Request Data
``` Request Method: GET Path: /seasons/3/cards/Rags // Riches/?locale=pt_BR Cookies: {} Endpoint: seasons.card View Args: {'name': 'Rags // Riches'} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: DE X-Forwarded-For: 148.251.8.250, 162.158.93.59 Cf-Ray: 4e5b232cda2bd6bd-FRA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: text/html,text/plain,text/xml,text/*,application/xml,application/xhtml+xml,application/rss+xml,application/atom+xml,application/rdf+xml,application/php,application/x-php,application/x-httpd-php User-Agent: Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) Accept-Language: en Cf-Connecting-Ip: 148.251.8.250 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 ('Rags // Riches'))` 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/cache.py", line 79, in decorated_function response = make_response(f(*args, **kwargs)) File "./decksite/main.py", line 158, in card c = cs.load_card(oracle.valid_name(urllib.parse.unquote_plus(name)), season_id=get_season_id()) File "./decksite/data/card.py", line 67, in load_card c = guarantee.exactly_one(oracle.load_cards([name])) 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: ea6e2a7f58545ac941662c111795a9fb5474941a
Labels: decksite; DatabaseException
Failed to execute
SELECT * FROM _cache_card AS c WHERE ((1 = 1) AND c.name IN ('Liliana''s Mastery'))with[]because of(1146, "Table 'cards._cache_card' doesn't exist")Reported on decksite by logged_out
Request Data
``` Request Method: GET Path: /seasons/8/cards/Liliana's Mastery/? Cookies: {} Endpoint: seasons.card View Args: {'name': "Liliana's Mastery"} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 207.46.13.164, 108.162.245.186 Cf-Ray: 4e0080365939c979-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.164 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 ('Liliana''s Mastery'))` 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/cache.py", line 79, in decorated_function response = make_response(f(*args, **kwargs)) File "./decksite/main.py", line 158, in card c = cs.load_card(oracle.valid_name(urllib.parse.unquote_plus(name)), season_id=get_season_id()) File "./decksite/data/card.py", line 67, in load_card c = guarantee.exactly_one(oracle.load_cards([name])) 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: ea6e2a7f58545ac941662c111795a9fb5474941a