- 2024-03-13 10:18:24 | ERROR | [PF Countup] Error updating settings:
- Traceback (most recent call last):
- File "/home/pi/app/integrations/PFINT_countup/routes.py", line 74, in settings
- local_db.session.merge(app_settings)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/attributes.py", line 273, in __set__
- instance_state(instance), instance_dict(instance), value, None
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/attributes.py", line 866, in set
- state, dict_, value, old, initiator
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/attributes.py", line 874, in fire_replace_event
- state, value, previous, initiator or self._replace_token
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/util.py", line 172, in set_
- return validator(state.obj(), key, value)
- File "/home/pi/app/integrations/PFINT_countup/models.py", line 38, in validate_animation_duration
- @validates("animation_duration")
- ValueError: invalid literal for int() with base 10: ''
- 2024-03-13 10:31:25 | ERROR | Error importing submodule countup for integration PFINT_countup
- Traceback (most recent call last):
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1284, in _execute_context
- cursor, statement, parameters, context
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute
- cursor.execute(statement, parameters)
- sqlite3.OperationalError: no such column: app_settings.animation_spin
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "/home/pi/app/integrations_sf.py", line 834, in load_integration_modules
- ret[integration] = importlib.import_module(impt_str)
- File "/usr/local/lib/python3.7/importlib/__init__.py", line 127, in import_module
- return _bootstrap._gcd_import(name[level:], package, level)
- File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
- File "<frozen importlib._bootstrap>", line 983, in _find_and_load
- File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
- File "<frozen importlib._bootstrap>", line 677, in _load_unlocked
- File "<frozen importlib._bootstrap_external>", line 728, in exec_module
- File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
- File "/home/pi/app/integrations/PFINT_countup/countup.py", line 54, in <module>
- app_settings = AppSettings.query.first()
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3375, in first
- ret = list(self[0:1])
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3149, in __getitem__
- return list(res)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3481, in __iter__
- return self._execute_and_instances(context)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3506, in _execute_and_instances
- result = conn.execute(querycontext.statement, self._params)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1020, in execute
- return meth(self, multiparams, params)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_clauseelement
- distilled_params,
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1324, in _execute_context
- e, statement, parameters, cursor, context
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1518, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
- raise exception
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1284, in _execute_context
- cursor, statement, parameters, context
- File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute
- cursor.execute(statement, parameters)
- sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: app_settings.animation_spin
- [SQL: SELECT app_settings.id AS app_settings_id, app_settings.enabled AS app_settings_enabled, app_settings.start_at AS app_settings_start_at, app_settings.animation AS app_settings_animation, app_settings.animation_duration AS app_settings_animation_duration, app_settings.animation_spin AS app_settings_animation_spin
- FROM app_settings
- LIMIT ? OFFSET ?]
- [parameters: (1, 0)]
- (Background on this error at: http://sqlalche.me/e/e3q8)