Fresh Setup

[syedaliiftikhar]

When I run
php artisan aimeos:setup
or
php artisan aimeos:setup --option=setup/default/demo:1

It gives me following error:

Migrating: vendor/aimeos/aimeos-core/setup/Customer.php

Doctrine\DBAL\Exception\SyntaxErrorException

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`, `company` VARCHAR(1' at line 1

at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:86
82▕ case 1479:
83▕ case 1541:
84▕ case 1554:
85▕ case 1626:
➜ 86▕ return new SyntaxErrorException($exception, $query);
87▕
88▕ case 1044:
89▕ case 1045:
90▕ case 1046:

+25 vendor frames

26 artisan:35
Illuminate\Foundation\Console\Kernel::handle()

[aimeos]

Which Aimeos version do you use and what is the version of your MySQL server?

[syedaliiftikhar]

The problem has been resolved by adjusting the configuration settings. I was migrating woocommerce data using your ai-woocommerce extension.
I made modifications in the 'config/shop' file as per extension docs.

'resource' => [
'db-woocommerce' => [
'adapter' => 'mysql',
'host' => '127.0.0.1',
'port' => '3306',
'database' => 'wordpress',
'username' => 'wp_db_user',
'password' => 'wp_password',
],
// existing DB connection settings
],

When I followed the extension documentation, it resulted in that error. However, when I moved it after the existing database configuration, everything worked smoothly.


Laravel 11.4.0
Aimeos 2024.4
PHP 8.3.6
Ubuntu 20.04.3 LTS