Hello,
so everything was working fine with my tv and NAS, and i could go up to 4K
Then the TV updated to codi19 matrix.
Big problems..it does not play the movies any more..
When I look in kodi to the files, they are all there, click on it kodi stops.
library is empty under movies and TV shows and I can not ad them.
The database is running on the NAS and intact.
So the problem had to be ( I think) something to do with the rights on the shares
It's running under NFS
I was thinking a lot of people would have the same problem, googled it and did not find a solution.
Is it a bug..wait on kodi 19.1?
Is it known here what the problem is?
Is there a solution?
Thanks in advance I hope
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
ok...but it is running on my tv, so i have to figure out how to get that file from the tv to my pc.....
install some file manager, copy it to USB or create network share.
working on it... come back on it later, thanks both.
Ok , i updated kodi on my pc to version 19...
same problem..
music can be played
movies and tv shows stay empty.
I tried to fill the library, not working still empty
used the same advancedstettings.xml and sources.xml that worked with version 18
See a lot of people on the internet, same problem with matrix/nas no fix.
https://paste.kodi.tv/kikojimora.kodi
just to recap..
i see the movies when I go to media, movies, all the info is there... so in my opinion database is ok.
but when i click on a movie there kodi goes down and stops.
There is no way i can fill the library.
(2021-03-25, 18:18)stapper56 Wrote: [ -> ]so in my opinion database is ok.
...
There is no way i can fill the library.
Your database upgrade is still problematic in your latest log file:
Code:
2021-03-25 17:04:49.925 T:6796 INFO <general>: Attempting to update the database MyVideos119 from version 116 to 119
2021-03-25 17:04:49.925 T:6796 DEBUG <general>: Mysql Start transaction
2021-03-25 17:04:49.929 T:6796 DEBUG <general>: Mysql execute: ALTER TABLE path ADD allAudio bool
2021-03-25 17:04:49.930 T:6796 ERROR <general>: SQL: [MyVideos119] Undefined MySQL error: Code (1060)
Query: ALTER TABLE path ADD allAudio bool
2021-03-25 17:04:49.930 T:6796 ERROR <general>: Exception updating database MyVideos119 from version 116 to 119
2021-03-25 17:04:49.930 T:6796 ERROR <general>: Error updating database MyVideos119 from version 116 to 119
2021-03-25 17:04:49.930 T:6796 DEBUG <general>: Mysql rollback transaction
2021-03-25 17:04:49.931 T:6796 DEBUG <general>: dbiplus::MysqlDatabase::connect replacing configured host 192.168.0.22 with resolved host 192.168.0.22
2021-03-25 17:04:49.933 T:6796 ERROR <general>: Unable to open database: MyVideos118 [1049](Unknown database 'MyVideos118')
2021-03-25 17:04:49.933 T:6796 DEBUG <general>: dbiplus::MysqlDatabase::connect replacing configured host 192.168.0.22 with resolved host 192.168.0.22
2021-03-25 17:04:49.935 T:6796 ERROR <general>: Unable to open database: MyVideos117 [1049](Unknown database 'MyVideos117')
2021-03-25 17:04:49.935 T:6796 DEBUG <general>: dbiplus::MysqlDatabase::connect replacing configured host 192.168.0.22 with resolved host 192.168.0.22
2021-03-25 17:04:49.938 T:6796 INFO <general>: Old database found - updating from version 116 to 119
2021-03-25 17:04:49.939 T:6796 ERROR <general>: SQL: Can't create database for copy: 'MyVideos116' (1007)
2021-03-25 17:04:49.939 T:6796 ERROR <general>: Unable to copy old database MyVideos116 to new version MyVideos119
question is, is that my database that is causing that problem or Kodi 19?
I used the same advancedsettings.xml and sources.xml as for kodi 18...
No problems at all...those started after the updates everything was working
ans I see a lot of people with the same problem...
(2021-03-25, 21:50)stapper56 Wrote: [ -> ]ans I see a lot of people with the same problem...
MYSQL: Connected to version 10.3.21-MariaDB
MariaDB 10.5 is current now. Any chance you can upgrade a bit? MariaDB has had its quirks, but an ALTER TABLE query should not be problematic unless there is a bug in the upgrade script. Which in turn is doubtful because otherwise there would be so many more people with an identical problem.
The advancedsettings.xml file has nothing to do with this.
Alternatively, you could try to get a Kodi 18 client running again with the MyVideos116 database. Then do a Video Library Export, so all metadata and watched/resume statuses are safed.
Then rename your MyVideos116 database to something temporary as well as drop the current MyVideos119, and restart Kodi for a clean new database. Rescrape your media collection directly into MyVideos119 with the exported metadata.
That sounds complicated...
maria Db just got an update...
Question... if I delete the databases, my music 72, my music 82, my videos116, myvideos119?
The do a new clean install with kodi19, then it will make new databases right?
I have 300 movies over there, but remember what is saw, and i do not use kodi for music, so that is not a loss.
Then follow this tutorial
https://www.youtube.com/watch?v=Plpaw1hlpWg
Then kodi will have the right databases again and works?
best regards, and thanks for the help
jan.
300 movies is a relative small movie collection. You could also rename your video database (using PHPMyAdmin or some other MySQL tool), and then restart Kodi to have a new set of databases created. No need to reinstall Kodi itself.
Music72 and Videos116 are from Kodi 18, the others are from Kodi 19.
Btw, I didn't watch the YT tutorial.. TL;DW.
You sir, are a genius and officially made my day
I deleted all the databases of kodi...
Started kodi, that took some time to make new databases, did a scan of the first directorie ( movies ).
And the they are....
back on track again... Thanks mate !!!!!