[Digikam-devel] [digikam] [Bug 345025] New: Wrong sql statement updating thumbnail modification date

[Alvaro Soliverez]

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

            Bug ID: 345025
           Summary: Wrong sql statement updating thumbnail modification
                    date
           Product: digikam
           Version: 4.7.0
          Platform: Archlinux Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
          Assignee: digikam-devel at kde.org
          Reporter: asoliverez at kde.org

While going through slow queries in my MySQL server, I found this query.


UPDATE Thumbnails SET modificationDate=43102 WHERE id='2014-07-13 23:41:14'

There are several more examples of it. It looks like modificationDate and id
got swapped.
Of course, the id is invalid and results in id=2011 being updated.

I tried to find the piece of code responsible to provide a patch, but I
couldn't find it.



Reproducible: Always

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