Public bug reported:
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.
** Affects: katapult (Ubuntu)
Importance: Undecided
Status: Unconfirmed
--
Katapult is utilizing non-standard SQL which results in SQL errors in
PostgreSQL and other standards compiant DBMS'.
https://bugs.launchpad.net/bugs/120575
You received this bug notification because you are a member of Kubuntu
Team, which is a bug contact for katapult in ubuntu.
--
kubuntu-bugs mailing list
[EMAIL PROTECTED]
https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
