missing thumbnails - database cleanup???

[Daniel Bauer-2]

Hello,

from time to time digikam refuses to show thumbnails in the album view
for some images. No idea why...

Searching google I found that it might bbe nessesary to cleanup the
databases. As I always have a lot of changes I can imagine...

But I cannot find the cleanup_digikamdb.1 program as an rpm for
opensuse. Big brother google doesn't help me, of course.

Any hints?

Daniel
digikam 3.2.0
sqlite db

(ps: I even copied the missing image again under a new name, it is still
not shown...)
--
Daniel Bauer photographer Basel Barcelona
http://www.daniel-bauer.com
room in Barcelona: https://www.airbnb.es/rooms/2416137

--
Daniel Bauer photographer Basel Barcelona
http://www.daniel-bauer.com
room in Barcelona: https://www.airbnb.es/rooms/2416137
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Daniel Bauer-2]

Am 06.01.2015 um 15:25 schrieb Daniel Bauer:

> Hello,
>
> from time to time digikam refuses to show thumbnails in the album view
> for some images. No idea why...
>
> Searching google I found that it might bbe nessesary to cleanup the
> databases. As I always have a lot of changes I can imagine...
>
> But I cannot find the cleanup_digikamdb.1 program as an rpm for
> opensuse. Big brother google doesn't help me, of course.
>
> Any hints?
>
> Daniel
> digikam 3.2.0
> sqlite db
>
> (ps: I even copied the missing image again under a new name, it is still
> not shown...)

I updated to digikam 4.6.0, no change
I run
        sqlite3 -line digikam4.db 'pragma integrity_check;'  and
        sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'
no errors
        sqlite3 -line digikam4.db 'vacuum;'
reduced size about 50%
        sqlite3 -line thumbnails-digikam.db 'vacuum;'
no vivible change in file size

however the thumbs of those images are still not shown.

There must be something in those images that digikam does not like
(although they were produced with digikams batch tool). They wouldn't be
shown in any other folder, no matter if I rename them. But when I open
the fiole with gewenview and save a new copy, it is immediately shown...

I can send such an image to a developper, but not publish it...

Daniel

--
Daniel Bauer photographer Basel Barcelona
http://www.daniel-bauer.com
room in Barcelona: https://www.airbnb.es/rooms/2416137
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Gilles Caulier-4]

Hi Daniel,

Just to try, rename thumbnails-digikam.db database file and restart digiKam.

There is nothing important in this database. It store thumbnail with
wavelets compression. It's a cache.

You will need of course to rebuild thumbnails after.

Gilles Caulier

2015-01-06 16:13 GMT+01:00 Daniel Bauer <[hidden email]>:

> Am 06.01.2015 um 15:25 schrieb Daniel Bauer:
>>
>> Hello,
>>
>> from time to time digikam refuses to show thumbnails in the album view
>> for some images. No idea why...
>>
>> Searching google I found that it might bbe nessesary to cleanup the
>> databases. As I always have a lot of changes I can imagine...
>>
>> But I cannot find the cleanup_digikamdb.1 program as an rpm for
>> opensuse. Big brother google doesn't help me, of course.
>>
>> Any hints?
>>
>> Daniel
>> digikam 3.2.0
>> sqlite db
>>
>> (ps: I even copied the missing image again under a new name, it is still
>> not shown...)
>
>
>
> I updated to digikam 4.6.0, no change
> I run
>         sqlite3 -line digikam4.db 'pragma integrity_check;'  and
>         sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'
> no errors
>         sqlite3 -line digikam4.db 'vacuum;'
> reduced size about 50%
>         sqlite3 -line thumbnails-digikam.db 'vacuum;'
> no vivible change in file size
>
> however the thumbs of those images are still not shown.
>
> There must be something in those images that digikam does not like (although
> they were produced with digikams batch tool). They wouldn't be shown in any
> other folder, no matter if I rename them. But when I open the fiole with
> gewenview and save a new copy, it is immediately shown...
>
> I can send such an image to a developper, but not publish it...
>
> Daniel
>
>
> --
> Daniel Bauer photographer Basel Barcelona
> http://www.daniel-bauer.com
> room in Barcelona: https://www.airbnb.es/rooms/2416137
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users

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

[Daniel Bauer-2]

Hello Gilles

happy new year!

I guess you told me this, so that you will not see me on this list
anymore in the next 248 years while I'm waiting that the thumbnails are
rebuilt :-)

However, I gave it a try, renamed the thumbnails-digikam.db, started
digikam, went to that folder with the two missing images - all thumbs
were rebuilt, /except the missing two/...

So, this wouldn't help...

What else can it be?

Am 06.01.2015 um 18:26 schrieb Gilles Caulier:

