Bug 136138

Summary: set as album thumbnail doesn't change the icon immediately
Product: [Applications] digikam Reporter: david ross <davidxross>
Component: Thumbs-AlbumAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal    
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: openSUSE   
OS: Linux   
Latest Commit: Version Fixed In: 0.9.0

Description david ross 2006-10-22 17:22:47 UTC 
Version:           0.9.0-beta3 (using KDE KDE 3.5.5)
Installed from:    SuSE RPMs
OS:                Linux

when setting an albums thumbnail the thumbnail is not changed until Digikam is restarted.

digikam: WARNING: [bool Digikam::AlbumDB::execSql(const QString&, QStringList*, bool)] sqlite_compile error: no such column: T.icon on query: SELECT B.url, I.name
 FROM Albums AS A
   LEFT OUTER JOIN Images AS I ON I.id=T.icon
   LEFT OUTER JOIN Albums AS B ON B.id=I.dirid
 WHERE T.id=14;
Comment 1 Marcel Wiesweg 2006-10-22 21:40:41 UTC 
SVN commit 598184 by mwiesweg:

Correct copy-and-paste mistake.
Oops, would have thought I had checked this twice.
Ok, it only affects changing the thumbnail.
Thanks for the report.

BUG: 136138


 M  +2 -2      albumdb.cpp  


--- trunk/extragear/graphics/digikam/digikam/albumdb.cpp #598183:598184
@@ -473,9 +473,9 @@
     QStringList values;
     execSql( QString("SELECT B.url, I.name \n "
                      "FROM Albums AS A \n "
-                     "  LEFT OUTER JOIN Images AS I ON I.id=T.icon \n "
+                     "  LEFT OUTER JOIN Images AS I ON I.id=A.icon \n "
                      "  LEFT OUTER JOIN Albums AS B ON B.id=I.dirid \n "
-                     "WHERE T.id=%1;")
+                     "WHERE A.id=%1;")
              .arg(albumID), &values );
     if (values.isEmpty())
         return QString();