[edrikk]

Hi,

I tried to dip my toe into the Krypton builds by trying out the July 10th nightly build for Windows (specficially KodiSetup-20160710-a6a8c5b.exe).
This was installed directly on top of 16.1 Jarvis on Windows 10 64bit, with all updates installed.

I am running MySQL 5.6.28, and my files are distributed partially on a local drive "M", and partially on an SMB Share named "NAS" in the attached log.

The issue I encountered is as follows:
- Clicking on "Movies" (on NAS) or "TV Shows" (Local) and clicking on any of the top row icons (such as Recently added, etc), results in a "Couldn't connect to network server".

However, if I go to Settings, click on "Media Sources" and browse to my NAS, the files are there, and they can be played.

Debug log (with a million errors) was too big for pastebin, and xbmclog seems to be having problems, so posted the debug log as a github gist:
https://gist.github.com/anonymous/3a683e...48305ab58e


Reverting back to 16.1 and all is back to "normal"

[edrikk]

I have created Trac Ticket 16802 --> http://trac.kodi.tv/ticket/16802

[helta]

are you sure you let Krypton upgrade your databases properly? Drop the krypton databases and let it upgrade again.

[edrikk]

Yeah I did that.

I installed it and saw that issue. I dropped the Krypton version databases and restarted Kodi, having it (again) upgrade the 16.1 database version. Exact same behaviour.

I agree on your thought process though given the behaviour. It is possible that the MySQL upgrade code has an issue (if there is not another issue that is)...

[jjd-uk]

I'm not sure how valid that specific build is as from the filename it seems like it could be an experimental test build that ended up in wrong folder on the mirrors, proper nightly builds should always include "master" in the filename.

[edrikk]

Thanks @jjd-uk
I thought your suggestion made perfect sense... I tried the next nightly which is "KodiSetup-20160711-e247a0d-master" but unfortunately, the exact same behavior is seen both visually, and within the log file...

[DaveBlake]

I also wonder if this report http://forum.kodi.tv/showthread.php?tid=281082 is related?

It would have been interesting to try an earlier nightly from the beginning of the month, may have been more stable.
Can you use php to check if MyMusic60 etc. did get created and populated from 56. It is not clear from the log if even this was successful.

[edrikk]

Thanks @DaveBlake

Finally got a chance to dig a bit, but unfortunately neither the July 1st build ( KodiSetup-20160701-7f6d5cd-master ) nor today's build ( KodiSetup-20160716-49a16ad-master ) showed any difference/positive results.

To answer your question, it *looks* like the DB is upgraded to V106, however, the log file contains

Code:

21:57:15 T:11664  NOTICE: Attempting to update the database MyVideos106 from version 99 to 106
21:57:15 T:11664   DEBUG: Mysql Start transaction
21:57:26 T:11664   DEBUG: Mysql execute: ALTER TABLE seasons ADD userrating INTEGER
21:57:27 T:11664   DEBUG: Mysql execute: CREATE TABLE rating (rating_id INTEGER PRIMARY KEY auto_increment , media_id INTEGER, media_type TEXT, rating_type TEXT, rating FLOAT, votes INTEGER) CHARACTER SET utf8 COLLATE utf8_general_ci
21:57:27 T:11664   DEBUG: MYSQL: Unknown field type: 173764992
21:57:27 T:11664   DEBUG: MYSQL: Unknown field type: 1095655237
21:57:27 T:11664   DEBUG: MYSQL: Unknown field type: 173764992
21:57:27 T:11664   DEBUG: MYSQL: Unknown field type: 1095655237
....
....
....                                 this is repeated 430 times (the combination...  So 860 lines total) until the below line
....
....
21:57:28 T:11664   DEBUG: Mysql execute: INSERT INTO rating(media_id, media_type, rating_type, rating, votes) VALUES (4883, 'movie', 'default', 0.000000, 0)
21:57:28 T:11664   DEBUG: Mysql execute: UPDATE movie SET c05=1 WHERE idMovie=4883
22:24:20 T:9652   DEBUG: Mysql execute: INSERT INTO rating(media_id, media_type, rating_type, rating, votes) VALUES (4884, 'movie', 'default', 0.000000, 0)
22:24:20 T:9652   DEBUG: Mysql execute: UPDATE movie SET c05=2 WHERE idMovie=4884
22:24:20 T:9652   DEBUG: Mysql execute: INSERT INTO rating(media_id, media_type, rating_type, rating, votes) VALUES (4885, 'movie', 'default', 0.000000, 0)
22:24:20 T:9652   DEBUG: Mysql execute: UPDATE movie SET c05=3 WHERE idMovie=4885

I tried digging into the VideoDatabase.cpp as it seems like there is an issue in with updating the "rating" and "votes" (they are pulled/stored as "0.00000" and "0" for all rows in the new table as also noted in the log, although my movies, episodes, etc do have ratings and votes for most records in their original pre-Krypton tables. There are 17 records with an empty votes record and 0.000000 in movies, but otherwise all have "real" data).

Nothing jumps out at me as being wrong in the upgrade code to process the new "rating" table, but maybe it's a MySQL interaction....




The second strange thing I noticed:

Code:

22:28:52 T:5328   ERROR: XFILE::CDirectory::GetDirectory - Error getting special://skin/playlists/inprogress_movies.xsp
22:28:52 T:10436   DEBUG: Thread JobWorker start, auto delete: true
22:28:52 T:9652    INFO: removing tempfiles
22:28:52 T:9652  NOTICE: CApplication::UpdateLibraries: Starting video library startup scan
22:28:52 T:9652  NOTICE: CApplication::UpdateLibraries: Starting music library startup scan
22:28:52 T:5328   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:28:52 T:5328   ERROR: XFILE::CDirectory::GetDirectory - Error getting videodb://recentlyaddedmovies/

The XFILE errors are very strange to me... I checked and the files are absolutely there, and the permissions appear ok... But the errors make sense given that the "right side" of Esturary is blank for the categories (see screen captures).

Notice in the below images that clicking on the "Recently Added Movies" icon takes me to the page "behind" the "Couldn't connect to network server" which also doesn't seem right (but which correlates with the error messages above...

[debennett2]

Has anyone made headway with this? I'd really like to upgrade to the newer Alphas but just can't.

[edrikk]

Just to get back to this thread.
I installed nightly build 20160725-2b8e204-master and all is well now. Looking at the commits, I would guess that the second round of DLL fixes (and pointing to correct location) maybe corrected the issue.

Will keep an eye out, but for now I'll also add this note to the ticket.

[debennett2]

Just to get back to this thread.
I installed nightly build 20160725-2b8e204-master and all is well now. Looking at the commits, I would guess that the second round of DLL fixes (and pointing to correct location) maybe corrected the issue.

Will keep an eye out, but for now I'll also add this note to the ticket.

Yeah I installed that and immediately had a odd loud sound playing at startup and an empty library. The last build that worked for me with MySQl was late May. I keep having to revert back to that build....

[edrikk]

If you have upgarded to Krypton, you'll likely have to delete all database versions that belong to Krypton, as I think all these issues resulted in DBs not being "upgraded" properly. Once they exist, the "bad" database would get upgraded to the next version up.

http://kodi.wiki/view/database_versions

So for videos, you'll need to delete 100 and above (inclusive)

[JoeySnackpants]

I am having this issue, I have Krypton v17 alpha running on a PC and an Android device... they both created different DBs in my mariaDB instance. MyVideos106 (PC) and MyVideos107 (Android). Why would the PC version and the Android version branch?