| Summary: | digikam3 database is not imported | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | hagg |
| Component: | Database-Sqlite | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | RESOLVED DOWNSTREAM | ||
| Severity: | normal | CC: | caulier.gilles |
| Priority: | NOR | ||
| Version: | 1.1.0 | ||
| Target Milestone: | --- | ||
| Platform: | Gentoo Packages | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | 1.2.0 | |
| Sentry Crash Report: | |||
|
Description
hagg
2010-02-15 21:41:54 UTC
When did you upgrade the first time from 0.9: Now or with an older version? In which folder is your digikam3.db? Was a digikam4.db in the same folder at the first start after upgrading? First upgrade was with digikam-0.10.0 which did not work, then i tried with 1.1.0. In between i removed the newly created digikam4.db and replaced the digikam3.db with a copy i did before any upgrade. After the upgrade i had both, a digikam3.db and a digikam4.db in the folder.
The original location of digikam3.db was on a NFS share. Then i discovered that this might be a problem. I copied the digikam3.db to a local directory and did the import from this directory, e.g. specifying the local directory as the database location. Same result.
The first run wizard has two choices:
1. use the old digikam3.db
after this i have a digikam4.db and a digikam3.db
2. create a new database
after this i have a digikam4.db and a
digikam3.db-backup-2010-02-17T23:43:59
with the 1. option i see some more things in the reporting window such as
...
database copied
...
So the import somehow seems to start. But then looking at the digikam4.db (.dump Tags) my tags are not there. However, there are 2 tags listed, maybe from tags that are stored in the pictures.
Well something is going wrong here, and I suspect your digikam3.db is not found by the updating process, because neither the Tags nor the ImageTags table is touched by the upgrade procedure. Please note that digikam3.db always needed to be in the same directory as the contained pictures. Please check the path of the 0.9 collection and the "Album Path" and "Database File Path" entries in the [Album Settings] section of .kde4/share/config/digikamrc. Album Path should, IIRC, point to the directory containing database and pictures. Thanks for the hint, the problem was as follows: My kde3 configuration used a symbolic link to the data while the kde4 configuration used the real path to the data. As a consequence digikam3.db was found but not the data referenced in the database file.
After fixing this i got another problem. While the album thumbnails are there, all JPEG's are missing when i start digikam. All movies are found. I checked the digikam4.db and found that the entries in ImageInformation are missing (they are only found for new pictures not in the kde3 database). When i add such an entry manually:
INSERT INTO "ImageInformation" VALUES(8670,0,'2009-12-01T17:14:02','2009-12-01T17:14:02',1,2592,1944,'JPG',8,5);
the picture becomes visible in digikam.
Do i maybe have a too old database?
sqlite> .dump Settings
...
INSERT INTO "Settings" VALUES('DBVersion','1');
INSERT INTO "Settings" VALUES('UpgradedFromSqlite2','yes');
...
Yes this is a known problem, bug #226853. It's fixed for 1.2.0. |