[Digikam-devel] db upgrade verification (fwd)

[Renchi Raju]

On Tue, 7 Jun 2005, Laurent Rathle wrote:

> Le Mardi 7 Juin 2005 01:28, Renchi Raju a écrit :
>> don't know why my email client prefers to reply to sender instead of list.
>> fwding to list
>
> There is still a problem. I can't see any of my pictures. I've run digikam
> with gdb :
>
> (gdb) exec /opt/digikam/bin/digikam
> (gdb) run
> Starting program: /opt/digikam/bin/digikam
> Using host libthread_db library "/lib/tls/libthread_db.so.1".
> [Thread debugging using libthread_db enabled]
> [New Thread -1235851584 (LWP 29407)]
> QSettings: failed to open file '/etc/qt_plugins_3.3rc'
> digikam: Count all files took: time taken: 148 ms
> digikam: Finding Missing Items: time taken: 118 ms
> 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;
> digikam: WARNING: [bool AlbumDB::execSql(const QString&, QStringList*, bool)]
> sqlite_compile error: no such column: Tags.icon on query: SELECT id, pid,
> name,
> (SELECT Albums.url||'/'||Images.name FROM Images, Albums
>  WHERE Images.id=Tags.icon AND Albums.id=Images.dirid),
>  iconkde FROM Tags;

can you do the following:

sqlite3 ~/tmp/renchi/Pictures/digikam3.db
sqlite> select * from sqlite_master WHERE type="table";

and mail the output

renchi