Some images aren't displaying in thumbnail view

[nianderson]

I'm running digikam 2.1.1 with a mysql backend.

I have noticed that some images are not displaying in thumbnail view.
I have verified that the images are on the file-system in the expected
folder. 10 of the 45 pictures in this folder do not display. In fact
even if I search for the image by name (I have unique filenames across
the entire collection) no images are displayed in the results.

I've poked around in the DB a little and I see that my image is found
in the Images table, in fact its found 4 times, 3 of the 4 have NULL
for the album. Im not sure what that indicates but the last entry does
have an album number.

mysql> select * from Images where
name='NIKON_D5000_20111031T165839_00.jpg';
+-------+-------+------------------------------------+--------+----------+---------------------+----------+----------------------------------+
| id    | album | name                               | status |
category | modificationDate    | fileSize | uniqueHash
       |
+-------+-------+------------------------------------+--------+----------+---------------------+----------+----------------------------------+
| 15544 |  NULL | NIKON_D5000_20111031T165839_00.jpg |      3 |
 1 | 2011-10-31 16:58:40 |  4165640 | 178e3781861c02257a8e0a99be2a06c4 |
| 15554 |  NULL | NIKON_D5000_20111031T165839_00.jpg |      3 |
 1 | 2011-10-31 16:58:40 |  4165640 | 178e3781861c02257a8e0a99be2a06c4 |
| 15599 |  NULL | NIKON_D5000_20111031T165839_00.jpg |      3 |
 1 | 2011-10-31 16:58:40 |  4165640 | 178e3781861c02257a8e0a99be2a06c4 |
| 15644 |  1298 | NIKON_D5000_20111031T165839_00.jpg |      1 |
 1 | 2011-10-31 16:58:40 |  4148302 | 03c960ad47c113a2b8a1ace182042e51 |
+-------+-------+------------------------------------+--------+----------+---------------------+----------+----------------------------------+


Ive tried a few different ways to get the image visible again like
renaming the file or re importing without success. Not really sure
where to go from here, im concerned that there may be other images
that exist in my library but im unable to find with digikam.

Does anyone know how I can fix this, and what if any db maintance
operations should I be performing on the DB?


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

[nianderson]

On 11/02/2011 08:42 PM, Nick Anderson wrote:
> Does anyone know how I can fix this, and what if any db maintance
> operations should I be performing on the DB?

So I decided to fuddle with the DB a bit.

I deleted the entries of the entries I knew were missing and rescanned
the directory. They appeared. I did however neglect to backup the DB
before I made the modifications so I wont be able to correlate what
caused it. Hoping someone has seen this before and I didn't just trash
important bug info.

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

[CHARHON Pierre]

Le 03/11/2011 02:49, Nick Anderson a écrit :

> On 11/02/2011 08:42 PM, Nick Anderson wrote:
>> Does anyone know how I can fix this, and what if any db maintance
>> operations should I be performing on the DB?
> So I decided to fuddle with the DB a bit.
>
> I deleted the entries of the entries I knew were missing and rescanned
> the directory. They appeared. I did however neglect to backup the DB
> before I made the modifications so I wont be able to correlate what
> caused it. Hoping someone has seen this before and I didn't just trash
> important bug info.
>

          Bonjour,
     merci pour vos mails. Seulement il se trouve que mes connaissances
en Anglais sont insuffisantes pour comprendre. Je crois que le plus
simple serait de me radier de vos listes.
     Merci d'avance. PC.
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[tosca]

Il te revient de te désinscrire de cette mailing-list, à laquelle tu t'es inscrit.
Retourne sur la page d'administration (lien en bas de chaque message) pour faire le nécessaire.

Marie-Noëlle

2011/11/3 CHARHON Pierre <[hidden email]>

Le 03/11/2011 02:49, Nick Anderson a écrit :

On 11/02/2011 08:42 PM, Nick Anderson wrote:

Does anyone know how I can fix this, and what if any db maintance
operations should I be performing on the DB?

So I decided to fuddle with the DB a bit.

I deleted the entries of the entries I knew were missing and rescanned
the directory. They appeared. I did however neglect to backup the DB
before I made the modifications so I wont be able to correlate what
caused it. Hoping someone has seen this before and I didn't just trash
important bug info.

        Bonjour,
   merci pour vos mails. Seulement il se trouve que mes connaissances en Anglais sont insuffisantes pour comprendre. Je crois que le plus simple serait de me radier de vos listes.
   Merci d'avance. PC.

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

--
Une galerie photos, un blog ... pourquoi pas ? Webmaster en herbe

Parcourez les Cévennes à ma façon : Cévennes Plurielles

Et toutes mes autres publications à partir de ma page d'accueil générale


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

[nianderson]

Please forgive poor translation via translate.google.com
Manage your subscription at the following url.

S'il vous plaît pardonnez mauvaise traduction via
translate.google.com. Gérez votre abonnement à l'adresse suivante.

https://mail.kde.org/mailman/listinfo/digikam-users

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