To receive meaningful assistance you will need to provide a full debug log.
The instructions are here...
debug log (wiki)
If you are using the Basic Method, then ensure the following is applied...
1.
Enable debugging in Settings>System Settings>Logging,
2.
Restart Kodi
3.
Replicate the problem.
4.
Upload the log to
Kodi Paste Site manually or use the
Kodi Logfile Uploader. (wiki) With either method post the link to the log back here.
If you are using the Advanced Method ensure you have correctly created and applied the
advancedsettings.xml file (wiki)
In both instances, you should see the word
DEBUG throughout the log.
Note: Full logs only. No partial or redacted logs
Do NOT post your logs directly into the forum. Use the Kodi Paste Site. Post the link to your pasted log in the forum
(2022-12-14, 23:51)Donkeyfumbler Wrote: [ -> ]It’s worse than I thought initially. No changes I make since the update are being saved after I restart Kodi. I can add new items to the library, update watched status and anything else but as soon as I exit and start it again, all of that is gone. It’s like it’s frozen at the point that the update happened.
Same thing happening to me. I added about 20 shows to my tv library.stored on my hard drive. Scanned and scraped, added art, no prob. Everything looked good. Went to exit Kodi the same way I always do and it froze. Had to force close it. Rebooted the XBox, opened Kodi and the tv library was empty. Redid everything and the exact same thing happened again. Sigh.
(2022-12-13, 02:40)enzospeed Wrote: [ -> ]Youtube videos does not have sound after the update to v20. Anyone has similar issues?
Here's my
log
From log posted seems that effectively there are a loop in DB update process (as log captured is not the the first after boot with v20):
xml:
2022-12-15 13:43:42.801 T:1388 debug <general>: CDatabaseManager::Initialize, updating databases...
2022-12-15 13:43:42.802 T:1388 info <general>: Running database version Addons33
2022-12-15 13:43:42.803 T:1388 info <general>: Running database version ViewModes6
2022-12-15 13:43:42.804 T:1388 info <general>: Running database version Textures13
2022-12-15 13:43:42.808 T:1388 info <general>: Running database version MyMusic82
2022-12-15 13:43:42.813 T:1388 info <general>: Running database version MyVideos121
2022-12-15 13:43:42.814 T:1388 info <general>: Running database version TV40
2022-12-15 13:43:42.814 T:1388 info <general>: Attempting to update the database Epg16 from version 13 to 16
2022-12-15 13:43:42.814 T:1388 debug <general>: Cleaning indexes from database Epg16.db at Q:\Users\UserMgr0\AppData\Local\Packages\XBMCFoundation.Kodi_4n2hpmxwrvr6p\LocalState\userdata\Database\
2022-12-15 13:43:42.815 T:1388 debug <general>: Cleaning views from database Epg16.db at Q:\Users\UserMgr0\AppData\Local\Packages\XBMCFoundation.Kodi_4n2hpmxwrvr6p\LocalState\userdata\Database\
2022-12-15 13:43:42.815 T:1388 debug <general>: Cleaning triggers from database Epg16.db at Q:\Users\UserMgr0\AppData\Local\Packages\XBMCFoundation.Kodi_4n2hpmxwrvr6p\LocalState\userdata\Database\
2022-12-15 13:43:42.816 T:1388 error <general>: SQL: [Epg16.db] SQLite error SQLITE_ERROR (duplicate column name: iChannelGroup)
Query: ALTER TABLE savedsearches ADD iChannelGroup integer; (duplicate column name: iChannelGroup)
2022-12-15 13:43:42.822 T:1388 error <general>: Exception updating database Epg16 from version 13 to 16
2022-12-15 13:43:42.822 T:1388 error <general>: Error updating database Epg16 from version 13 to 16
2022-12-15 13:43:42.823 T:1388 info <general>: Old database found - updating from version 13 to 16
2022-12-15 13:43:42.823 T:1388 debug <general>: Copying from Epg13.db to Epg16 at Q:\Users\UserMgr0\AppData\Local\Packages\XBMCFoundation.Kodi_4n2hpmxwrvr6p\LocalState\userdata\Database\
2022-12-15 13:43:42.837 T:1388 info <general>: Attempting to update the database Epg16 from version 13 to 16
2022-12-15 13:43:42.837 T:1388 debug <general>: Cleaning indexes from database Epg16.db at Q:\Users\UserMgr0\AppData\Local\Packages\XBMCFoundation.Kodi_4n2hpmxwrvr6p\LocalState\userdata\Database\
2022-12-15 13:43:42.837 T:1388 debug <general>: Cleaning views from database Epg16.db at Q:\Users\UserMgr0\AppData\Local\Packages\XBMCFoundation.Kodi_4n2hpmxwrvr6p\LocalState\userdata\Database\
2022-12-15 13:43:42.838 T:1388 debug <general>: Cleaning triggers from database Epg16.db at Q:\Users\UserMgr0\AppData\Local\Packages\XBMCFoundation.Kodi_4n2hpmxwrvr6p\LocalState\userdata\Database\
2022-12-15 13:43:42.838 T:1388 error <general>: SQL: [Epg16.db] SQLite error SQLITE_ERROR (duplicate column name: iChannelGroup)
Query: ALTER TABLE savedsearches ADD iChannelGroup integer; (duplicate column name: iChannelGroup)
2022-12-15 13:43:42.838 T:1388 error <general>: Exception updating database Epg16 from version 13 to 16
2022-12-15 13:43:42.838 T:1388 error <general>: Error updating database Epg16 from version 13 to 16
2022-12-15 13:43:42.839 T:1388 debug <general>: CDatabaseManager::Initialize, updating databases... DONE
The easiest solution could be to delete the files that cause problems (Epg13.db and Epg16.db) or delete all in \userdata\Database and start fresh. It is always possible to make a copy before delete or wait for the next version. Actually this is not my area, maybe there is a better solution...
The upgrade DB scripts are causing the issues here. Is there a developer who can alter the upgrade scripts? I think it's just easier to wipe your database for now and start again.
(2022-12-15, 13:32)tutu Wrote: [ -> ]The upgrade DB scripts are causing the issues here. Is there a developer who can alter the upgrade scripts? I think it's just easier to wipe your database for now and start again.
How do we do this though? I'd be happy (well not happy, but you know what I mean) to start from fresh but uninstalling keeps all of the settings. How do I delete everything?
I couldn't and cant even start Kodi.....It would say, "One Second While App Is Loading" and then I'd get an error message.....As much as I didnt want to, I even tried Uninstalling/reinstalling but that didnt work and then tried holding the power button but no luck.....
(2022-12-15, 19:39)Donkeyfumbler Wrote: [ -> ] (2022-12-15, 13:32)tutu Wrote: [ -> ]The upgrade DB scripts are causing the issues here. Is there a developer who can alter the upgrade scripts? I think it's just easier to wipe your database for now and start again.
How do we do this though? I'd be happy (well not happy, but you know what I mean) to start from fresh but uninstalling keeps all of the settings. How do I delete everything?
Hey, I don't know what would happen in your case, but in my case I uninstalled 20 RC, reinstalled, and all my settings and media database where lost.
The same thing is happening to me, I've a couple of logs for other problem but I also see the database error, but not only with the EPG, with MyVideos as well:
Code:
2022-12-13 20:58:14.188 T:3496 error <general>: SQL: [MyVideos121.db] SQLite error SQLITE_ERROR (SQL logic error)
Query: CREATE INDEX ix_path ON path ( strPath ) (SQL logic error)
2022-12-13 20:58:14.191 T:3496 error <general>: Exception updating database MyVideos121 from version 119 to 121
2022-12-13 20:58:14.191 T:3496 error <general>: Error updating database MyVideos121 from version 119 to 121
2022-12-13 20:58:14.194 T:3496 info <general>: Old database found - updating from version 119 to 121
2022-12-13 20:58:14.286 T:3496 info <general>: Attempting to update the database MyVideos121 from version 119 to 121
2022-12-13 20:58:14.298 T:3496 info <general>: CVideoDatabase::CreateAnalytics - creating indices
2022-12-13 20:58:14.299 T:3496 error <general>: SQL: [MyVideos121.db] SQLite error SQLITE_ERROR (SQL logic error)
Query: CREATE INDEX ix_path ON path ( strPath ) (SQL logic error)
2022-12-13 20:58:14.299 T:3496 error <general>: Exception updating database MyVideos121 from version 119 to 121
2022-12-13 20:58:14.299 T:3496 error <general>: Error updating database MyVideos121 from version 119 to 121
2022-12-13 20:58:14.305 T:3496 info <general>: Running database version TV40
2022-12-13 20:58:14.305 T:3496 info <general>: Attempting to update the database Epg16 from version 13 to 16
2022-12-13 20:58:14.307 T:3496 error <general>: SQL: [Epg16.db] SQLite error SQLITE_ERROR (duplicate column name: iChannelGroup)
Query: ALTER TABLE savedsearches ADD iChannelGroup integer; (duplicate column name: iChannelGroup)
2022-12-13 20:58:14.307 T:3496 error <general>: Exception updating database Epg16 from version 13 to 16
2022-12-13 20:58:14.307 T:3496 error <general>: Error updating database Epg16 from version 13 to 16
2022-12-13 20:58:14.308 T:3496 info <general>: Old database found - updating from version 13 to 16
2022-12-13 20:58:14.312 T:3496 info <general>: Attempting to update the database Epg16 from version 13 to 16
2022-12-13 20:58:14.313 T:3496 error <general>: SQL: [Epg16.db] SQLite error SQLITE_ERROR (duplicate column name: iChannelGroup)
Query: ALTER TABLE savedsearches ADD iChannelGroup integer; (duplicate column name: iChannelGroup)
2022-12-13 20:58:14.313 T:3496 error <general>: Exception updating database Epg16 from version 13 to 16
2022-12-13 20:58:14.313 T:3496 error <general>: Error updating database Epg16 from version 13 to 16
Can someone who is having the myvideos119 to myvideos121 migration failure explicitly upload a copy of their myvideos119 sqlite db. If you want to email a download link to fuzzard at kodi.tv if you wish to keep it private.
We need a way to replicate the failure to try and resolve it. At this point in time the error line is a bit of code that's been in Kodi for 9 years. Has not been touched in nexus (or matrix for that fact).
Damn, by the time I read your message I had already deleted my old databases
I will try to upload the database from my kodi 19 machine (ubuntu) to the xbox to see if I can reproduce the problem.
uploading a MyVideos119.db from kodi 19 (ubuntu) into the xbox running kodi 20 rc1 worked, it does the db migration ok and keeps the progress and changes made into the library between reboots.
sorry that i couldn't provide a db
(2022-12-16, 15:15)megurrola Wrote: [ -> ]Hey, I don't know what would happen in your case, but in my case I uninstalled 20 RC, reinstalled, and all my settings and media database where lost.
Yes, uninstalling and reinstalling Kodi app (or any other app) cleans userdata too. I'm not sure why some people stills saying doesn't work.
Well it definitely did not do that for me a few days ago after the update from V19 to V20 failed and I couldn't run Kodi at all.
I uninstalled Kodi, re-installed it from the Microsoft store and then ran it and all of my settings and library were still there exactly as before (which I was initially extremely happy about).
Now my problem is of course that it is frozen in time and not saving any changes I make, presumably due to this database update issue.
I will try unintalling V20 and then re-installing and see if that clears everything this time.