[Digikam-devel] db upgrade verification (fwd)

[Renchi Raju]

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