Skip to content

Instantly share code, notes, and snippets.

@Vinc0682
Created June 12, 2018 14:24
Show Gist options
  • Save Vinc0682/fb646903635035fcb9fa60c9ed088f4b to your computer and use it in GitHub Desktop.
Save Vinc0682/fb646903635035fcb9fa60c9ed088f4b to your computer and use it in GitHub Desktop.
[2018-06-12 09:39:16 +0000] [24] [INFO] Starting gunicorn 19.7.1
[2018-06-12 09:39:16 +0000] [24] [INFO] Listening at: http://0.0.0.0:8000 (24)
[2018-06-12 09:39:16 +0000] [24] [INFO] Using worker: gevent
[2018-06-12 09:39:16 +0000] [34] [INFO] Booting worker with pid: 34
[2018-06-12 09:39:16 +0000] [35] [INFO] Booting worker with pid: 35
[2018-06-12 09:39:16 +0000] [36] [INFO] Booting worker with pid: 36
[2018-06-12 09:39:16 +0000] [37] [INFO] Booting worker with pid: 37
[2018-06-12 09:39:19 +0000] [35] [ERROR] Exception in worker process
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py", line 578, in spawn_worker
worker.init_process()
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 190, in init_process
super(GeventWorker, self).init_process()
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py", line 126, in init_process
self.load_wsgi()
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py", line 135, in load_wsgi
self.wsgi = self.app.wsgi()
File "/usr/local/lib/python2.7/site-packages/gunicorn/app/base.py", line 67, in wsgi
self.callable = self.load()
File "/usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py", line 65, in load
return self.load_wsgiapp()
File "/usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py", line 52, in load_wsgiapp
return util.import_app(self.app_uri)
File "/usr/local/lib/python2.7/site-packages/gunicorn/util.py", line 364, in import_app
app = eval(obj, vars(mod))
File "<string>", line 1, in <module>
File "/opt/CTFd/CTFd/__init__.py", line 105, in create_app
create_database(url, encoding='utf8mb4')
File "/usr/local/lib/python2.7/site-packages/sqlalchemy_utils/functions/database.py", line 561, in create_database
result_proxy = engine.execute(text)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2075, in execute
return connection.execute(statement, *multiparams, **params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 942, in execute
return self._execute_text(object, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1104, in _execute_text
statement, parameters
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
ProgrammingError: (pymysql.err.ProgrammingError) (1007, u"Can't create database 'ctfd'; database exists") [SQL: "CREATE DATABASE ctfd CHARACTER SET = 'utf8mb4'"] (Background on this error at: http://sqlalche.me/e/f405)
[2018-06-12 09:39:19 +0000] [35] [INFO] Worker exiting (pid: 35)
[2018-06-12 09:39:19 +0000] [36] [ERROR] Exception in worker process
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py", line 578, in spawn_worker
worker.init_process()
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 190, in init_process
super(GeventWorker, self).init_process()
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py", line 126, in init_process
self.load_wsgi()
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py", line 135, in load_wsgi
self.wsgi = self.app.wsgi()
File "/usr/local/lib/python2.7/site-packages/gunicorn/app/base.py", line 67, in wsgi
self.callable = self.load()
File "/usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py", line 65, in load
return self.load_wsgiapp()
File "/usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py", line 52, in load_wsgiapp
return util.import_app(self.app_uri)
File "/usr/local/lib/python2.7/site-packages/gunicorn/util.py", line 364, in import_app
app = eval(obj, vars(mod))
File "<string>", line 1, in <module>
File "/opt/CTFd/CTFd/__init__.py", line 105, in create_app
create_database(url, encoding='utf8mb4')
File "/usr/local/lib/python2.7/site-packages/sqlalchemy_utils/functions/database.py", line 561, in create_database
result_proxy = engine.execute(text)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2075, in execute
return connection.execute(statement, *multiparams, **params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 942, in execute
return self._execute_text(object, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1104, in _execute_text
statement, parameters
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
ProgrammingError: (pymysql.err.ProgrammingError) (1007, u"Can't create database 'ctfd'; database exists") [SQL: "CREATE DATABASE ctfd CHARACTER SET = 'utf8mb4'"] (Background on this error at: http://sqlalche.me/e/f405)
[2018-06-12 09:39:19 +0000] [36] [INFO] Worker exiting (pid: 36)
[2018-06-12 09:39:19 +0000] [37] [ERROR] Exception in worker process
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py", line 578, in spawn_worker
worker.init_process()
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 190, in init_process
super(GeventWorker, self).init_process()
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py", line 126, in init_process
self.load_wsgi()
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py", line 135, in load_wsgi
self.wsgi = self.app.wsgi()
File "/usr/local/lib/python2.7/site-packages/gunicorn/app/base.py", line 67, in wsgi
self.callable = self.load()
File "/usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py", line 65, in load
return self.load_wsgiapp()
File "/usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py", line 52, in load_wsgiapp
return util.import_app(self.app_uri)
File "/usr/local/lib/python2.7/site-packages/gunicorn/util.py", line 364, in import_app
app = eval(obj, vars(mod))
File "<string>", line 1, in <module>
File "/opt/CTFd/CTFd/__init__.py", line 105, in create_app
create_database(url, encoding='utf8mb4')
File "/usr/local/lib/python2.7/site-packages/sqlalchemy_utils/functions/database.py", line 561, in create_database
result_proxy = engine.execute(text)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2075, in execute
return connection.execute(statement, *multiparams, **params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 942, in execute
return self._execute_text(object, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1104, in _execute_text
statement, parameters
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
ProgrammingError: (pymysql.err.ProgrammingError) (1007, u"Can't create database 'ctfd'; database exists") [SQL: "CREATE DATABASE ctfd CHARACTER SET = 'utf8mb4'"] (Background on this error at: http://sqlalche.me/e/f405)
[2018-06-12 09:39:19 +0000] [37] [INFO] Worker exiting (pid: 37)
[2018-06-12 09:39:21 +0000] [10] [INFO] Starting gunicorn 19.7.1
[2018-06-12 09:39:21 +0000] [10] [INFO] Listening at: http://0.0.0.0:8000 (10)
[2018-06-12 09:39:21 +0000] [10] [INFO] Using worker: gevent
[2018-06-12 09:39:21 +0000] [20] [INFO] Booting worker with pid: 20
[2018-06-12 09:39:21 +0000] [21] [INFO] Booting worker with pid: 21
[2018-06-12 09:39:21 +0000] [22] [INFO] Booting worker with pid: 22
[2018-06-12 09:39:21 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 09:40:30 +0000] [12] [INFO] Starting gunicorn 19.7.1
[2018-06-12 09:40:30 +0000] [12] [INFO] Listening at: http://0.0.0.0:8000 (12)
[2018-06-12 09:40:30 +0000] [12] [INFO] Using worker: gevent
[2018-06-12 09:40:30 +0000] [22] [INFO] Booting worker with pid: 22
[2018-06-12 09:40:30 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 09:40:30 +0000] [24] [INFO] Booting worker with pid: 24
[2018-06-12 09:40:30 +0000] [25] [INFO] Booting worker with pid: 25
[2018-06-12 10:11:45 +0000] [12] [INFO] Starting gunicorn 19.7.1
[2018-06-12 10:11:45 +0000] [12] [INFO] Listening at: http://0.0.0.0:8000 (12)
[2018-06-12 10:11:45 +0000] [12] [INFO] Using worker: gevent
[2018-06-12 10:11:45 +0000] [22] [INFO] Booting worker with pid: 22
[2018-06-12 10:11:45 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 10:11:45 +0000] [24] [INFO] Booting worker with pid: 24
[2018-06-12 10:11:45 +0000] [25] [INFO] Booting worker with pid: 25
[2018-06-12 10:17:40 +0000] [12] [INFO] Starting gunicorn 19.7.1
[2018-06-12 10:17:40 +0000] [12] [INFO] Listening at: http://0.0.0.0:8000 (12)
[2018-06-12 10:17:40 +0000] [12] [INFO] Using worker: gevent
[2018-06-12 10:17:40 +0000] [22] [INFO] Booting worker with pid: 22
[2018-06-12 10:17:40 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 10:17:40 +0000] [26] [INFO] Booting worker with pid: 26
[2018-06-12 10:17:40 +0000] [36] [INFO] Booting worker with pid: 36
[2018-06-12 10:17:48,709] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 10:17:48 +0000] [26] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 10:18:17,275] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 10:18:17 +0000] [23] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 10:18:17,644] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 10:18:17 +0000] [36] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 11:01:42,842] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 11:01:42 +0000] [22] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 12:04:10 +0000] [12] [INFO] Starting gunicorn 19.7.1
[2018-06-12 12:04:10 +0000] [12] [INFO] Listening at: http://0.0.0.0:8000 (12)
[2018-06-12 12:04:10 +0000] [12] [INFO] Using worker: gevent
[2018-06-12 12:04:10 +0000] [22] [INFO] Booting worker with pid: 22
[2018-06-12 12:04:10 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 12:04:10 +0000] [24] [INFO] Booting worker with pid: 24
[2018-06-12 12:04:10 +0000] [25] [INFO] Booting worker with pid: 25
[2018-06-12 12:04:41,681] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 12:04:41 +0000] [23] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 12:09:03 +0000] [14] [INFO] Starting gunicorn 19.7.1
[2018-06-12 12:09:03 +0000] [14] [INFO] Listening at: http://0.0.0.0:8000 (14)
[2018-06-12 12:09:03 +0000] [14] [INFO] Using worker: gevent
[2018-06-12 12:09:03 +0000] [24] [INFO] Booting worker with pid: 24
[2018-06-12 12:09:03 +0000] [25] [INFO] Booting worker with pid: 25
[2018-06-12 12:09:03 +0000] [26] [INFO] Booting worker with pid: 26
[2018-06-12 12:09:03 +0000] [27] [INFO] Booting worker with pid: 27
[2018-06-12 12:10:31 +0000] [14] [INFO] Starting gunicorn 19.7.1
[2018-06-12 12:10:31 +0000] [14] [INFO] Listening at: http://0.0.0.0:8000 (14)
[2018-06-12 12:10:31 +0000] [14] [INFO] Using worker: gevent
[2018-06-12 12:10:31 +0000] [24] [INFO] Booting worker with pid: 24
[2018-06-12 12:10:31 +0000] [25] [INFO] Booting worker with pid: 25
[2018-06-12 12:10:31 +0000] [26] [INFO] Booting worker with pid: 26
[2018-06-12 12:10:32 +0000] [27] [INFO] Booting worker with pid: 27
[2018-06-12 12:11:52,330] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 12:11:52 +0000] [25] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 12:11:54,411] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 12:11:54 +0000] [24] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 12:12:17 +0000] [12] [INFO] Starting gunicorn 19.7.1
[2018-06-12 12:12:17 +0000] [12] [INFO] Listening at: http://0.0.0.0:8000 (12)
[2018-06-12 12:12:17 +0000] [12] [INFO] Using worker: gevent
[2018-06-12 12:12:17 +0000] [22] [INFO] Booting worker with pid: 22
[2018-06-12 12:12:17 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 12:12:17 +0000] [24] [INFO] Booting worker with pid: 24
[2018-06-12 12:12:18 +0000] [25] [INFO] Booting worker with pid: 25
[2018-06-12 12:12:26,650] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 12:12:26 +0000] [23] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 12:12:27,648] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 12:12:27 +0000] [22] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 12:12:28,557] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 12:12:28 +0000] [24] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:00,107] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:00 +0000] [25] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:01,443] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:01 +0000] [23] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:02,317] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:02 +0000] [25] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:02,673] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:02 +0000] [22] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:03,136] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:03 +0000] [25] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:03,591] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:03 +0000] [22] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:03,714] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:03 +0000] [25] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:04,024] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:04 +0000] [24] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:04,386] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:04 +0000] [22] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:04,753] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:04 +0000] [25] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:03:39,766] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:03:39 +0000] [22] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:05:24 +0000] [12] [INFO] Starting gunicorn 19.7.1
[2018-06-12 14:05:24 +0000] [12] [INFO] Listening at: http://0.0.0.0:8000 (12)
[2018-06-12 14:05:24 +0000] [12] [INFO] Using worker: gevent
[2018-06-12 14:05:24 +0000] [22] [INFO] Booting worker with pid: 22
[2018-06-12 14:05:24 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 14:05:24 +0000] [34] [INFO] Booting worker with pid: 34
[2018-06-12 14:05:24 +0000] [36] [INFO] Booting worker with pid: 36
[2018-06-12 14:11:14 +0000] [12] [INFO] Starting gunicorn 19.7.1
[2018-06-12 14:11:14 +0000] [12] [INFO] Listening at: http://0.0.0.0:8000 (12)
[2018-06-12 14:11:14 +0000] [12] [INFO] Using worker: gevent
[2018-06-12 14:11:14 +0000] [22] [INFO] Booting worker with pid: 22
[2018-06-12 14:11:14 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 14:11:14 +0000] [24] [INFO] Booting worker with pid: 24
[2018-06-12 14:11:15 +0000] [26] [INFO] Booting worker with pid: 26
[2018-06-12 14:11:41,239] ERROR in app: Exception on /setup [GET]
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2284, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1807, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1710, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1805, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1791, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/opt/CTFd/CTFd/views.py", line 102, in setup
return render_template('setup.html', nonce=session.get('nonce'))
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 135, in render_template
context, ctx.app)
File "/usr/local/lib/python2.7/site-packages/flask/templating.py", line 117, in _render
rv = template.render(context)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "/usr/local/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "/opt/CTFd/CTFd/themes/core/templates/setup.html", line 1, in top-level template code
{% extends "base.html" %}
File "/opt/CTFd/CTFd/themes/core/templates/base.html", line 50, in top-level template code
{% for page in get_user_page_menu_bar() %}
File "/usr/local/lib/python2.7/site-packages/jinja2/sandbox.py", line 427, in call
return __context.call(__obj, *args, **kwargs)
File "/opt/CTFd/CTFd/plugins/__init__.py", line 125, in get_user_page_menu_bar
return db_pages() + USER_PAGE_MENU_BAR
File "/usr/local/lib/python2.7/site-packages/flask_caching/__init__.py", line 674, in decorated_function
rv = f(*args, **kwargs)
File "/opt/CTFd/CTFd/utils/__init__.py", line 248, in pages
db_pages = Pages.query.filter(Pages.route != "index", Pages.draft != True).all()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
return list(self)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/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 "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
result = self._query(query)
File "/usr/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
conn.query(q)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
result.read()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
packet.check_error()
File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'pages.auth_required' in 'field list'") [SQL: u'SELECT pages.id AS pages_id, pages.auth_required AS pages_auth_required, pages.title AS pages_title, pages.route AS pages_route, pages.html AS pages_html, pages.draft AS pages_draft \nFROM pages \nWHERE pages.route != %(route_1)s AND pages.draft != true'] [parameters: {u'route_1': 'index'}] (Background on this error at: http://sqlalche.me/e/2j85)
[2018-06-12 14:11:41 +0000] [22] [ERROR] Error handling request /setup
Traceback (most recent call last):
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 56, in handle
self.handle_request(listener_name, req, client, addr)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/ggevent.py", line 152, in handle_request
super(GeventWorker, self).handle_request(*args)
File "/usr/local/lib/python2.7/site-packages/gunicorn/workers/async.py", line 107, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2301, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 2287, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python2.7/site-packages/flask/app.py", line 1740, in handle_exception
return self.finalize_request(handler(e), from_error_handler=True)
File "/opt/CTFd/CTFd/utils/__init__.py", line 137, in general_error
return render_template('errors/500.html', error=error.description), 500
AttributeError: 'InternalError' object has no attribute 'description'
[2018-06-12 14:16:31 +0000] [12] [INFO] Starting gunicorn 19.7.1
[2018-06-12 14:16:31 +0000] [12] [INFO] Listening at: http://0.0.0.0:8000 (12)
[2018-06-12 14:16:31 +0000] [12] [INFO] Using worker: gevent
[2018-06-12 14:16:31 +0000] [22] [INFO] Booting worker with pid: 22
[2018-06-12 14:16:31 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 14:16:31 +0000] [24] [INFO] Booting worker with pid: 24
[2018-06-12 14:16:31 +0000] [25] [INFO] Booting worker with pid: 25
[2018-06-12 14:17:28 +0000] [13] [INFO] Starting gunicorn 19.7.1
[2018-06-12 14:17:28 +0000] [13] [INFO] Listening at: http://0.0.0.0:8000 (13)
[2018-06-12 14:17:28 +0000] [13] [INFO] Using worker: gevent
[2018-06-12 14:17:28 +0000] [23] [INFO] Booting worker with pid: 23
[2018-06-12 14:17:28 +0000] [24] [INFO] Booting worker with pid: 24
[2018-06-12 14:17:28 +0000] [25] [INFO] Booting worker with pid: 25
[2018-06-12 14:17:28 +0000] [26] [INFO] Booting worker with pid: 26
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment