SQL: [MyVideos116] The table does not exist
#1
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.
Reply
#2
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.
KODI Nexus - CoreELEC everywhere on Ugoos AM6 Plus&Pro, Plex Server, HDHomerun with TVHeadend on my NAS.
Reply
#3
(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>
Reply
#4
Provide a full uncut debug log. The snippet you provided is totally useless.
Reply
#5
(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.
Reply

Logout Mark Read Team Forum Stats Members Help
SQL: [MyVideos116] The table does not exist0