[digikam] [Bug 364131] New: Same picture with different file extensions: Database scan only finds one variant of the file.

[bugzilla_noreply]

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

--- Comment #16 from [hidden email] ---
(In reply to Maik Qualmann from comment #15)
> Swati,
> I think we need case-sensitivity in almost all text fields. I have tested it
> once for Albums.relativePath. It does the problem here on, if the path is
> different only in case-sensitivity. Is there a global statement for the DB?

I think in mysql-global.conf file, you could change
"collation_server=utf8_general_ci" to "collation-server=utf8_bin"

Or in etc/mysql/my.cnf file, under [mysqld]  section, you need to change the
collation, since MySQL is case insensitive by default.

--
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

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #99735|0                           |1
        is obsolete|                            |
  Attachment #99735|1                           |0
           is patch|                            |

--
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

[bugzilla_noreply]

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

--- Comment #17 from [hidden email] ---
Created attachment 99791
  --> https://bugs.kde.org/attachment.cgi?id=99791&action=edit
Final patch

Please test this patch.

--
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

[bugzilla_noreply]

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

--- Comment #18 from Maik Qualmann <[hidden email]> ---
I think the text fields from AlbumRoots need it too:
(line 934)
label LONGTEXT,
identifier LONGTEXT,
specificPath LONGTEXT,

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

[bugzilla_noreply]

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

Maik Qualmann <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #99791|0                           |1
        is obsolete|                            |

--
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

[bugzilla_noreply]

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

--- Comment #19 from Maik Qualmann <[hidden email]> ---
Created attachment 99808
  --> https://bugs.kde.org/attachment.cgi?id=99808&action=edit
schemaupdater6.patch

Ok, this patch works for a new MySQL DB and for an update of the DB. Swati,
please test the patch. I will this patch now commit to git/master and close
this bug.

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

[bugzilla_noreply]

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

Maik Qualmann <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |5.0.0
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |FIXED
      Latest Commit|                            |http://commits.kde.org/digi
                   |                            |kam/d18903fa644affd5f2b3c27
                   |                            |5b2544a54a9d64782

--- Comment #20 from Maik Qualmann <[hidden email]> ---
Git commit d18903fa644affd5f2b3c275b2544a54a9d64782 by Maik Qualmann.
Committed on 02/07/2016 at 17:30.
Pushed by mqualmann into branch 'master'.

make MySQL text fields case-sensitive
FIXED-IN: 5.0.0

M  +1    -2    NEWS
M  +81   -37   data/database/dbconfig.xml.cmake.in
M  +4    -1    libs/database/coredb/coredbschemaupdater.cpp

http://commits.kde.org/digikam/d18903fa644affd5f2b3c275b2544a54a9d64782

--
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

[bugzilla_noreply]

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

--- Comment #21 from [hidden email] ---
Patch works for me.

--
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