Bug 132886 - rescan collection: no such column: true
Summary: rescan collection: no such column: true
Status: RESOLVED NOT A BUG
Alias: None
Product: amarok
Classification: Applications
Component: Collections/Local (show other bugs)
Version: unspecified
Platform: Debian testing Linux
: NOR normal
Target Milestone: ---
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-23 23:20 UTC by Sjoerd
Modified: 2007-05-10 20:47 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Sjoerd 2006-08-23 23:20:40 UTC
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.
Comment 1 Kevin Funk 2007-05-10 20:24:24 UTC
Still valid?
Comment 2 Sjoerd 2007-05-10 20:42:40 UTC
I am no longer using Amarok, so I can not reproduce this bug.
Comment 3 Kevin Funk 2007-05-10 20:47:33 UTC
Ok, thank you; closing.