> Hi Daniel,
>
> Just to try, rename thumbnails-digikam.db database file and restart digiKam.
>
> There is nothing important in this database. It store thumbnail with
> wavelets compression. It's a cache.
>
> You will need of course to rebuild thumbnails after.
>
> Gilles Caulier
>
> 2015-01-06 16:13 GMT+01:00 Daniel Bauer <[hidden email]>:
>> Am 06.01.2015 um 15:25 schrieb Daniel Bauer:
>>>
>>> Hello,
>>>
>>> from time to time digikam refuses to show thumbnails in the album view
>>> for some images. No idea why...
>>>
>>> Searching google I found that it might bbe nessesary to cleanup the
>>> databases. As I always have a lot of changes I can imagine...
>>>
>>> But I cannot find the cleanup_digikamdb.1 program as an rpm for
>>> opensuse. Big brother google doesn't help me, of course.
>>>
>>> Any hints?
>>>
>>> Daniel
>>> digikam 3.2.0
>>> sqlite db
>>>
>>> (ps: I even copied the missing image again under a new name, it is still
>>> not shown...)
>>
>>
>>
>> I updated to digikam 4.6.0, no change
>> I run
>>          sqlite3 -line digikam4.db 'pragma integrity_check;'  and
>>          sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'
>> no errors
>>          sqlite3 -line digikam4.db 'vacuum;'
>> reduced size about 50%
>>          sqlite3 -line thumbnails-digikam.db 'vacuum;'
>> no vivible change in file size
>>
>> however the thumbs of those images are still not shown.
>>
>> There must be something in those images that digikam does not like (although
>> they were produced with digikams batch tool). They wouldn't be shown in any
>> other folder, no matter if I rename them. But when I open the fiole with
>> gewenview and save a new copy, it is immediately shown...
>>
>> I can send such an image to a developper, but not publish it...
>>
>> Daniel
>>
>>
>> --
>> Daniel Bauer photographer Basel Barcelona
>> http://www.daniel-bauer.com
>> room in Barcelona: https://www.airbnb.es/rooms/2416137
>> _______________________________________________
>> Digikam-users mailing list
>> [hidden email]
>> https://mail.kde.org/mailman/listinfo/digikam-users
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>

--
Daniel Bauer photographer Basel Barcelona
http://www.daniel-bauer.com
room in Barcelona: https://www.airbnb.es/rooms/2416137
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

Le 06/01/2015 19:06, Daniel Bauer a écrit :

> However, I gave it a try, renamed the thumbnails-digikam.db, started
> digikam, went to that folder with the two missing images - all thumbs
> were rebuilt, /except the missing two/...

first thing, move the two on an other folder to make simple tests :-)

can you see them in kde (dolphin)? are them jpg? try showfoto standalone
(right clic the photo and choose showfoto)

jdd

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

[Daniel Bauer-2]

Am 06.01.2015 um 19:35 schrieb jdd:

> Le 06/01/2015 19:06, Daniel Bauer a écrit :
>
>> However, I gave it a try, renamed the thumbnails-digikam.db, started
>> digikam, went to that folder with the two missing images - all thumbs
>> were rebuilt, /except the missing two/...
>
> first thing, move the two on an other folder to make simple tests :-)
>
> can you see them in kde (dolphin)? are them jpg? try showfoto standalone
> (right clic the photo and choose showfoto)
>
> jdd
>

I did those tests. They are in dolphin. I can open them with any image
program (gwenview, gimp, kwickshow and now I tried showphoto, too),
dolphin also shows a thumbnail.

I copied them on the desktop, renamed them, put them in another
digikam-folder: digikam just doesn't like those images

If I open in gwenview, save as other name (still jpg), then digikam
shows the new one.

There must be something in those images that disturbs digikam. I could
understand if they were made with an exotic program, but actually they
were resized and added metadata *with digikam batch process*, together
with the other 23 images in the same folder - but two don't show...

Strange, isn't it?

Daniel

--
Daniel Bauer photographer Basel Barcelona
http://www.daniel-bauer.com
room in Barcelona: https://www.airbnb.es/rooms/2416137
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

Le 06/01/2015 19:53, Daniel Bauer a écrit :

> There must be something in those images that disturbs digikam. I could
> understand if they were made with an exotic program, but actually they
> were resized and added metadata *with digikam batch process*, together
> with the other 23 images in the same folder - but two don't show...
>
> Strange, isn't it?

I use a Canon selphy thermal printer that makes superb photos, but the
last version is not linux compatible.

so I copy the images to a sd card and read the card on the printer.

dome images a not read by it, even if I read them evry where else...

who knows? may be the robots begin thinking?

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