Kodi Community Forum

Full Version: SQL: [MyVideos116] The table does not exist
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.
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.
(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>
Provide a full uncut debug log. The snippet you provided is totally useless.
(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.