dK 5.7.0 Error converting database (haar matrix)

[J Albrecht]

Thanks for your comments Giles.

Perhaps I don’t even need the MySQL database?

I’m trying to establish a shared database on my home server so that other users on other boxes will have the same access on their machines. Is there a “good” way of doing this other than relying on MYSQL?  Or, should I simply dump all remnants of the existing dK installation (including configs etc) and reinstall using MySQL from the beginning?

Additional insight/direction is welcome and appreciated!




> On 04 Dec 2017, at 09:19, Gilles Caulier <caulier.gilles at gmail.com> 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/ <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/20171204/aa9c855b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 455 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20171204/aa9c855b/attachment.sig>