[Digikam-devel] [Bug 185915] Album View: "Created" time of video set to "00:00"

Marcel Wiesweg marcel.wiesweg at gmx.de
Tue Mar 3 20:59:06 GMT 2009


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





--- Comment #5 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-03-03 21:59:06 ---
The SQL above affects all your video files; this will only affect the files
with missing creationDate, but I'm not sure if it catches the files:

UPDATE Images SET modificationDate=null WHERE id in (SELECT id FROM Images LEFT
JOIN ImageInformation ON id=imageid WHERE creationDate=NULL);

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Digikam-devel mailing list