[Digikam-devel] [digikam] [Bug 327957] Text Filter Returns All Videos Regardless of String

[Gilles Caulier]

https://bugs.kde.org/show_bug.cgi?id=327957

--- Comment #7 from Gilles Caulier <caulier.gilles at gmail.com> ---
So, i suspect that something is wrong in your database file to identify type
mime of your video file.

With Sqlite3 command line tool, look in digiKam database file "digikam4.db" the
type mime of you MOV video file :

SELECT DISTINCT Images.id, Images.name, Images.album, ImageInformation.rating,
Images.category, ImageInformation.format, ImageInformation.creationDate,
Images.modificationDate, Images.fileSize, ImageInformation.width,
ImageInformation.height FROM Images INNER JOIN ImageInformation ON
Images.id=ImageInformation.imageid WHERE Images.status=1 AND
Images.name="RIA_P_1753.MOV";

With my DB it return this :

[gilles at localhost GILLES]$ sqlite3 digikam4.db 
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> SELECT DISTINCT Images.id, Images.name, Images.album,
ImageInformation.rating, Images.category, ImageInformation.format,
ImageInformation.creationDate, Images.modificationDate, Images.fileSize,
ImageInformation.width, ImageInformation.height FROM Images INNER JOIN
ImageInformation ON Images.id=ImageInformation.imageid WHERE Images.status=1
AND Images.name="DSCF1010.MOV";
2286|DSCF1010.MOV|75|-1|2|MOV|2012-12-22T19:44:00|2012-12-22T19:44:00|128137088|1920|1080
sqlite> 

Look like the 6nd column is the type mime, and must be MOV in your case.

If it's not the right type mime, In digiKam select you mov file, go to
Image/Reread metadata... entry menu, and try to filter album again.

Gilles Caulier

-- 
You are receiving this mail because:
You are the assignee for the bug.