Roundcube Community Forum

SVN Releases => Issues & Bugs => Topic started by: mhuether on March 31, 2023, 01:29:31 PM

Title: Inline MySQL comment causes error
Post by: mhuether on March 31, 2023, 01:29:31 PM

I updated an old installation from 1.2 to 1.6 and got an MySQL error because of inline comment in SQL/mysql/2016112200.sql:

ALTER TABLE `dictionary` ADD COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; -- redundant, for compat. with Galera Cluster

When I remove the comment or place it above the statement, everything works fine.

I'm using MySQL 8.0.32 on macOS 13.3 (Ventura)