Katapult is utilizing non-standard SQL which results in SQL errors in PostgreSQL and other standards compiant DBMS'.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
katapult (Ubuntu) |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Set your amarok to use a PostgreSQL database (I'm using 8.2), import your library, and then try to get katapult to work with a music track. Notice that it doesn't show anything.
Watch your postgresql logs and you'll see errors such as:
2007-06-15 08:53:38 CDT STATEMENT: SELECT a.name, t.title, t.deviceid, d.lastmountpoint, t.url, i.path, album.name FROM tags t LEFT JOIN statistics s ON t.url = s.url AND t.deviceid = s.deviceid LEFT JOIN artist a ON t.artist = a.id LEFT JOIN album ON t.album = album.id LEFT JOIN images i ON ( a.name = i.artist AND album.name = i.album) LEFT JOIN devices d ON t.deviceid = d.id WHERE 1 AND (t.title LIKE "%Doc/F%" OR a.name LIKE "%Doc/F%") ORDER BY a.name, t.title, s.percentage DESC
2007-06-15 08:53:39 CDT ERROR: column "%Doc/F/%" does not exist at character 372
This is because double-quotes are being used in the SQL generated by Katapult when single-quotes are the standard for string literals in SQL.
Changed in katapult: | |
assignee: | nobody → mez |
status: | New → Fix Committed |
Changed in katapult: | |
status: | Fix Committed → Fix Released |
Here's a patch that fixes this issue for me. I recommend that we have somebody running MySQL and somebody running SQLite try this patch out as well.