Top 100 Albums fails (SQL error) on MySQL
#2
Thanks @htpcero for the log and for investigating the SQL problem. Yes v19 has different queries from previous versions - it does the sorting for limited queries efficiently in the database (allowing for articles, natural number order and collation) rather than grab every thing into memory and do it there. Sometimes I can post SQL in threads, sometimes it triggers a Cloudflare alert as a SQl injection protection.

I had expected any SQL error to appear in the log, there were changes to the logging system in v19 so perhaps that is why it didn't. Humm.... something to watch for.

No need for Github issue, I'm the dev to fix it and I'm here Smile
Reply


Messages In This Thread
RE: Top 100 Albums fails (SQL error) on MySQL - by DaveBlake - 2021-04-05, 10:43
Logout Mark Read Team Forum Stats Members Help
Top 100 Albums fails (SQL error) on MySQL0