pi@raspberrypi:~/Mycodo/databases $ sudo ../env/bin/python ./alembic_post.py Found revision IDs to execute code: ['f5b77ef5f17c', '61a0d0568d24'] Revision ID f5b77ef5f17c Executing post-alembic code for revision f5b77ef5f17c Revision ID 61a0d0568d24 Executing post-alembic code for revision 61a0d0568d24 Error raised in session_scope. Session will be rolled back: db_uri='sqlite:////home/pi/Mycodo/databases/mycodo.db', error='(sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8)' Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: roles.reset_password The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/pi/Mycodo/mycodo/databases/utils.py", line 26, in session_scope yield session File "./alembic_post.py", line 750, in for role in session.query(Role).all(): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all return self._iter().all() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8) ERROR: post-alembic revision 61a0d0568d24: Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: roles.reset_password The above exception was the direct cause of the following exception: Traceback (most recent call last): File "./alembic_post.py", line 750, in for role in session.query(Role).all(): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all return self._iter().all() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8) Completed with errors. Review the entire log for details. Errors recorded: ERROR: ERROR: post-alembic revision 61a0d0568d24: Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: roles.reset_password The above exception was the direct cause of the following exception: Traceback (most recent call last): File "./alembic_post.py", line 750, in for role in session.query(Role).all(): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all return self._iter().all() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8) pi@raspberrypi:~/Mycodo/databases $