2020-02-26, 17:43
(2020-02-26, 10:38)DaveBlake Wrote: The debug log shows the import failing, but "Undefined MySQL error: Code (1242)" sadly does not tell me anything. And there is nothing wrong with the SQL that I can see, at least the same command runs on both MySQL and SQLite.Heidi export link: https://wetransfer.com/downloads/f954fa2...232/174bbe
The only way for me to progress is to have your album and songtable data too and try testing against that. Unfortunately with MariaDB/MySQL it is not as easy as just passing the db file. @ntropy do you know how to export data from tables in a MariaDB? If you can provide the song and album tables (or the full db) using something like HeidiSQL then that would be great, otherwise I will try to get some simple instructions for you.