Release WatchedList - service to automatically save/restore watched state
Running the add-on after update from 1.3.5 returns an error, nothing is done. From the log, the addon fails to create the new table in the database (MySQL/Mariadb):
python:
2022-04-16 09:53:09.669 T:3740 INFO <general>: service.watchedlist: Update Library Manual Run.
2022-04-16 09:53:09.714 T:3740 INFO <general>: service.watchedlist: database_backup: database backup copy created to C:\Users\JPS\AppData\Roaming\Kodi\userdata\addon_data\service.watchedlist\20220416_095309-watchedlist.db.zip
2022-04-16 09:53:09.714 T:3740 ERROR <general>: service.watchedlist: sync_tvshows: SQLite Database error accessing the wl database: no such column: userrating
2022-04-16 09:53:09.714 T:3740 INFO <general>: service.watchedlist: Notification. Watchedlist: Error: Error updating WL database

After adding the missing columns manually to the db, there's still a query error:

python:
2022-04-16 10:35:31.094 T:1752 INFO <general>: service.watchedlist: Update Library Manual Run.
2022-04-16 10:35:31.148 T:1752 ERROR <general>: service.watchedlist: get_watched_wl: MySQL Database error getting the wl database. 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `movie_watched` ORDER BY `title`' at line 1
2022-04-16 10:35:31.148 T:1752 INFO <general>: service.watchedlist: Notification. Watchedlist: Error: Error loading WL-database
Reply


Messages In This Thread
RE: WatchedList - service to automatically save/restore watched state - by HeresJohnny - 2022-04-16, 10:01
Logout Mark Read Team Forum Stats Members Help
WatchedList - service to automatically save/restore watched state3