addon_migration_tool icon indicating copy to clipboard operation
addon_migration_tool copied to clipboard
verified publisher icon concretecms

Unable to install du to changes in MariDB 10.6.0

Open Claes-Pontusson opened this issue 3 years ago • 4 comments

Due to the addition of offset as a reserved word in MariaDB 10.6.0 the install fails.

This error is from a vanilla Concrete CMS 9.13.

An exception occurred while executing 'CREATE TABLE MigrationImportAreaLayoutColumns (id CHAR(36) NOT NULL COMMENT ‘(DC2Type:guid)’, area_layout_id CHAR(36) DEF

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version

Claes-Pontusson avatar Dec 20 '22 15:12 Claes-Pontusson

@Claes-Pontusson

Please use https://github.com/concretecms/migration_tool if you want to install migration tool on version 9

hissy avatar Dec 20 '22 23:12 hissy

Ok. Thanks for pointing that out.

The error is still the same though. Will post an issue in the other repo as well.

Claes-Pontusson avatar Dec 21 '22 09:12 Claes-Pontusson

@aembler Let's pick this commit to this repository also https://github.com/concretecms/migration_tool/pull/34

hissy avatar Mar 28 '24 05:03 hissy

Encountered the same issue. Here's a PR: https://github.com/concretecms/addon_migration_tool/pull/106

Saggre avatar Sep 12 '24 11:09 Saggre