[Digikam-devel] 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-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[F.J.Cruz]

El Sábado, 20 de Mayo de 2006 23:20, Florian Ehinger escribió:

> 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-devel mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-devel

Digikam uses sqlite3. If you want a graphic tool to "see" digikam db, you can
try with sqlitebrowser (http://sqlitebrowser.sourceforge.net/).

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

[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-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[F.J.Cruz]

El Domingo, 21 de Mayo de 2006 15:48, Heiner Lamprecht escribió:

> 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?
>

Yes, by digikam.

> What digikam version do you use?
>

I'm a developer, so I'm using 0.9-svn version :-)

> 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, it's located in my second local hd, that is formated as an xfs filesystem

>
> Cheers,
>
>
>     Heiner
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[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-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel