[digikam] [Bug 382732] New: Ignore or[han rows in MySQL migration

[bugzilla_noreply]

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

            Bug ID: 382732
           Summary: Ignore or[han rows in MySQL migration
           Product: digikam
           Version: 5.7.0
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database-Migration
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Previous versions of the MySQL digikam database schema did not enforce
referential integrity and hence can have inaccessible orphan rows in the
database.

During migration digikam needs to take care to ignore these rows so that the
migration can continue without manual cleanup of the original MySQL database
first.

I have a patch against current git. This has been tested using the 5.7.0 and
5.6.0 pre-release app images during a migration of my digikam 4.x MySQL data to
5.x digikam.

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

[bugzilla_noreply]

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

Richard Mortimer <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Ignore or[han rows in MySQL |Ignore orphan rows in MySQL
                   |migration                   |migration

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

[bugzilla_noreply]

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

--- Comment #1 from Richard Mortimer <[hidden email]> ---
Created attachment 106864
  --> https://bugs.kde.org/attachment.cgi?id=106864&action=edit
Ignore orphan rows in MySQL migration

This can be tested on an existing digikam installation by replacing
/usr/share/digikam/database/dbconfig.xml with a patched copy and then
restarting digikam.

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

[bugzilla_noreply]

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

Maik Qualmann <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |5.7.0
      Latest Commit|                            |https://commits.kde.org/dig
                   |                            |ikam/a791ee52e031403067ca5d
                   |                            |ea709c86f5f61f2371
         Resolution|---                         |FIXED
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #2 from Maik Qualmann <[hidden email]> ---
Git commit a791ee52e031403067ca5dea709c86f5f61f2371 by Maik Qualmann.
Committed on 04/08/2017 at 19:41.
Pushed by mqualmann into branch 'master'.

apply patch #106864 from Richard Mortimer to ignore orphan rows in MySQL
migration
FIXED-IN: 5.7.0

M  +4    -3    NEWS
M  +40   -16   data/database/dbconfig.xml.cmake.in

https://commits.kde.org/digikam/a791ee52e031403067ca5dea709c86f5f61f2371

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