Posts: 5
Joined: Mar 2018
Reputation:
0
2018-03-12, 02:50
(This post was last modified: 2018-03-12, 02:52 by NikkoDuCO007.)
Hello,
I cannot access my Movie library. I was changing a score on a movie, when Kodi failed...
Now when I try to access my library, nothing shows up. I tried to remove the sources, and start over. Did not do anything.
From my phone (Kodi Remote) I still can see the movies (cached I assume) and launch them from there. However when I try to update the list, there is an SQL error...
I am no expert at all this by any means, but I believe the db file has errors... At least for the movie part. The TV Shows are just working fine.
Any idea?
Thanks a bunch!
Posts: 5
Joined: Mar 2018
Reputation:
0
2018-03-12, 22:03
(This post was last modified: 2018-03-12, 22:07 by NikkoDuCO007.)
I run Kodi on a RPi 3.
Looking at the database with a tool like MySQL Spy, I get the following error: database disk image is malformed - when I am trying to access movie_view (Views).
An integrity check of the database indicates that 3 rows are missing in the index ix_path.
I tried to recreate the indexing, but I am not an expert at SQL stuff...
I know about the Watched/Unwatched thing! I wish it was that simple...! ;-)
I'll look into the logs later today and will send them to you.
Thanks for your reply and help!
Posts: 17,855
Joined: Jan 2011
Reputation:
1,055
Milhouse
Retired Team-Kodi Member
Posts: 17,855
Check you haven't run out of disk space - connect with ssh and run "df -h | pastebinit" and post the link.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Posts: 5
Joined: Mar 2018
Reputation:
0
I have tons of space!
Thanks!
Posts: 5
Joined: Mar 2018
Reputation:
0
Don't get mad at petty things...
I have checked the obvious. I am aware that "the obvious" is not the same for everyone.
Enjoy your expertise!
Posts: 17,855
Joined: Jan 2011
Reputation:
1,055
Milhouse
Retired Team-Kodi Member
Posts: 17,855
2018-03-13, 04:39
(This post was last modified: 2018-03-13, 04:42 by Milhouse.)
Not mad, but you're just wasting everyone's time by second guessing those that are trying to help you.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.