./bin/setup fails with MariaDB v10.5

[okafiwa]

I run MariaDB version 10.5.10 on Ubuntu 18.04.5 LTS. I tried both the release version v6.4.0.0 of Shopware and the latest available with git clone.

I dropped and recreated the databases shopware, shopware_test and shopware_e2e before I ran the Shopware setup script. First error message I encounter is:

ERROR     [app] Migration: "Shopware\Core\Migration\V6_3\Migration1563805586AddLanguageToOrder" fai
led: "An exception occurred while executing 'ALTER TABLE `order` MODIFY COLUMN `language_id` BINARY(16) NOT NULL':
SQLSTATE[42S22]: Column not found: 1054 Unknown column '`shopware`.`o`.`price`' in 'CHECK'"

I assume this is related to the MariaDB bug MDEV-25672 but I don't get what to do to work around this bug.

[shyim]

The only way is to downgrade currently

[shyim]

Update to latest version