[digikam] [Bug 375019] New: Error updating scheme from digikam 4

[bugzilla_noreply]

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

            Bug ID: 375019
           Summary: Error updating scheme from digikam 4
           Product: digikam
           Version: 5.4.0
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database-Migration
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Hi,
  I usually use digikam 4.14.0 from the kubuntu 16.10 packages but today I
decided to give a try to digikam 5.4.0.
  I am using digikam 5.4.0 packages from philip5 ppa.

  When I launched digikam5 it asked me to upgrade the database. I am using a
mysql server 5.5.52 backend from my NAS server. In the process of updating the
schema it reported the following error:

  Error messages: "QMYSQL: No es posible ejecutar la consulta" "Specified key
was too long; max key length is 1000 bytes" 1071 2
Bound values:  ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV8" ]
Statement [ "ALTER TABLE DownloadHistory MODIFY COLUMN filesize BIGINT;" ]
digikam.coredb: Core database: schema update to V 8 failed!

  The complete log is in the attached log file.

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

[bugzilla_noreply]

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

Maik Qualmann <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
      Latest Commit|                            |https://commits.kde.org/dig
                   |                            |ikam/6dd0f1cb219ecb5062f143
                   |                            |4cf82de942f10629fd
   Version Fixed In|                            |5.5.0
                 CC|                            |[hidden email]
         Resolution|---                         |FIXED

--- Comment #1 from Maik Qualmann <[hidden email]> ---
Git commit 6dd0f1cb219ecb5062f1434cf82de942f10629fd by Maik Qualmann.
Committed on 14/01/2017 at 19:56.
Pushed by mqualmann into branch 'master'.

fix MySQL DB update to V8 in the table DownloadHistory
FIXED-IN: 5.5.0

M  +2    -1    NEWS
M  +11   -8    data/database/dbconfig.xml.cmake.in

https://commits.kde.org/digikam/6dd0f1cb219ecb5062f1434cf82de942f10629fd

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