[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 caulier.gil...@gmail.com changed: What|Removed |Added Version Fixed In||5.8.0 Resolution|---

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #83 from Richard Mortimer --- (In reply to caulier.gilles from comment #82) > Richard, > > Can we close this file since last Maik fixes for Mysql support ? > > Gilles Caulier Gilles, Yes I think we can.

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #82 from caulier.gil...@gmail.com --- Richard, Can we close this file since last Maik fixes for Mysql support ? Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 se...@pdmi.ras.ru changed: What|Removed |Added CC||se...@pdmi.ras.ru -- You are receiving

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #81 from swatilodh...@gmail.com --- Hi Richard, Following issues have been fixed recently to ensure Tags works fine with MySQL support: 1) Removing _DigiKam_root_tag_ from Tags tree

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #80 from Richard Mortimer --- The only thing that I am aware of that potentially needs addressing in MySQL is the TagsTree support. I did note that there were some other issues addressing that so it may already

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #79 from swatilodh...@gmail.com --- Hi Richard Could you please suggest more needs to be done here, after your referential integrity patch has been implemented? Thanks -- You are receiving this mail because: You are watching all bug

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 swatilodh...@gmail.com changed: What|Removed |Added CC||richm+...@oldelvet.org.uk -- You are

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #78 from Richard Mortimer --- (In reply to swatilodha27 from comment #77) > Richard, > > I tested your patch for adding referential integrity constraints in 5.0.0 v8 > DB and it seems to work fine for me. > >

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #77 from swatilodh...@gmail.com --- Richard, I tested your patch for adding referential integrity constraints in 5.0.0 v8 DB and it seems to work fine for me. Thanks. -- You are receiving this mail because: You are watching all bug

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #76 from Richard Mortimer --- Created attachment 99908 --> https://bugs.kde.org/attachment.cgi?id=99908=edit Add referential integrity constraints to a 5.0.0 v8 database The 5.0.0 initial release database

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #75 from Richard Mortimer --- Created attachment 99907 --> https://bugs.kde.org/attachment.cgi?id=99907=edit Raw commands to perform a full MySQL v7 to v8 update These can be used to test upgrades from v7 to v8

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #74 from Richard Mortimer --- Created attachment 99906 --> https://bugs.kde.org/attachment.cgi?id=99906=edit Helper to remove bad data prior to upgrade fromMySQL v7 to v8 Take care using this and always make a

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #73 from Richard Mortimer --- Created attachment 99905 --> https://bugs.kde.org/attachment.cgi?id=99905=edit helper SQL command to detect invalid data in v7 MySQL databases running these commands against a v7

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #72 from Richard Mortimer --- Created attachment 99904 --> https://bugs.kde.org/attachment.cgi?id=99904=edit Sample digikam v7 schema Here is my v7 based (digikam 4.x) MySQL schema. This may be useful for

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #71 from Richard Mortimer --- Created attachment 99903 --> https://bugs.kde.org/attachment.cgi?id=99903=edit Additional schema modifications from MySQL v7 to v8 Changes that need to be made for MySQL v7 to v8

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #70 from swatilodh...@gmail.com --- (In reply to Richard Mortimer from comment #69) > (In reply to swatilodha27 from comment #68) > > Hello Richard. > > > > I guess then the only possible way is to reproduce every error reported by > > the

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #69 from Richard Mortimer --- (In reply to swatilodha27 from comment #68) > Hello Richard. > > I guess then the only possible way is to reproduce every error reported by > the end user and try to generate it.

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #68 from swatilodh...@gmail.com --- Hello Richard. I guess then the only possible way is to reproduce every error reported by the end user and try to generate it. Queries in relation to the points you mentioned for completing MySQL

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #67 from Richard Mortimer --- Apart from testing and fixing issues I am aware of the following tasks that need completing for MySQL support. 1) Test and refine the "Experiment with TagsTree tables" patch to

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #66 from Richard Mortimer --- (In reply to swatilodha27 from comment #63) > Hello Richard. > > I'm Swati, currently working on digiKam MySQL database support project. I > read this open bug for MySQL Schema

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #65 from Richard Mortimer --- (In reply to Felix Leif Keppmann from comment #62) > > currently I face the issue of not being able to completely delete > directories. Directories are deleted on disk, but not

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #64 from Richard Mortimer --- Apologies. Life has caught up with me a little these past months. Things are still busy but here are a few thoughts... -- You are receiving this mail because: You are watching all

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 swatilodh...@gmail.com changed: What|Removed |Added CC||swatilodh...@gmail.com --- Comment #63

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #62 from Felix Leif Keppmann --- Hello, currently I face the issue of not being able to completely delete directories. Directories are deleted on disk, but not deleted from the database, i.e., obsolete ghost

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #61 from caulier.gil...@gmail.com --- Richard, I started to write a test cases implementation for Mysql and tree-view. I need to fix some point of Mysql database settings, especially with internal database server that i will use for that.

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #60 from Richard Mortimer --- Gilles, Many thanks for the information and the testing feedback. I have not had much time to look into this yet. A quick look at the schema does indicate that there is a missing

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #56 from caulier.gil...@gmail.com --- Richard, How to test quickly your new patch #95928 exactly ? Gilles -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #57 from Richard Mortimer --- (In reply to caulier.gilles from comment #56) > How to test quickly your new patch #95928 exactly ? General testing of the tags functionality with a MySQL database. I'm not 100% sure

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #55 from Richard Mortimer --- Created attachment 95928 --> https://bugs.kde.org/attachment.cgi?id=95928=edit Experiment with TagsTree tables. Build a TagsTree2 file that mimics the existing behaviour of the

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #51 from caulier.gil...@gmail.com --- Git commit 5c1416f17b230a598b8938ee3a18bb31b65303d0 by Gilles Caulier. Committed on 02/12/2015 at 21:21. Pushed by cgilles into branch 'master'. Apply patch #95865 to rewrite MySQL database creation and

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 caulier.gil...@gmail.com changed: What|Removed |Added Attachment #95865|0 |1 is obsolete|

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 caulier.gil...@gmail.com changed: What|Removed |Added Attachment #95861|0 |1 is obsolete|

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 caulier.gil...@gmail.com changed: What|Removed |Added Attachment #95860|0 |1 is obsolete|

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #53 from caulier.gil...@gmail.com --- Git commit 3eefa0b7493ee7abb72d6532e618a3769e181e2f by Gilles Caulier. Committed on 02/12/2015 at 21:28. Pushed by cgilles into branch 'master'. Apply patch #95866 to force use of InnoDB engine with all

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 caulier.gil...@gmail.com changed: What|Removed |Added Attachment #95824|0 |1 is obsolete|

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #41 from caulier.gil...@gmail.com --- Git commit 9b543e6a84a15af6d29f70c39a4964992f42e7cf by Gilles Caulier. Committed on 01/12/2015 at 21:34. Pushed by cgilles into branch 'master'. Apply patch #95825 to : Allows the thumbnail and main

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 caulier.gil...@gmail.com changed: What|Removed |Added Attachment #95825|0 |1 is obsolete|

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #39 from Richard Mortimer --- Gilles, 1) I did not yet get chance to rebase the other two patches to separate those from the face and thumbnail patches. I will do so within the next day. 2) I started to look at

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 --- Comment #36 from Richard Mortimer --- Created attachment 95824 --> https://bugs.kde.org/attachment.cgi?id=95824=edit Standalone MySQL face recognition settings to FaceSettings table Update face recognition MySQL

[digikam] [Bug 355831] MySQL Schema Improvements

https://bugs.kde.org/show_bug.cgi?id=355831 Richard Mortimer changed: What|Removed |Added Attachment #95755|0 |1 is