2018-02-16, 09:32
(2018-02-16, 07:30)HeresJohnny Wrote: MySQL 5.7 here.
Sorry, it looks like debugging was not saved between updates the last time. I've made sure it's on this time. Since my music collection is huge I'd really like to avoid dropping the schema for the third time.
Here's a debug log of #204
https://pastebin.com/EpKjrXMY
And here's a debug log of #215, I updated immediately after taking the above log, no other changes.
https://pastebin.com/ce6FPQr2
Ah, ok - so your MyMusic70 database is accessible by #0204 (with mysql connector) but not by #0205+ (with mariadb connector)? Sorry I thought this was a migration issue. It's very unusual for Kodi to fail with such a basic query, but this might suggest the MariaDB connector is not compatible with your server.
How is your MySQL server configured, have you changed any settings from their default? Maybe there is a conflict between Maria and this version of MySQL (it's fine with 5.5.21 that I'm using). Sigh.