Fails to start after latest upgrade or dist upgrade
Describe the bug Watcher fails to install after installing the last update, or upgrading from Debian Buster to Bullseye
To Reproduce Steps to reproduce the behavior:
- Accept update from Watcher main page
- Wait for update to install & Watcher restart
- Watcher page fails to load
- Starting from console, gives the following error:
pi:/opt/Watcher3 $ python3 watcher.py
Connected to database sqlite:////opt/Watcher3/userdata/watcher.sqlite
SQL Database Query: ['PRAGMA user_version'].
Traceback (most recent call last):
File "/opt/Watcher3/core/sqldb.py", line 173, in execute
return self.engine.execute(*command)
AttributeError: 'Engine' object has no attribute 'execute'
SQL Databse Query: ['PRAGMA user_version'].
Traceback (most recent call last):
File "/opt/Watcher3/core/sqldb.py", line 173, in execute
return self.engine.execute(*command)
AttributeError: 'Engine' object has no attribute 'execute'
Traceback (most recent call last):
File "/opt/Watcher3/watcher.py", line 90, in
Expected behavior Watcher starts successfully after update.
Additional context Raspberry pi 3B+ Debian 11 Bullseye 6.1.14-v7+ #1633 SMP Thu Mar 2 11:02:03 GMT 2023 armv7l