[Digikam-devel] [digikam] [Bug 325655] MIGRATION : after MySQL to Sqlite database conversion, random tags are assigned to new images

via KDE Bugzilla bugzilla_noreply at kde.org
Thu Jul 21 18:31:37 BST 2016


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

--- Comment #5 from swatilodha27 at gmail.com ---
Thomas,

Foreign key constraint is now in DB schema (Current version 5.0.0), as a result
DB can't contain tags for non existing images.So,  I was unable to reproduce
this issue. 

Also, I used the SQL query to verify the same:
//
MariaDB [digikam]> select count(*) from ImageTags Left Join Images on
imageid=id where id is Null;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.01 sec)
//

The result was 0 even for ImageMetadata and ImageInformation tables.

Please try with the recent version again, and report updates if any.

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



More information about the Digikam-devel mailing list