Problems converting from sqlite to mysql

[Alessandro Dentella]

Hi,

I have been using digikam for several years with great
satisfaction. Thanks for this awesome peace of software.

Now I decided to mygrate to network storage to share the same
collections from several devices and i'm running into several
problems.

My prevous installation is a 4.4.5 my current installation is 5.2.
I started from the previous digikam4.db and tried to convert using the
5.2 instance but it doesn't finish the job. The reason is that the
sqlite db has many foreign key that are broken.

I decided to convert by hand the database. It's been long but at the
end I got all data in mysql. The problem starts now. I attach the
network connection and it doesn "see" the images, if I lanch a second
time digikam complains that "The database is not Valid: the DBVersion
settings does not exists"

At this point I realized that digikam has altered all albums id and
nullified all album fields of Images instances.

Please let me know which is the correct path from sqlite to mysql.
What is the check it does on DbVersion: can I fix that?


thanks in advance
sandro

[Gilles Caulier-4]

Hi,

The Album duplication is certainly due to wrong collection path encoding issue reported in bugzilla and only fixed with 5.3.0.

You have certainly a database backup to re-start the conversion. Please try again with current 5.3.0, using AppImage bundle available here :

https://drive.google.com/open?id=0BzeiVr-byqt5Y0tIRWVWelRJenM

Take a care that one version is for Linux 32 bits and one others for Linux 64 bits. AppImage do not install anything on your computer. It's a stand alone version, which must work on all Linux.

Best

Gilles Caulier

2016-11-06 2:44 GMT+01:00 Alessandro Dentella <[hidden email]>:

Hi,

I have been using digikam for several years with great
satisfaction. Thanks for this awesome peace of software.

Now I decided to mygrate to network storage to share the same
collections from several devices and i'm running into several
problems.

My prevous installation is a 4.4.5 my current installation is 5.2.
I started from the previous digikam4.db and tried to convert using the
5.2 instance but it doesn't finish the job. The reason is that the
sqlite db has many foreign key that are broken.

I decided to convert by hand the database. It's been long but at the
end I got all data in mysql. The problem starts now. I attach the
network connection and it doesn "see" the images, if I lanch a second
time digikam complains that "The database is not Valid: the DBVersion
settings does not exists"

At this point I realized that digikam has altered all albums id and
nullified all album fields of Images instances.

Please let me know which is the correct path from sqlite to mysql.
What is the check it does on DbVersion: can I fix that?


thanks in advance
sandro