[Digikam-devel] db upgrade verification (fwd)

Renchi Raju renchi at pooh.tam.uiuc.edu
Tue Jun 7 01:50:23 BST 2005



On Mon, 6 Jun 2005, Renchi Raju wrote:

>> digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*, 
>> bool)]
>> sqlite_compile error: no such column: Albums.icon on query: SELECT id, url,
>> date, caption, collection,
>>   (SELECT name FROM Images WHERE Images.id=Albums.icon)
>>   FROM Albums;

i think i have figured out what's wrong. the above is a case of a 
correlated subquery and support for it was added only after sqlite 3.1. 
the latest release is sqlite 3.2.1

let me think about it and see what can be done.

renchi




More information about the Digikam-devel mailing list