[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #17 from Steve Franks --- I think the problem is due to the digikan data directory being empty. I have no idea where the data disappeared to, but will retrieve it from backup and try again. Sorry for troubling you Regards Steve On Sun, 12 N

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #16 from Maik Qualmann --- Another thing, the path to "mysql_upgrade" is in your home directory. The server uses the same instance as the path or the same MariaDB version? Maik -- You are receiving this mail because: You are watching all

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #15 from Maik Qualmann --- If the "mysql_upgrade" fails, the database may not be clean. We need to do this upgrade due to the many changes to the internal database structure with almost every new MariaDB release. Other projects that manage a

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #14 from Steve Franks --- My Windows laptop is working fine with 8.2. I didn’t modify the Linux data, simply downloaded the 8.2 appimage and ran it. It surprised me when it displayed the missing MySQL dialogue. -- You are receiving this ma

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #13 from Maik Qualmann --- While you changed the system tables manually, you certainly created a backup. You could use this now. Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #12 from Maik Qualmann --- We now run "mysql_upgrade" at every start in order to adapt the database when the server software is updated. Since you have already tried to correct the system tables of the database manually, the "mysql_upgrade"

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 caulier.gil...@gmail.com changed: What|Removed |Added Version|8.1.0 |8.2.0 -- You are receiving this mail

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #11 from Steve Franks --- I tried again with Mariadb 11.3 Alpha and it displayed the same error. Regards Steve On Thu, 26 Oct 2023 at 17:54, Maik Qualmann wrote: > https://bugs.kde.org/show_bug.cgi?id=475874 > > --- Comment #9 from Maik Q

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #10 from Steve Franks --- I downloaded 8.2.0 appimage for Linux. I have not updated Mariadb, because I already have a recent version. When I start the appimage it says that it can't find Mariadb. I found and set the correct folders, but then

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #9 from Maik Qualmann --- The problem is that when users have problems with MySQL, they start digiKam more often and then we only have the last log. The old error log file is now deleted after 100MB and starts again from the beginning. We ca

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #8 from Steve Franks --- The mysql.err file is currently about 2mb, the mysql.err.old file grows after every digikam session. Would it not be better to delete the old file and rename mysql.err to mysql.err.old at the beginning of each digika

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #7 from Maik Qualmann --- Git commit 51f425ecf2647e5f4a97eb275055a4f031904c4c by Maik Qualmann. Committed on 22/10/2023 at 21:12. Pushed by mqualmann into branch 'master'. limit the file size to 100MB of the old MySQL error log file M +7

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #6 from Maik Qualmann --- Git commit d5d923389605ffe66be61f73d10ed88d4bcfc161 by Maik Qualmann. Committed on 21/10/2023 at 14:20. Pushed by mqualmann into branch 'master'. add the mysql upgrade command as required binary M +6-3cor

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #5 from Maik Qualmann --- Note: I can't say whether an upgrade to the current server version is still possible for you because you have already edited the internal MySQL system table. Maik -- You are receiving this mail because: You are w

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 Maik Qualmann changed: What|Removed |Added Version Fixed In||8.2.0 Resolution|---

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.

https://bugs.kde.org/show_bug.cgi?id=475874 Maik Qualmann changed: What|Removed |Added Summary|Huge mysql.err files filled |Huge mysql.err files filled |

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats: for columns 'hist_type' at position 9 and 'histogram' at position 10

https://bugs.kde.org/show_bug.cgi?id=475874 Maik Qualmann changed: What|Removed |Added CC||metzping...@gmail.com --- Comment #3 from Maik

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats: for columns 'hist_type' at position 9 and 'histogram' at position 10

https://bugs.kde.org/show_bug.cgi?id=475874 Steve Franks changed: What|Removed |Added CC||steve...@gmail.com -- You are receiving this ma

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats: for columns 'hist_type' at position 9 and 'histogram' at position 10

https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #2 from Steve Franks --- MariaDB 11.0.2 and 11.2.1. This does not seem to affect the working of digikam, but mysql.err.old has grown to 6.3gb, which is a waste of space. -- You are receiving this mail because: You are watching all bug chan

[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats: for columns 'hist_type' at position 9 and 'histogram' at position 10

https://bugs.kde.org/show_bug.cgi?id=475874 caulier.gil...@gmail.com changed: What|Removed |Added CC||caulier.gil...@gmail.com --- Comment