Version: 0.8.1 (using KDE KDE 3.5.0) Installed from: Ubuntu Packages OS: Linux When trying to do a search with digikam 0.8.1 I've just upgraded from 0.8, I found no picture on my last search. I tried a very simple search (album with name containing "200") but found nothing. When I added a rating to pictures. the search was showing those picture, it seem that as long as a picture doesnt have a rating value (even if the rating is 0) in the ImageProperties table, this picture is invisible to the search tool.
Yes, for both quick and advanced searches.
SVN commit 505430 by toma: I'm very sorry I made the search as good as useless in 0.8.1. I hope this fixes this issue (thanks for the hint Maxime). Can anyone fonfirm that? BUG: 120479,120775 M +4 -4 digikamsearch.cpp --- branches/stable/extragear/graphics/digikam/kioslave/digikamsearch.cpp #505429:505430 @@ -136,7 +136,7 @@ // query head sqlQuery = "SELECT Images.id, Images.name, Images.dirid, Images.datetime, Albums.url " - "FROM Images, Albums, ImageProperties " + "FROM Images, Albums LEFT JOIN ImageProperties ON Images.id = Imageproperties.imageid " "WHERE ( "; // query body @@ -144,7 +144,7 @@ // query tail sqlQuery += " ) "; - sqlQuery += " AND (Albums.id=Images.dirid) AND (Images.id = ImageProperties.imageid); "; + sqlQuery += " AND (Albums.id=Images.dirid); "; QStringList values; QString errMsg; @@ -240,7 +240,7 @@ // query head sqlQuery = "SELECT Albums.url||'/'||Images.name " - "FROM Images, Albums, ImageProperties " + "FROM Images, Albums LEFT JOIN ImageProperties on Images.id = ImageProperties.imageid " "WHERE ( "; // query body @@ -248,7 +248,7 @@ // query tail sqlQuery += " ) "; - sqlQuery += " AND (Albums.id=Images.dirid) AND (Images.id = ImageProperties.imageid) "; + sqlQuery += " AND (Albums.id=Images.dirid) "; sqlQuery += " LIMIT 500;"; QStringList values;
SVN commit 505437 by toma: forwardport SVN commit 505430 by toma: I'm very sorry I made the search as good as useless in 0.8.1. I hope this fixes this issue (thanks for the hint Maxime). CCBUG: 120479,120775 M +4 -4 digikamsearch.cpp --- trunk/extragear/graphics/digikam/kioslave/digikamsearch.cpp #505436:505437 @@ -136,7 +136,7 @@ // query head sqlQuery = "SELECT Images.id, Images.name, Images.dirid, Images.datetime, Albums.url " - "FROM Images, Albums, ImageProperties " + "FROM Images, Albums LEFT JOIN ImageProperties ON Images.id = Imageproperties.imageid " "WHERE ( "; // query body @@ -144,7 +144,7 @@ // query tail sqlQuery += " ) "; - sqlQuery += " AND (Albums.id=Images.dirid) AND (Images.id = ImageProperties.imageid); "; + sqlQuery += " AND (Albums.id=Images.dirid); "; QStringList values; QString errMsg; @@ -240,7 +240,7 @@ // query head sqlQuery = "SELECT Albums.url||'/'||Images.name " - "FROM Images, Albums, ImageProperties " + "FROM Images, Albums LEFT JOIN ImageProperties on Images.id = ImageProperties.imageid " "WHERE ( "; // query body @@ -248,7 +248,7 @@ // query tail sqlQuery += " ) "; - sqlQuery += " AND (Albums.id=Images.dirid) AND (Images.id = ImageProperties.imageid) "; + sqlQuery += " AND (Albums.id=Images.dirid) "; sqlQuery += " LIMIT 500;"; QStringList values;
i'm using the latest build from svn (0.8.2 - rc1) and this issue is still disabling the search. ( fedora devel, compiled from sources )