[Digikam-users] Difference between Tags in Database (mysql) and Digikam

[Frank Hommes]

Problem is that I've got 300.000 images with no Albumlink (NULL).
Some of those images have information which are lost for digikam at the 
moment (https://bugs.kde.org/show_bug.cgi?id=243747).

I guess this problem occurs when you move pictures with the filemanager 
and the comment has not been saved yet.

And thanks for the database shema! That will help me a lot anyway :)

Frank

On 07/06/2010 01:16 PM, Gilles Caulier wrote:
> Do you take a look in database schema used by digiKam ? file is there :
>
> http://www.digikam.org/drupal/docs
>
> Gilles Caulier
>
> 2010/7/5 Frank Hommes<mailinglist at freanki.net>:
>> Hi,
>>
>> I'm giving out the tags in a php-script to show how many pictures have a
>> specific tag.
>> But there is a huge difference between the amount in the database
>> (18.000) and what Digikam (10.000) shows.
>>
>> The database also shows 4 times the number of actual pictures in the
>> table Images. When I don't count the pictures which are two times in
>> there (why is this so?) it's still two times the actual pictures.
>>
>> I got 100.000 actual pictures in the database, the table Images has
>> 400.000 entries. A good indicator is the table Thumbnails... :)
>>
>> Why are there such big differences and where does Digikam gets the real
>> numbers from?
>>
>> Frank
>> _______________________________________________
>> Digikam-users mailing list
>> Digikam-users at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>


-- 
Frank Hommes, Bummelberg 37, 44149 Dortmund, Germany
Email: email at freanki.net, ICQ: 14621277
Homepage: http://www.freanki.net
PGP-Key: http://www.freanki.net/gpg/