Image 01
profile-image

jdm33

Jon Moon
Smart DJ

Amarok 1.x Scripts by RuddO 66 comments

Hi,

Nice work - I'd been wondering whether something like this was possible for a while.

To get the script (v 0.3.6) working though, I had to hack the script to replace SQL uses of GREATEST/LEAST with MAX/MIN as GREATEST/LEAST don't seem to be supported by my DB backend.

I think my backend is sqlite, but it doesn't actually look as though amarok links the sqlite library in so I'm getting confused. Certainly I debugged the problem by trying out the SQL sql from the log file in sqlitebrowser and that told me that 'GREATEST'/'LEAST' aren't recognized.

Is it possible to fix this or is there some major headache here with different DBs supporting different SQL variants? - Nov 26 2005