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

2019-07-26 Thread Wolfgang Bauer
https://bugs.kde.org/show_bug.cgi?id=409753

Wolfgang Bauer  changed:

   What|Removed |Added

   Version Fixed In||5.12.0
 Status|REPORTED|RESOLVED
  Latest Commit||https://cgit.kde.org/akonad
   ||i.git/commit/?id=8b8db29d10
   ||b2ef92deb2d87ff613f3d7f39af
   ||34e
 CC||wba...@tmo.at
 Resolution|--- |FIXED

--- Comment #7 from Wolfgang Bauer  ---
Should be fixed by
https://cgit.kde.org/akonadi.git/commit/?id=8b8db29d10b2ef92deb2d87ff613f3d7f39af34e

-- 
You are receiving this mail because:
You are watching all bug changes.

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

2019-07-24 Thread wraeth
https://bugs.kde.org/show_bug.cgi?id=409753

--- Comment #6 from wraeth  ---
(In reply to David Faure from comment #4)
> So the immediate fix is to lowercase your table names.
To confirm, this has worked for me, though rather than dumping I just ran
'ALTER TABLE Foo RENAME TO foo;' for each of them, then restarted with
lower_case_table_names=1 set.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

2019-07-22 Thread Matthijs Tijink
https://bugs.kde.org/show_bug.cgi?id=409753

--- Comment #5 from Matthijs Tijink  ---
Removing the Akonadi database and using the built-in database indeed worked.

Maybe it would be good to document this requirement: I wasn't aware of it (and
back when I set it up, this wasn't stated even in the GUI used to configure the
external db!), and not entirely expected.

https://techbase.kde.org/KDE_PIM/Akonadi#Can_Akonadi_use_a_normal_MySQL_server_running_on_my_system.3F
would be a good place.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

2019-07-21 Thread David Faure
https://bugs.kde.org/show_bug.cgi?id=409753

David Faure  changed:

   What|Removed |Added

 CC||fa...@kde.org

--- Comment #4 from David Faure  ---
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 watching all bug changes.

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

2019-07-17 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=409753

andreas.sturmlech...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.kde.org/show_b
   ||ug.cgi?id=409234

-- 
You are receiving this mail because:
You are watching all bug changes.

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

2019-07-17 Thread Mathias Homann
https://bugs.kde.org/show_bug.cgi?id=409753

Mathias Homann  changed:

   What|Removed |Added

 CC||mathias.hom...@opensuse.org

--- Comment #3 from Mathias Homann  ---
*** Bug 409853 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are watching all bug changes.

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

2019-07-17 Thread wraeth
https://bugs.kde.org/show_bug.cgi?id=409753

wraeth  changed:

   What|Removed |Added

 CC||wraeth+kdeb...@wraeth.id.au

--- Comment #2 from wraeth  ---
(In reply to Antonio Rojas from comment #1)
> According to downstream reports, this is a regression from
> 74aed9542ba1ff1e6e93a550c42869647c4eba8e

I encountered the same issue with the same version of akonadi on Gentoo, and
reverting that specific commit resolved it for me.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

2019-07-17 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=409753

andreas.sturmlech...@gmail.com changed:

   What|Removed |Added

 CC||andreas.sturmlechner@gmail.
   ||com

-- 
You are receiving this mail because:
You are watching all bug changes.

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

2019-07-16 Thread Antonio Rojas
https://bugs.kde.org/show_bug.cgi?id=409753

Antonio Rojas  changed:

   What|Removed |Added

 CC||aro...@archlinux.org

--- Comment #1 from Antonio Rojas  ---
According to downstream reports, this is a regression from
74aed9542ba1ff1e6e93a550c42869647c4eba8e

-- 
You are receiving this mail because:
You are watching all bug changes.

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

2019-07-14 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=409753

emili...@gmail.com changed:

   What|Removed |Added

 CC||emili...@gmail.com

-- 
You are receiving this mail because:
You are watching all bug changes.