[digikam] [Bug 324134] New: Images disappear after advanced rename

[alexander.s.m]

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

            Bug ID: 324134
           Summary: Images disappear after advanced rename
    Classification: Unclassified
           Product: digikam
           Version: 3.3.0
          Platform: Archlinux Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: Advanced Rename
          Assignee: [hidden email]
          Reporter: [hidden email]

After using advanced rename wizard renamed photos disappears from digiKam (but
stays on disk) due to inconsistent database state.

Reproducible: Always

Steps to Reproduce:
1. Create album "TestAlbum" with images "testa.jpg" and "TESTB.jpg";
2. Select both images in digiKam and use rename tool with pattern
"[file]{upper}" to make both file names uppercase.
Actual Results:  
File "testa.jpg" is correctly renamed to "TESTA.jpg", but it disappears from
digiKam. It is not visible in album, cannot be find by search etc. However,
digiKam keeps indicating that there is 2 items in "TestAlbum".

Maintenance tool "Scan for new images" does not restore visibility of lost
photo.

The reason of disappearance is that after rename lost photo lacks record in
table "ImageInformation".


Probably the bug is specific to MySQL database backend.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
          Component|Advanced Rename             |Database

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #1 from Gilles Caulier <[hidden email]> ---
*** Bug 336307 has been marked as a duplicate of this bug. ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #2 from Gilles Caulier <[hidden email]> ---
Do you use sqlite or mysql database ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[aangelo]

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

--- Comment #3 from Antonio <[hidden email]> ---
I use sqlite.
--
Antonio Angelo


2014-08-07 9:05 GMT+02:00 Gilles Caulier <[hidden email]>:

> https://bugs.kde.org/show_bug.cgi?id=324134
>
> --- Comment #2 from Gilles Caulier <[hidden email]> ---
> Do you use sqlite or mysql database ?
>
> Gilles Caulier
>
> --
> You are receiving this mail because:
> You are on the CC list for the bug.
> You voted for the bug.
>

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Images disappear after      |SQLITE : Images disappear
                   |advanced rename             |after advanced rename

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[alexander.s.m]

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

--- Comment #4 from Alexander Meshcheryakov <[hidden email]> ---
I used mysql database when I have encoutered this issue.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|SQLITE : Images disappear   |Images disappear after
                   |after advanced rename       |advanced rename

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #5 from Gilles Caulier <[hidden email]> ---
Problem still reproducible using last digiKam 4.2.0 ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Images disappear after      |SCAN : Images disappear
                   |advanced rename             |after advanced rename

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Larx]

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

Larx <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #6 from Larx <[hidden email]> ---
I just encountered the same problem using Digikam 4.5.0 with MySQL-backend.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Larx]

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

--- Comment #7 from Larx <[hidden email]> ---
More Info:
Problem occured after batch renaming three pictures.
After that, one pic remained, two have gone AWOL.
All Pictures are still visible in ordinary file browser, they are just missing
in Digikam.

Strange enough, when I use Digikam's filter mode and type in the file name of
the missing pictures, Digikam finds (or thinks it finds) this picture. However,
the displayed pic is the one which didn't get lost after the batch rename, not
the missing one. I don't know why this picture should match the filter..

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Larx]

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

--- Comment #8 from Larx <[hidden email]> ---
It's reproducable: Batch rename seems to kick out the first picture of the
renamed batch :(.

No way to repair the database - I tried moving the affected folder out and in
of Digikam's picture path, rescanning in between, and so on: The pictures are
lost for Digikam.

I gues the database has to be scrapped completely. I don't know how many photos
I "lost" this way before noticing the bug. Seems to my kind of critical... and
judging from above comments, it does not only affect the experimental MySQL
backend.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|3.3.0                       |4.5.0

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #9 from Gilles Caulier <[hidden email]> ---
Maik,

I suspect a same dysfunction here in advance rename than BQM with
ImageScanner...

Gilles

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Maik Qualmann]

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

Maik Qualmann <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #10 from Maik Qualmann <[hidden email]> ---
Gilles,

The malfunction of the description I can not reproduce. But it is possible with
the renaming of one file, to remove the suffix. The file is then no longer
visible in the album, and must be externally renamed again. That could be the
problem.

Maik

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #11 from Gilles Caulier <[hidden email]> ---
The file extension is a very sensible feature used by digiKam to identify
quickly type mime without to parse first byte of file which is time consuming.

I recommend to drop file extension renaming in AdvanceRename tool to prevent
all dysfunction. Note that is always possible use file manager as Dolphin, but
in this case users do it with know risk.

We can also put a small tips in GUI about this problem.

Gilles

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #12 from Gilles Caulier <[hidden email]> ---
New digiKam 4.11.0 is available with official PKG installer for OSX.

https://www.digikam.org/node/740

Can you reproduce the problem with this release ?

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #13 from Gilles Caulier <[hidden email]> ---
digiKam 4.12.0 is out.

https://www.digikam.org/node/741

Problem still reproducible ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Scan

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel