Non-portable SQL statement in lib/Db/Maintenance.php

[stmichalke]

Commit 1b0ec6b uses a string comparison which doesn't work with PostgreSQL:
WHERE `key` = "scanning"
It should be 'scanning' because double quotes delimit column names, not string constants.

[frake65]

Actually, I think there are the following lines in file lib/Db/Maintenance.php which should be modified:
Line 34:
WHERE key = \'scanning\'';
Line 48:
WHERE key = \'scanning\'';
Line 61:
$sql = 'SELECT 1 FROM *PREFIX*music_cache WHERE key = \'scanning\'';

thank you!

[paulijar]

Thanks for the info, I didn't know this about PostgreSQL and majority of my testing has been on MariaDB and SQLite.

[paulijar]

I published a hotfix 2.1.1 fixing this issue.