Page MenuHomePhabricator

Leaderboard error
Closed, ResolvedPublic

Description

OAbot
Oops! Something went wrong.
Error:
(sqlite3.OperationalError) no such table: userstats [SQL: u'SELECT userstats.id AS userstats_id, userstats.wiki AS userstats_wiki, userstats.user_name AS userstats_user_name, userstats.nb_edits AS userstats_nb_edits, userstats.nb_links AS userstats_nb_links \nFROM userstats \nWHERE userstats.nb_edits != ? ORDER BY userstats.nb_edits'] [parameters: (0,)]
Traceback (most recent call last):
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/flask/app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/data/project/oabot/www/python/src/app.py", line 330, in stats
leaderboard = list(UserStats.get_leaderboard())
File "./oabot/userstats.py", line 60, in get_leaderboard
return reversed(list(stats))
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2855, in iter
return self._execute_and_instances(context)
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/data/project/oabot/www/python/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
OperationalError: (sqlite3.OperationalError) no such table: userstats [SQL: u'SELECT userstats.id AS userstats_id, userstats.wiki AS userstats_wiki, userstats.user_name AS userstats_user_name, userstats.nb_edits AS userstats_nb_edits, userstats.nb_links AS userstats_nb_links \nFROM userstats \nWHERE userstats.nb_edits != ? ORDER BY userstats.nb_edits'] [parameters: (0,)]

Event Timeline

Ocaasi_WMF triaged this task as Medium priority.Nov 13 2017, 9:50 AM
Ocaasi_WMF created this task.
Ocaasi_WMF updated the task description. (Show Details)
Pintoch closed this task as Resolved.Nov 13 2017, 10:10 AM
Pintoch claimed this task.
Pintoch added a subscriber: Pintoch.

Solved.