gistfile1.txt

Traceback (most recent call last): File "C:\Python27\lib\site-packages\flask\app.py", line 1475, in full_dispatch_request rv = self.dispatch_request() File "C:\Python27\lib\site-packages\flask\app.py", line 1461, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "C:\Python27\lib\site-packages\flask_login.py", line 658, in decorated_view return func(*args, **kwargs) File "C:\web\inno\innovate\views.py", line 207, in sites sites = query.paginate(1, 40, False) File "C:\Python27\lib\site-packages\flask_sqlalchemy\__init__.py", line 405, in paginate items = self.limit(per_page).offset((page - 1) * per_page).all() File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\orm\query.py", line 2300, in all return list(self) File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\orm\query.py", line 2412, in __iter__ return self._execute_and_instances(context) File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\orm\query.py", line 2427, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 729, in execute return meth(self, multiparams, params) File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\sql\elements.py", line 321, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 826, in _execute_clauseelement compiled_sql, distilled_params File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 958, in _execute_context context) File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 1160, in _handle_dbapi_exception exc_info File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\util\compat.py", line 199, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 951, in _execute_context context) File "C:\Python27\lib\site-packages\sqlalchemy-0.9.7-py2.7-win32.egg\sqlalchemy\engine\default.py", line 436, in do_execute cursor.execute(statement, parameters) ProgrammingError: (ProgrammingError) column site.actives does not exist LINE 2: ...stomer ON customer.id = site.customer_id ORDER BY site.activ... ^ 'SELECT site.id AS site_id, site.customer_id AS site_customer_id, site.name AS site_name, site.active AS site_active \nFROM site JOIN customer ON customer.id = site.customer_id ORDER BY site.actives asc \n LIMIT %(param_1)s OFFSET %(param_2)s' {'param_1': 40, 'param_2': 0}