Cannot Setup Aimeos with PostgreSQL

Help for integrating the Laravel package
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!
VickoNovianto
Posts: 7
Joined: 16 Apr 2017, 00:35

Cannot Setup Aimeos with PostgreSQL

Post by VickoNovianto » 16 Apr 2017, 02:38

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

Code: Select all

php artisan vendor:publish
, I changed the file config/shop.php into :

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',
	            ),
	        ),
	    ),
	),
And then I entered

Code: Select all

php artisan aimeos:setup --option=setup/default/demo:1
, but en error occured, the error is :

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" 
Why is this occured? Thank you.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Cannot Setup Aimeos with PostgreSQL

Post by aimeos » 16 Apr 2017, 10:46

Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply