dK 5.7.0 Error converting database (haar matrix)

[Gilles Caulier]

All the bundles are now updated online at usual place :

https://files.kde.org/digikam/

Gilles Caulier

2017-12-05 12:40 GMT+01:00 Gilles Caulier <caulier.gilles at gmail.com>:

> This evening i will restart the bundle 5.8.0 pre release process to be
> able to test with current implementation.
>
> Best
>
> Gilles Caulier
>
> 2017-12-05 12:31 GMT+01:00 Maik Qualmann <metzpinguin at gmail.com>:
>
>> I'll try with my English. I think that the current implementation solves
>> all
>> problems. I can now migrate my old SQLite database in circle without
>> losing
>> data, and it also deletes invalid entries. If we filter albums and
>> images, we
>> would have to check all of the following tables against the same
>> filtering,
>> otherwise they would fail when inserted into the target database. I
>> bypass the
>> problem of using INSERT IGNORE to automatically drop invalid entries.
>>
>> Maik
>>
>> Am Montag, 4. Dezember 2017, 16:33:09 CET schrieb Richard Mortimer:
>> > Hi,
>> >
>> > I haven't had chance to check yet but suspect a number of the original
>> > failure scenarios that we had with MySQL to MySQL migration have been
>> > broken by the recent changes.
>> >
>> > It now seems to be only checking for the presence of associated images
>> > in the old database. We have see issues involving images that no longer
>> > had an associated Album or even images in Albums where the Album Root
>> > had been deleted. The query logic that protected against that should
>> > have been directly transferable to SQLite (indeed I was planning on
>> > testing that when my laptop died a few months back). I got my laptop
>> > mended a short while ago and will try to see how the latest changes cope
>> > with my old digikam 4 databases.
>> >
>> > Regards
>> >
>> > Richard
>> >
>> > On 04/12/2017 14:19, Gilles Caulier wrote:
>> > > Hi,
>> > >
>> > > A lots of work have be done to next 5.8.0 about Mysql support and
>> > > migration tool. The current pre-release AppImage bundle can be tested
>> here
>> > > :
>> > >
>> > > https://files.kde.org/digikam/
>> > >
>> > > Gilles Caulier
>> > >
>> > > 2017-12-04 14:33 GMT+01:00 J Albrecht <heviiguy at gmail.com
>> > >
>> > > <mailto:heviiguy at gmail.com>>:
>> > >     I’ve tried to convert my database from SQLite to MySQL twice. Both
>> > >     attempts appeared to be going well until approximately 75% into
>> the
>> > >     process. At those times, they failed with the following dialogue:
>> > >
>> > >     Error while converting the database. Details: Cannot add or
>> update a
>> > >     child row: a foreign key constraint fails
>> > >     (`digikam`.`ImageHaarMatrix`, CONSTRAINT `ImageHaarMatrix_Images`
>> > >     FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE
>> CASCADE
>> > >     ON UPDATE CASCADE)
>> > >
>> > >     Any idea how I might be able to overcome this critical issue?
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20171205/35c0e9fe/attachment.html>