Help database format?? (old database format)

[Florian Ehinger]

Hello,

my problem is that digikam gives me the error that it could not convert my old
database to the new version and exits. (see my old message)

Do you have an idea which could be the problem, or can you give me a
description of the digikam.db database so that I could check my current one
if it is in the right format?

As far as I know it is a sqlite database. So it would be very helpful if there
is some document which describes the tables and fields.

Thank you
  Florian
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Gilles Caulier-2]

Le Samedi 20 Mai 2006 11:20 PM, Florian Ehinger a écrit :

> Hello,
>
> my problem is that digikam gives me the error that it could not convert my
> old database to the new version and exits. (see my old message)
>
> Do you have an idea which could be the problem, or can you give me a
> description of the digikam.db database so that I could check my current one
> if it is in the right format?
>
> As far as I know it is a sqlite database. So it would be very helpful if
> there is some document which describes the tables and fields.
>
> Thank you
>   Florian

The database implementation isn't a part implemented by me. My experience is
limited actually. I cannot help you very well, and i have not seen (yet) a
description of the tables in the code.

Gilles
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Heiner Lamprecht]

Hi,

On Saturday 20 May 2006 23:20, Florian Ehinger wrote:
> Hello,
>
> my problem is that digikam gives me the error that it could not
> convert my old database to the new version and exits. (see my old
> message)

Was the old database crated by digikam (version?) or any other tool
like kim_2_digikam?

What digikam version do you use?

Is the database located on your local hd?  There once were some
problems with databases on nfs shares or similar.  I don't know, if
they are fixed in the meanwhile.


Cheers,


    Heiner

--
    heiner at heiner-lamprecht dot net    GnuPG - Key: 9859E373
  Fingerprint:  3770 7947 F917 94EF 8717 BADB 0139 7554 9859 E373
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Florian Ehinger]

Hi Heiner
>
> Was the old database crated by digikam (version?) or any other tool
> like kim_2_digikam?
with kim_2_digikam

>
> What digikam version do you use?
digikam-0.8.1-23

As I have already mentioned in my other mail I get the following warning when
I use digikam 0.7 and I see only my first category in digikam.

WARNING: [bool AlbumDB::execSql(const QString&, QStringList*, bool)]
sqlite_compile error: table Albums already exists on query: CREATE TABLE
Albums (id INTEGER PRIMARY KEY,  url TEXT NOT NULL UNIQUE,  date DATE NOT
NULL,  caption TEXT,  collection TEXT,  ignoreprops BOOLEAN,  icon TEXT);

> Is the database located on your local hd?  There once were some
> problems with databases on nfs shares or similar.  I don't know, if
> they are fixed in the meanwhile.
Yes all photos and the database is located on my hd.


Bye
  Flo
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users