[ntropy]

I get this error when selecting the Albums tab in Kodi Remote for iOS controlling Kodi on Windows:

Code:

XBMC JSON-RPC Error: Internal error.
(Code: -32603)
Data: (null)

METHOD
AudioLibrary.GetAlbums

PARAMETERS
{properties=(year,thumbnail,artist,playcount);sort={"available_methods"={label=(Album,Artist,Year,"Playcount");method=(label,genre,year,playcount);};ignorearticle=0;method=label;order=ascending;};}


Code:

Here's my log:

https://paste.kodi.tv/ayudaqufem.kodi

This used to work before v19.   Help?

[Klojum]

This used to work before v19.   Help?

This doesn't help either.
2021-09-18 13:59:03.878 T:30064 ERROR <general>: SQL: [MyVideos119] Undefined MySQL error: Code (1064)

I've seen the error with other MariaDB instances, use the search option of the forum to find similar cases.

[ntropy]

I turned on debug in Kodi and tried the query which appeared in kodi.log when attempting to view albums in iOS and then connected to MyMusic82 using HeidiSQL to run the same query there and received a "Data too long for column 'instring' at row 1" in the HeidiSQL log: 

https://paste.kodi.tv/ogayakagar.kodi

[ntropy]

And when I search the forum for "Data too long for column 'instring' at row 1", this post comes up and nothing else.

[ntropy]

And here's the output of explain analyser:

https://mariadb.org/explain_analyzer/ana...t=HeidiSQL

But I don't see column instring here or in the query...

[ntropy]

searching MyMusic82 for instring locates it as part of udfNaturalSortFormat, which is part of the query for iOS app album view

[ntropy]

https://paste.kodi.tv/uluhuvaxov

 -- so is the query overloading it beyond its 256 character capacity and thus no albums appear in the iOS album view?

[Buschel]

https://paste.kodi.tv/uluhuvaxov

 -- so is the query overloading it beyond its 256 character capacity and thus no albums appear in the iOS album view?

I am not an expert in SQL. So I can only state that your problem still looks like a problem with SQL or the database on the Kodi server side. The iOS App itself does not receive results, but only this error statement. Therefore nothing is shown. Looks like this can only be fixed on Kodi server side.

[ntropy]

309 days (without Albums in Kodi Remote working) later....

(for future reference...)

opened /mnt/user/appdata/mariadb/custom.cnf (on unRAID)

added line:

sql_mode=NO_ENGINE_SUBSTITUTION

finally albums load again in Kodi Remote

Yikes.

Not sure what ill side effects this will cause.  Might be better to adjust size of instring, if only I knew how.

References:

https://stackoverflow.com/questions/5738...on-mariadb
https://www.reddit.com/r/unRAID/comments...the_mysql/  (no answer here, just thought I'd try custom.cnf instead.  It might not persist over reboots of unRAID for that matter.)

[ntropy]

According to tests made in HeidiSQL of the query, this Album Artist metadata caused the error:

Code:

Coro de monjes de la Abadía de Montserrat, Choralschola des Klosters Maria Einsiedeln, Choralschola der Benediktinerabtei Münsterschwarzach, Chœur des moines de l'Abbaye Notre-Dame de Fontgombault, Coro de monjes del Monasterio Benedictino de Santo Domingo de Silos, Cappella Musicale del duomo di Milano

Metadata came from Musicbrainz release at: https://musicbrainz.org/release/8da202f4...5575793d9a