Fresh Setup
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Posts: 13
- Joined: 19 Apr 2024, 18:29
Fresh Setup
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()
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()
Re: Fresh Setup
Which Aimeos version do you use and what is the version of your MySQL server?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos,
give us a star
If you like Aimeos,
![Image](https://aimeos.org/fileadmin/aimeos.org/icons/star.png)
-
- Posts: 13
- Joined: 19 Apr 2024, 18:29
Re: Fresh Setup
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
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