pi@raspberrypi:~ $ sudo service mycodo stop pi@raspberrypi:~ $ sudo service mycodoflask stop pi@raspberrypi:~ $ cd ~/Mycodo/databases pi@raspberrypi:~/Mycodo/databases $ sudo ../env/bin/alembic upgrade head INFO [alembic.runtime.migration] Context impl SQLiteImpl. INFO [alembic.runtime.migration] Will assume non-transactional DDL. INFO [alembic.runtime.migration] Running upgrade dc9eddfc845d -> 267dc913a062, Add log_level_debug, message_include_code, force_command INFO [alembic.runtime.migration] Running upgrade 267dc913a062 -> 4b5f6207cbdf, Add Camera options INFO [alembic.runtime.migration] Running upgrade 4b5f6207cbdf -> f5b77ef5f17c, Change SMTP DB options INFO [alembic.runtime.migration] Running upgrade f5b77ef5f17c -> 61a0d0568d24, Add password reset capabilities 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: Cannot add a NOT NULL column with default value NULL The above exception was the direct cause of the following exception: Traceback (most recent call last): File "../env/bin/alembic", line 8, in sys.exit(main()) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/config.py", line 559, in main CommandLine(prog=prog).main(argv=argv) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/config.py", line 553, in main self.run_cmd(cfg, options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/config.py", line 533, in run_cmd **dict((k, getattr(options, k, None)) for k in kwarg) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/command.py", line 294, in upgrade script.run_env() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/script/base.py", line 490, in run_env util.load_python_file(self.dir, "env.py") File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 97, in load_python_file module = load_module_py(module_id, path) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/util/compat.py", line 182, in load_module_py spec.loader.exec_module(module) File "", line 728, in exec_module File "", line 219, in _call_with_frames_removed File "alembic/env.py", line 69, in run_migrations_online() File "alembic/env.py", line 64, in run_migrations_online context.run_migrations() File "", line 8, in run_migrations File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/runtime/environment.py", line 813, in run_migrations self.get_context().run_migrations(**kw) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/runtime/migration.py", line 560, in run_migrations step.migration_fn(**kw) File "/home/pi/Mycodo/databases/alembic/versions/61a0d0568d24_add_password_reset_capabilities.py", line 32, in upgrade batch_op.add_column(sa.Column('reset_password', sa.Boolean, nullable=False, default=False)) File "/usr/lib/python3.7/contextlib.py", line 119, in __exit__ next(self.gen) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/operations/base.py", line 336, in batch_alter_table impl.flush() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/operations/batch.py", line 86, in flush fn(*arg, **kw) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/ddl/impl.py", line 256, in add_column self._exec(base.AddColumn(table_name, column, schema=schema)) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/ddl/impl.py", line 146, in _exec return conn.execute(construct, multiparams) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1200, in execute return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 78, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1296, in _execute_ddl compiled, 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) Cannot add a NOT NULL column with default value NULL [SQL: ALTER TABLE roles ADD COLUMN reset_password BOOLEAN NOT NULL] (Background on this error at: http://sqlalche.me/e/14/e3q8) pi@raspberrypi:~/Mycodo/databases $