[Digikam-devel] [digikam] [Bug 345045] digikam: images not displayed in album

[Vincent Danjean]

https://bugs.kde.org/show_bug.cgi?id=345045

--- Comment #7 from Vincent Danjean <vdanjean.ml at free.fr> ---
  Hi Gilles,

  I'm not sure to understand the version number you tell me about (4.11.0,
4.10.0). It is digikam version itself ? It is an internal version ?
  More over, do you have a document telling me how to do such a rebuild?
  If the rebuild comes only from on-disk files, I'm relunctant. Indeed, my
current database contains lots of information that is not duplicated into
files. The more obvious is the date of all my films that is only stored into
the current database, not in the films themselves.

  That said, I hope you see that, in my last report, my problem comes from
files I just imported. Perhaps there is another inconsistency in the database
that triggered this behavior but it seems a bit strange to me. If you want that
I look into the current database, just tell me. I know how to explore the mysql
database. I can verify what you want.

For now, my database seems clean wrt the small consistency checks I do :
mysql> use digikamdb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> DELETE i FROM ImageComments i LEFT OUTER JOIN Images ON
Images.id=i.imageid WHERE Images.name IS NULL;
Query OK, 0 rows affected (0.02 sec)

mysql> DELETE i FROM ImageCopyright i LEFT OUTER JOIN Images ON
Images.id=i.imageid WHERE Images.name IS NULL;
Query OK, 0 rows affected (0.11 sec)

mysql> DELETE i FROM ImageInformation i LEFT OUTER JOIN Images ON
Images.id=i.imageid WHERE Images.name IS NULL;
Query OK, 0 rows affected (0.10 sec)

mysql> DELETE i FROM ImageMetadata i LEFT OUTER JOIN Images ON
Images.id=i.imageid WHERE Images.name IS NULL;
Query OK, 0 rows affected (0.09 sec)

mysql> DELETE i FROM ImageTags i LEFT OUTER JOIN Images ON Images.id=i.imageid
WHERE Images.name IS NULL;
Query OK, 0 rows affected (0.29 sec)

mysql> select CONCAT(relativePath, '/', name) from Images LEFT OUTER JOIN
ImageInformation on Images.id=ImageInformation.imageid LEFT OUTER JOIN Albums
on Images.album=Albums.id where ImageInformation.imageid is NULL;
Empty set (0.05 sec)


  Regards,
    Vincent

-- 
You are receiving this mail because:
You are the assignee for the bug.