Version: 1.4-SVN (23-8-2006) (using KDE KDE 3.5.3) Installed from: Debian testing/unstable Packages Compiler: gcc-4.0 OS: Linux When I do Tools > Rescan collection, I get the following errors: amarok: [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)] sqlite3_compile error: amarok: [CollectionDB] [ERROR!] no such column: false amarok: [CollectionDB] [ERROR!] on query: SELECT DISTINCT artist.name,LOWER( artist.name) as __discard FROM tags LEFT JOIN artist ON artist.id=tags.artist WHERE true AND tags.sampler = false AND tags.deviceid IN (1,2,-1) ORDER BY LOWER( artist.name ) ; amarok: [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)] sqlite3_compile error: amarok: [CollectionDB] [ERROR!] no such column: true amarok: [CollectionDB] [ERROR!] on query: SELECT DISTINCT artist.name FROM tags LEFT JOIN artist ON artist.id=tags.artist WHERE true AND tags.sampler = true AND tags.deviceid IN (1,2,-1) LIMIT 1 OFFSET 0 ; I use PostgreSQL 7.4 as the database backend. I have no directories selected as my collection. After I selected some directories, it worked as it should.
Still valid?
I am no longer using Amarok, so I can not reproduce this bug.
Ok, thank you; closing.