(2021-12-28, 10:02)mara.pavelka Wrote: You're right, it definitely looks like a problem with the existing database. Or with the container, because I tried deleting and recreating the relevant databases for Kodi, but that didn't help.

Now I tried using the newly installed container from official mariadb and everything works fine.

sql:
 SELECT art_id,url FROM art WHERE media_id=271 AND media_type='movie' AND type='thumb';

sql:
+--------+-------------------------------------------------------------------------------------------------------------------------------+

| art_id | url                                                                                                                           |

+--------+-------------------------------------------------------------------------------------------------------------------------------+

|  15235 | image://video@smb%3a%2f%2fOMV5%2fFilmy3%2fFilmy%20HD%202%2fOld%20Henry%20(2021)%2fOld.Henry.2021.1080p.WEBRip.DD5.1.x264.mkv/ |

+--------+-------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.03 sec)

Quote:/* Connecting to 192.168.1.3 via MariaDB (TCP/IP), username xbmc, using password: Yes ... */
SELECT CONNECTION_ID();
/* Connected. Thread-ID: 178 */
/* Characterset: utf8mb4 */
SHOW STATUS;
SELECT NOW();
SHOW VARIABLES;
USE `MyVideos116`;
SELECT art_id,url FROM art WHERE media_id=271 AND media_type='movie' AND type='thumb';
/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 1 query: 0.000 sec. */

(2021-12-31, 21:48)CaptainTivo Wrote: My question is: why?  I mean, why would changing a parameter on the database server affect the Kodi (client)?  Especially since the Kodi installs on the PC's still worked?

(2021-12-31, 21:48)CaptainTivo Wrote: Does this mean anything?

(2021-12-31, 21:48)CaptainTivo Wrote: Also, (and this may be a question for Unraid experts) will the "fix" of editing the custom.cnf file persist?

Quote:Because the query is run on the server, not the client.  The client just gets returned the result.

(2021-12-28, 18:00)black_eagle Wrote: Do I take it that using the official container is a solution you're happy with ?

Quote:MyVideos116.episode_view                           OK
MyVideos116.movie_view                             OK
MyVideos116.musicvideo_view                        OK
MyVideos116.season_view                            OK
MyVideos116.tvshow_view                            OK
MyVideos116.tvshowcounts                           OK
MyVideos116.tvshowlinkpath_minview                 OK
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
MyVideos107.uniqueid                               OK
MyVideos107.writer_link                            OK
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK
root@b26ff4f84b66:/# 

(2022-02-26, 20:42)CaptainTivo Wrote: There is still one mystery though: why did my PC Kodi clients still work after the update and all my Android clients failed?  After all, the problem was with the actual database and the inability of that version of mariadb to use that database without the update.  I would still like and answer to that question.

(2022-03-03, 19:08)DaveBlake Wrote: Glad you found the MariaDB issue and solved this @CaptainTivo

(2022-02-26, 20:42)CaptainTivo Wrote: There is still one mystery though: why did my PC Kodi clients still work after the update and all my Android clients failed?  After all, the problem was with the actual database and the inability of that version of mariadb to use that database without the update.  I would still like and answer to that question.

The differences in Windows and Android are many... My guess would be it was related to the MariaDB connector DLL that sits client side, these will be different implementations on Windows and Android. One coped with whatever way the server side of things was different while the other didn't. This kind of server version, hardware, OS variation is one reason why MariaDB/MySQL use in Kodi remains labelled as "experimental", there is just no way we could take on testing all the possible system combinations.