OperationalError: no such column: tvg_name

[dufourgilles]

Crash when trying to record a channel

2020-12-27 20:45:59.078 T:123145343946752 ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<-- - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS! Error Type: <class 'sqlite3.OperationalError'> Error Contents: no such column: tvg_name Traceback (most recent call last): File "/Users/gdufour/Library/Application Support/Kodi/addons/plugin.video.iptv.recorder/main.py", line 3484, in plugin.run() File "/Users/gdufour/Library/Application Support/Kodi/addons/script.module.xbmcswift2/lib/xbmcswift2/plugin.py", line 342, in run items = self._dispatch(self.request.path) File "/Users/gdufour/Library/Application Support/Kodi/addons/script.module.xbmcswift2/lib/xbmcswift2/plugin.py", line 316, in _dispatch listitems = view_func(**items) File "/Users/gdufour/Library/Application Support/Kodi/addons/plugin.video.iptv.recorder/main.py", line 1448, in broadcast channel = cursor.execute("SELECT * FROM channels WHERE tvg_name=?", (channelname, )).fetchone() OperationalError: no such column: tvg_name -->End of Python script error report<-- 2020-12-27 20:45:59.110 T:123145342337024 ERROR: GetDirectory - Error getting plugin://plugin.video.iptv.recorder/broadcast/11114/%7CFR%7C+TV++FAMILY+HD

Indeed the schema does not match the code

sqlite> .schema channels CREATE TABLE channels(uid INTEGER PRIMARY KEY ASC, id TEXT, name TEXT, icon TEXT); sqlite>

channel = cursor.execute("SELECT * FROM streams WHERE name=?", (channelname,)).fetchone()
if not channel:
    channel = cursor.execute("SELECT * FROM channels WHERE tvg_name=?", (channelname, )).fetchone()
    uid, tvg_id, name, tvg_logo = channel
    url = ""
else:
    uid,

[Martin-Stangl]

Encountered the same problem on Windows 10:

ERROR <general>: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<-- - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS! Error Type: <class 'sqlite3.OperationalError'> Error Contents: no such column: tvg_name Traceback (most recent call last): File "C:\Users\pcadmin\AppData\Roaming\Kodi\addons\plugin.video.iptv.recorder\main.py", line 3434, in <module> plugin.run() File "C:\Users\pcadmin\AppData\Roaming\Kodi\addons\script.module.xbmcswift2\lib\xbmcswift2\plugin.py", line 338, in run items = self._dispatch(self.request.path) File "C:\Users\pcadmin\AppData\Roaming\Kodi\addons\script.module.xbmcswift2\lib\xbmcswift2\plugin.py", line 312, in _dispatch listitems = view_func(**items) File "C:\Users\pcadmin\AppData\Roaming\Kodi\addons\plugin.video.iptv.recorder\main.py", line 1465, in broadcast channel = cursor.execute("SELECT * FROM channels WHERE tvg_name=?", (channelname, )).fetchone() sqlite3.OperationalError: no such column: tvg_name -->End of Python script error report<--

[Martin-Stangl]

I just found more details on the issue and a workaround posted by carloss at 2021-02-23, 19:26 on the Kodi forum: https://forum.kodi.tv/archive/index.php?thread-329991-83.html: