+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Linux (https://forum.kodi.tv/forumdisplay.php?fid=52)
+---- Thread: SQL: [MyVideos116] The table does not exist (/showthread.php?tid=353476)
SQL: [MyVideos116] The table does not exist - weedaj - 2020-04-14
hi I'm running 18.6 on LibreElec 9.2.1. For some reason, the video database is no longer displaying any films or series and updating it seems to fail as was. The library sits on a MySQL database on my Synology NAS
I have uploaded a debug log here https://pastebin.com/zFErH5ft
I have tried dropping the database but no success either. Any suggestions?
Thanks in advance for working with me on this.
RE: SQL: [MyVideos116] The table does not exist - jeffski10 - 2020-04-14
Do you have the full log file as I don't see your advancedsettings.xml settings where the MYSQL is being set. If the DB was dropped then it would get recreated on start up.
RE: SQL: [MyVideos116] The table does not exist - weedaj - 2020-04-14
(2020-04-14, 12:27)jeffski10 Wrote: Do you have the full log file as I don't see your advancedsettings.xml settings where the MYSQL is being set. If the DB was dropped then it would get recreated on start up.
See below my advancedsettings.xml:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.178.203</host>
<port>3306</port>
<user>user</user>
<pass>pwd</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.178.203</host>
<port>3306</port>
<user>user</user>
<pass>pwd</pass>
</musicdatabase>
<videolibrary>
<dateadded>0</dateadded>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
RE: SQL: [MyVideos116] The table does not exist - asavah - 2020-04-14
Provide a full uncut debug log. The snippet you provided is totally useless.
RE: SQL: [MyVideos116] The table does not exist - Klojum - 2020-04-14
(2020-04-14, 09:41)weedaj Wrote: I have uploaded a debug log here
Now please provide us with the uncut version of your log file, not just the part that you find interesting.
FYI, most machine info is in the beginning.