Error when running artisan aimeos:setup in a new project with latest Laravel(12)

[jamesallan93]

Environment
Version (2025.07)
Operating system (Linux)
Laravel(12.0) -Sail,

Describe the bug
I am trying to do a fresh install of aimeos.

To Reproduce
Steps to reproduce the behavior:

1. Install laravel(12.0) sail: curl -s "https://laravel.build/example-app?with=mysql,mailpit,minio,typesense,memcached,soketi" | bash
2. Composer require aimeos/aimeos-laravel
3. Run: artisan vendor:publish --tag=config --tag=public
4. Added to composer json, just like the instructions:
   "post-update-cmd": [ "@php artisan vendor:publish --tag=laravel-assets --ansi --force", "@php artisan vendor:publish --tag=public --ansi", //<==this "\\Aimeos\\Shop\\Composer::join" //<==this ]
5. Run: sail composer update -W
6. Run: sail artisan migrations
7. Run: sail artisan aimeos:setup

Expected behavior
Followed the instructions, and also tried other ways, all leads to same issue.

Screenshots

Additional context
Logs:

[2025-09-01 06:16:54] local.ERROR: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `type` VARCHAR(64) ' at line 1 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 1064): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `type` VARCHAR(64) ' at line 1 at /var/www/html/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)
[stacktrace]
#0 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1456): Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter->convert()
#1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1392): Doctrine\\DBAL\\Connection->handleDriverException()
#2 /var/www/html/vendor/doctrine/dbal/src/Connection.php(911): Doctrine\\DBAL\\Connection->convertExceptionDuringQuery()
#3 /var/www/html/vendor/aimeos/upscheme/src/Schema/DB.php(826): Doctrine\\DBAL\\Connection->executeStatement()
#4 /var/www/html/vendor/aimeos/upscheme/src/Up.php(367): Aimeos\\Upscheme\\Schema\\DB->up()
#5 /var/www/html/vendor/aimeos/upscheme/src/Up.php(191): Aimeos\\Upscheme\\Up->runTasks()
#6 /var/www/html/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#7 /var/www/html/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(836): Illuminate\\Container\\BoundMethod::call()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
#14 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\\Console\\Command->execute()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
#16 /var/www/html/vendor/symfony/console/Application.php(1110): Illuminate\\Console\\Command->run()
#17 /var/www/html/vendor/symfony/console/Application.php(359): Symfony\\Component\\Console\\Application->doRunCommand()
#18 /var/www/html/vendor/symfony/console/Application.php(194): Symfony\\Component\\Console\\Application->doRun()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\\Foundation\\Console\\Kernel->handle()
#21 /var/www/html/artisan(16): Illuminate\\Foundation\\Application->handleCommand()
#22 {main}

[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1064): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `type` VARCHAR(64) ' at line 1 at /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)
[stacktrace]
#0 /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(33): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()
#1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(909): Doctrine\\DBAL\\Driver\\PDO\\Connection->exec()
#2 /var/www/html/vendor/aimeos/upscheme/src/Schema/DB.php(826): Doctrine\\DBAL\\Connection->executeStatement()
#3 /var/www/html/vendor/aimeos/upscheme/src/Up.php(367): Aimeos\\Upscheme\\Schema\\DB->up()
#4 /var/www/html/vendor/aimeos/upscheme/src/Up.php(191): Aimeos\\Upscheme\\Up->runTasks()
#5 /var/www/html/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#6 /var/www/html/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(836): Illuminate\\Container\\BoundMethod::call()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
#13 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\\Console\\Command->execute()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
#15 /var/www/html/vendor/symfony/console/Application.php(1110): Illuminate\\Console\\Command->run()
#16 /var/www/html/vendor/symfony/console/Application.php(359): Symfony\\Component\\Console\\Application->doRunCommand()
#17 /var/www/html/vendor/symfony/console/Application.php(194): Symfony\\Component\\Console\\Application->doRun()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\\Foundation\\Console\\Kernel->handle()
#20 /var/www/html/artisan(16): Illuminate\\Foundation\\Application->handleCommand()
#21 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `type` VARCHAR(64) ' at line 1 at /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:27)
[stacktrace]
#0 /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(27): PDO->exec()
#1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(909): Doctrine\\DBAL\\Driver\\PDO\\Connection->exec()
#2 /var/www/html/vendor/aimeos/upscheme/src/Schema/DB.php(826): Doctrine\\DBAL\\Connection->executeStatement()
#3 /var/www/html/vendor/aimeos/upscheme/src/Up.php(367): Aimeos\\Upscheme\\Schema\\DB->up()
#4 /var/www/html/vendor/aimeos/upscheme/src/Up.php(191): Aimeos\\Upscheme\\Up->runTasks()
#5 /var/www/html/vendor/aimeos/aimeos-core/Setup.php(84): Aimeos\\Upscheme\\Up->up()
#6 /var/www/html/vendor/aimeos/aimeos-laravel/src/Command/SetupCommand.php(65): Aimeos\\Setup->up()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Aimeos\\Shop\\Command\\SetupCommand->handle()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(836): Illuminate\\Container\\BoundMethod::call()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
#13 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\\Console\\Command->execute()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
#15 /var/www/html/vendor/symfony/console/Application.php(1110): Illuminate\\Console\\Command->run()
#16 /var/www/html/vendor/symfony/console/Application.php(359): Symfony\\Component\\Console\\Application->doRunCommand()
#17 /var/www/html/vendor/symfony/console/Application.php(194): Symfony\\Component\\Console\\Application->doRun()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\\Foundation\\Console\\Kernel->handle()
#20 /var/www/html/artisan(16): Illuminate\\Foundation\\Application->handleCommand()
#21 {main}
"} 

[aimeos]

Which MySQL version are you using?

[jamesallan93]

Which MySQL version

I'm using version 8.0.

[aimeos]

All MySQL versions above 5.8 are well supported by Aimeos and also utf8mb4 is supported by MySQL 8 so it's not clear what Laravel Sail does different compared to a standard setup. Can you check if the create table statement can be executed manually in that MySQL instance?