[digikam] [Bug 355893] New: Agnostic on unix filenames (upper ne lower), creates rename problems

classic Classic list List threaded Threaded
15 messages Options
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] New: Agnostic on unix filenames (upper ne lower), creates rename problems

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

            Bug ID: 355893
           Summary: Agnostic on unix filenames (upper ne lower), creates
                    rename problems
           Product: digikam
           Version: 4.14.0
          Platform: openSUSE RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: critical
          Priority: NOR
         Component: general
          Assignee: [hidden email]
          Reporter: [hidden email]

Trying to reproduce bug reported in 324134 and create documentation for that.
Using a test directory I copied 4 existing pictures in it,  left one as is(1),
one suffix was changed (uppercase, 2), one renamed entirely (3), last (4)
renamed as previous but difference in capitalisation (digikambug1.1 and
digikambug1.2).  On opening digikam, only 1,2 and 4 were shown/recognised
(digikambug1.3). The advanced rename was done (digikambug1.4), result was both
as expected (reproduce 32414) where 4 disappeared (and 2 surprisingly not),
and unexpected because 3 reappeared (digikambug1.5).

In digkam1.dbg and digikam2.dbg is the output from traces as set by
kdebugdialog. In digikam1.log is the mysql log from executed statements.

Reproducible: Always

Steps to Reproduce:
Refer to description

Actual Results:  
As described

Expected Results:  
1) Digikam should have recognised the 4 initial pictures in the album.
2) On rename all 4 pictures should still be there.

As highlighted in 324134, you can recover the apparent lost images by running
fixing (?) queries against the 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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

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

Gerard Dirkse <[hidden email]> changed:

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

--- Comment #1 from Gerard Dirkse <[hidden email]> ---
Created attachment 95732
  --> https://bugs.kde.org/attachment.cgi?id=95732&action=edit
digikam1.1 initial list of files

This is the contents of the test directory.

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

--- Comment #2 from Gerard Dirkse <[hidden email]> ---
Created attachment 95733
  --> https://bugs.kde.org/attachment.cgi?id=95733&action=edit
digikambug1.1

Initial file list

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

Gerard Dirkse <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #95732|digikam1.1 initial list of  |digikam1.2 initial list of
        description|files                       |files picture view

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

--- Comment #3 from Gerard Dirkse <[hidden email]> ---
Created attachment 95734
  --> https://bugs.kde.org/attachment.cgi?id=95734&action=edit
digikam1.3

Digikams initial view of the album, one is missing.

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

--- Comment #4 from Gerard Dirkse <[hidden email]> ---
Created attachment 95735
  --> https://bugs.kde.org/attachment.cgi?id=95735&action=edit
digikambug1.4

Rename the pictures

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

--- Comment #5 from Gerard Dirkse <[hidden email]> ---
Created attachment 95736
  --> https://bugs.kde.org/attachment.cgi?id=95736&action=edit
digikambug1.5

Result of rename, one disappeared, one missing showed up

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

--- Comment #6 from Gerard Dirkse <[hidden email]> ---
Created attachment 95737
  --> https://bugs.kde.org/attachment.cgi?id=95737&action=edit
digikam1.dbg

Debug log 1 from kdebugdialog

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

--- Comment #7 from Gerard Dirkse <[hidden email]> ---
Created attachment 95738
  --> https://bugs.kde.org/attachment.cgi?id=95738&action=edit
digikam2.dbg

digikam debug log 2 from kdebugdialog.

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

--- Comment #8 from Gerard Dirkse <[hidden email]> ---
Created attachment 95739
  --> https://bugs.kde.org/attachment.cgi?id=95739&action=edit
digikam1.log

MYSQL log from this test run.

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|general                     |Database-Mysql
                 CC|                            |[hidden email]

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] MYSQL : Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Agnostic on unix filenames  |MYSQL : Agnostic on unix
                   |(upper ne lower), creates   |filenames (upper ne lower),
                   |rename problems             |creates rename problems

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] MYSQL : Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

Richard Mortimer <[hidden email]> changed:

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

--- Comment #9 from Richard Mortimer <[hidden email]> ---
We need to make sure that the MySQL schema for text fields specifies a
collation value that compares strings in a case sensitive manner.

Useful background information at
http://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html

I suspect that we should be using the utf8_bin collation.

http://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] MYSQL : Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

[hidden email] changed:

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

--- Comment #10 from [hidden email] ---
 MySQL has been made case sensitive. It now uses utf8_bin collation.

Try digiKam 5.0.0 version.

--
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 355893] MYSQL : Agnostic on unix filenames (upper ne lower), creates rename problems

bugzilla_noreply
In reply to this post by bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=355893

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |5.0.0
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |FIXED
      Latest Commit|                            |https://github.com/KDE/digi
                   |                            |kam/commit/d18903fa644affd5
                   |                            |f2b3c275b2544a54a9d64782

--- Comment #11 from [hidden email] ---
This file is closed now. Feel free to reopen, with necessary updates, if you
still face the 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