Cannot Setup Aimeos with PostgreSQL
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: 7
- Joined: 16 Apr 2017, 00:35
Cannot Setup Aimeos with PostgreSQL
I use Aimeos 2017.04 with PostgreSQL 9.6.2 and Laravel 5.4 with PHP 7.1.1. I use Windows 8 Pro. After I entered , I changed the file config/shop.php into :
And then I entered , but en error occured, the error is :
Why is this occured? Thank you.
Code: Select all
php artisan vendor:publish
Code: Select all
'resource' => array(
'db' => array(
'adapter' => env('DB_CONNECTION', 'pgsql'),
'host' => env('DB_HOST', 'localhost'),
'port' => env('DB_PORT', '5432'),
'socket' => '',
'database' => env('DB_DATABASE', 'marketplace'),
'username' => env('DB_USERNAME', 'postgres'),
'password' => env('DB_PASSWORD', '***'),
'stmt' => null,
),
),
'mshop' => array(
'index' => array(
'manager' => array(
'name' => 'PgSQL',
'attribute' => null,
'catalog' => null,
'price' => null,
'text' => array(
'name' => 'PgSQL',
),
),
),
),
Code: Select all
php artisan aimeos:setup --option=setup/default/demo:1
Code: Select all
[Aimeos\MW\DB\Exception]
Executing statement "SET SESSION sql_mode='ANSI'" failed: An exception occurred while executi ng 'SET SESSION sql_mode='ANSI'':
SQLSTATE[42704]: Undefined object: 7 ERROR: unrecognized configuration parameter "sql_mode"
Re: Cannot Setup Aimeos with PostgreSQL
Please have a look at https://github.com/aimeos/aimeos-laravel/issues/118
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star