Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB schema? #1

Open
austinhquinn opened this issue Aug 30, 2015 · 0 comments
Open

DB schema? #1

austinhquinn opened this issue Aug 30, 2015 · 0 comments

Comments

@austinhquinn
Copy link

do you have a db schema for the initial db? =)

(env)root@ubuntu14:~/wub-machine# python server.py
INFO:web:Starting WUBMASTERGENERAL...
INFO:web: Connecting to MySQL...
INFO:web: Grabbing track count from DB...
CRITICAL:web:Error: Traceback (most recent call last):
File "server.py", line 584, in
trackCount = db.query(database.Event).filter_by(action='remix', success = True).count()
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2735, in count
return self.from_self(col).scalar()
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2504, in scalar
ret = self.one()
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2473, in one
ret = list(self)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2516, in iter
return self._execute_and_instances(context)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2531, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/root/wub-machine/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'mix.events' doesn't exist") [SQL: u'SELECT count(*) AS count_1 \nFROM (SELECT events.id AS events_id, events.uid AS events_uid, events.action AS events_action, events.start AS events_start, events.end AS events_end, events.success AS events_success, events.ip AS events_ip, events.detail AS events_detail \nFROM events \nWHERE events.action = %s AND events.success = true) AS anon_1'] [parameters: ('remix',)]

CRITICAL:web:IOLoop instance stopped. About to shutdown...
CRITICAL:web:Shutting down!
(env)root@ubuntu14:~/wub-machine#

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant