[Akonadi] [Bug 409753] Duplicate column name 'version' QMYSQL

[David Faure]

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

David Faure <faure at kde.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |faure at kde.org

--- Comment #4 from David Faure <faure at kde.org> ---
This happens on external MySQL servers, since they don't usually have the
option lower_case_table_names=1 enabled, so the (new) toLower() call assumes
that option to be present.

So the immediate fix is to lowercase your table names. I'm not sure doing that
at the filesystem level is enough, they're probably listed in the global mysql
DB too. Instead you can use mysqldump, lowercase the table names, and reimport.

The external MySQL server feature assumes that your MySQL matches the
requirements for Akonadi. This includes InnoDB and lowercase table names, at
least.
See /etc/xdg/akonadi/mysql-global.conf for the settings used by akonadi.

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