+- 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: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Solved Set content over UPNP?? (/showthread.php?tid=365677)
RE: Set content over UPNP?? - LongMan - 2021-11-26
That's the error from your log. Please delete the video database and reboot
2021-11-26 20:32:51.360 T:606 ERROR <general>: SQL: [MyVideos120.db] SQLite error SQLITE_ERROR (no such table: import)
Query: SELECT source.identifier, import.media_type, import.last_sync, import.settings FROM import JOIN source ON source.source_id = import.source_id
2021-11-26 20:32:51.360 T:606 ERROR <general>: GetImports unable to GetImports (SELECT source.identifier, import.media_type, import.last_sync, import.settings FROM import JOIN source ON source.source_id = import.source_id)
RE: Set content over UPNP?? - LongMan - 2021-11-26
Both machines please. Chances are the database upgrade did not complete properly. MediaImport adds new fields to the database.
RE: Set content over UPNP?? - psrkallez06 - 2021-11-26
Done, same issue. Here is the log:
https://pastebin.com/uWsSMVNn
RE: Set content over UPNP?? - LongMan - 2021-11-26
2021-11-26 20:58:04.101 T:618 INFO <general>: Old database found - updating from version 119 to 120
It is still trying to update the database. Just rename the database folder to databaseold
RE: Set content over UPNP?? - psrkallez06 - 2021-11-26
You mean the whole database folder?
RE: Set content over UPNP?? - psrkallez06 - 2021-11-26
https://i.gyazo.com/ca3be29e91ae414e660a3c09cb47408e.png
Same issue. Log again: https://pastebin.com/Y2cwuv5M
RE: Set content over UPNP?? - LongMan - 2021-11-26
yes. Kodi will replace on startup
RE: Set content over UPNP?? - psrkallez06 - 2021-11-26
So any more ideas? And thank you for taking The time to help! I really appriciate it.
RE: Set content over UPNP?? - LongMan - 2021-11-26
Give me a few. Trying to get a second opinion.
RE: Set content over UPNP?? - psrkallez06 - 2021-11-26
Of course. I need to sleep soon. Work tomorrow. Will check this thread asap
RE: Set content over UPNP?? - LongMan - 2021-11-26
While we wait could you try the build linked. It has a few LibreELEC updates
Edit: link removed
RE: Set content over UPNP?? - LongMan - 2021-11-27
The second opinion that I sought was that of the Developer, Montellese. It seems that you found a bug in the database routines. It has been fixed and i ran a new build. both the tar and img files are linked below. Just drop either into the update folder. to be safe rename or delete the database folder.
https://drive.google.com/file/d/1-FW-t9xFYV1xRth3nEb4W6qXcCdTFAnk/view?usp=sharing
https://drive.google.com/file/d/1iVIOflsFuLc6OaYQL-1Jw2B55SKBvXfb/view?usp=sharing
Let us know how it goes.
Cheers,
LongMan
RE: Set content over UPNP?? - psrkallez06 - 2021-11-27
Oh awesome. I hope that it fixed it. Will report back tonight when im home
RE: Set content over UPNP?? - psrkallez06 - 2021-11-27
Update! After the update, it detected the main one as soon as i booted. Thank you very much for all your help! Fyi this is exactly what i was looking for!
RE: Set content over UPNP?? - psrkallez06 - 2021-11-27
@LongMan when i try to play something from the library i get "this file is no longer available would you like to remove it from your library". hmm?