Help for integrating the Laravel package
Forum rules: Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#4129 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 allphp 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 allphp 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.