Help for Aimeos

Hi,

When updating Aimeos Shop from 2019.07.x-dev to 2019.10.1 with composer update I get the following SQL error message.

Checking table "mshop_subscription":
In Simple.php line 94:

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 for the right syntax
to use near 'SMALLINT DEFAULT 0 NOT NULL, CHANGE `interval` `interval` VARCHAR(32) NOT NULL' at line 1: ALTER TABLE mshop_subscription ADD productid VARCHAR(36) NOT NULL, ADD perio
d SMALLINT DEFAULT 0 NOT NULL, CHANGE `interval` `interval` VARCHAR(32) NOT NULL

What can I do?

Thank your for your help.
--
aimeos: 2019.07.x-dev
symfony: 4.3
php: 7.2
ubuntu: 18

Seems like the "period" column name is treated as a reserved word. Do you use MariaDB <= 10.3.6 in Oracle mode?
https://mariadb.com/kb/en/library/reser ... racle-mode

Seems like the "period" column name is treated as a reserved word. Do you use MariaDB <= 10.3.6 in Oracle mode?

No, I use MariaDB 10.3.18 and the sql_mode is STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION.

But the cause of the failure is nevertheless the unmasked identifier period. When I first excecute in the mysql shell the command ALTER TABLE mshop_subscription ADD productid VARCHAR (36) NOT NULL, ADD `period` SMALLINT DEFAULT 0 NOT NULL, CHANGE` interval` `interval` VARCHAR (32) NOT NULL; then composer update runs without error.

Is it possible to change the source code?

We can't change the code because the SQL is generated by Doctrine DBAL and the problem must be somewhere around here:
https://github.com/doctrine/dbal/blob/2 ... m.php#L553

Does this also happen if you set up 2019.10 from scratch?

No.

The error does not occur with a new installation. It only occurs during an update.