Error during install demo data

D-Cell · Post by **D-Cell** » 17 Dec 2018, 18:14

Hi everyone! Hope someone can help me to fix my problem.
I would like to try Aimeos on my localhost.

Configuration is Linux Fedora 28, PHP 7.2.13, Mariadb 10.2.19, Nginx.

I followed all instructions from docs and tried to install Aimeos both ways:
- Install as a separate package - composer create-project aimeos/aimeos .
- Install Aimeos 2018.10.3 on clean laravel 5.7 skeleton application

But each time i try to install demo data i`m getting error:
-------------------------------------
Creating base tables
Using schema from locale.php
Checking table "mshop_locale_site":
In MySqlSchemaManager.php line 315:

Type error: Argument 1 passed to Doctrine\DBAL\Schema\MySqlSchemaManager::p
arseCreateOptions() must be of the type string, null given, called in /var/
www/aimeos.local/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/M
ySqlSchemaManager.php on line 307
------------------------------------

I`ll be appreciate for any help.
Best regards to everyone!

D-Cell · Post by **D-Cell** » 17 Dec 2018, 22:11

This is what i get after i run "php artisan aimeos:setup --option=setup/default/demo:1" when install on clean Laravel:

Code: Select all

/*Console output is too long, so i provide only the part with error*/
...
Migrating order type                                                  
  Checking table "mshop_order":                                       OK
Remove left over Laravel user address records                         OK
Remove left over Laravel user list records                            OK
Creating base tables                                                  
  Using schema from locale.php                                        
    Checking table "mshop_locale_site":                               
   Symfony\Component\Debug\Exception\FatalThrowableError  : Argument 1 passed to Doctrine\DBAL\Schema\MySqlSchemaManager::parseCreateOptions() must be of the type string, null given, called in /var/www/aimeos.local/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/MySqlSchemaManager.php on line 307

  at /var/www/aimeos.local/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/MySqlSchemaManager.php:315
    311| 
    312|     /**
    313|      * @return string[]|true[]
    314|      */
  > 315|     private function parseCreateOptions(string $string) : array
    316|     {
    317|         $options = [];
    318| 
    319|         if ($string === '') {

  Exception trace:

  1   Doctrine\DBAL\Schema\MySqlSchemaManager::parseCreateOptions()
      /var/www/aimeos.local/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/MySqlSchemaManager.php:307

  2   Doctrine\DBAL\Schema\MySqlSchemaManager::listTableDetails("mshop_locale_site")
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesCreateMShop.php:190

  Please use the argument -v to see more details.

D-Cell · Post by **D-Cell** » 17 Dec 2018, 22:25

Here is verbose output:

Code: Select all

Exception trace:

  1   Doctrine\DBAL\Schema\MySqlSchemaManager::parseCreateOptions()
      /var/www/aimeos.local/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/MySqlSchemaManager.php:307

  2   Doctrine\DBAL\Schema\MySqlSchemaManager::listTableDetails("mshop_locale_site")
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesCreateMShop.php:190

  3   Aimeos\MW\Setup\Task\TablesCreateMShop::setupSchema()
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesCreateMShop.php:107

  4   Aimeos\MW\Setup\Task\TablesCreateMShop::migrate()
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php:174

  5   Aimeos\MW\Setup\Manager\Multiple::migrateTasks()
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php:170

  6   Aimeos\MW\Setup\Manager\Multiple::migrateTasks()
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php:170

  7   Aimeos\MW\Setup\Manager\Multiple::migrateTasks()
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php:170

  8   Aimeos\MW\Setup\Manager\Multiple::migrateTasks()
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php:170

  9   Aimeos\MW\Setup\Manager\Multiple::migrateTasks()
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php:170

  10  Aimeos\MW\Setup\Manager\Multiple::migrateTasks()
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php:96

  11  Aimeos\MW\Setup\Manager\Multiple::migrate(Object(Aimeos\MW\Setup\Task\MShopAddAttributeData))
      /var/www/aimeos.local/public_html/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Command/SetupCommand.php:75

  12  Aimeos\Shop\Command\SetupCommand::handle()
      /var/www/aimeos.local/public_html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:29

  13  call_user_func_array([])
      /var/www/aimeos.local/public_html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:29

  14  Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
      /var/www/aimeos.local/public_html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:87

  15  Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Object(Closure))
      /var/www/aimeos.local/public_html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:31

  16  Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), [])
      /var/www/aimeos.local/public_html/vendor/laravel/framework/src/Illuminate/Container/Container.php:572

  17  Illuminate\Container\Container::call()
      /var/www/aimeos.local/public_html/vendor/laravel/framework/src/Illuminate/Console/Command.php:183

  18  Illuminate\Console\Command::execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
      /var/www/aimeos.local/public_html/vendor/symfony/console/Command/Command.php:255

  19  Symfony\Component\Console\Command\Command::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
      /var/www/aimeos.local/public_html/vendor/laravel/framework/src/Illuminate/Console/Command.php:170

  20  Illuminate\Console\Command::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /var/www/aimeos.local/public_html/vendor/symfony/console/Application.php:901

  21  Symfony\Component\Console\Application::doRunCommand(Object(Aimeos\Shop\Command\SetupCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /var/www/aimeos.local/public_html/vendor/symfony/console/Application.php:262

  22  Symfony\Component\Console\Application::doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /var/www/aimeos.local/public_html/vendor/symfony/console/Application.php:145

  23  Symfony\Component\Console\Application::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /var/www/aimeos.local/public_html/vendor/laravel/framework/src/Illuminate/Console/Application.php:89

  24  Illuminate\Console\Application::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /var/www/aimeos.local/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:122

  25  Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /var/www/aimeos.local/public_html/artisan:37

Post by **aimeos** » 17 Dec 2018, 22:28

That's a bug in the current Doctrine DBAL library (2.9.1):
https://github.com/doctrine/dbal/issues/3410

You can add this to your composer.json file to use the previous version instead until a new one is released:

Code: Select all

"doctrine/dbal": "v2.9.0"

D-Cell · Post by **D-Cell** » 18 Dec 2018, 08:49

aimeos wrote:That's a bug in the current Doctrine DBAL library (2.9.1):
https://github.com/doctrine/dbal/issues/3410

You can add this to your composer.json file to use the previous version instead until a new one is released:
Code: Select all
"doctrine/dbal": "v2.9.0"

Thank you! Your solution works perfect! I`ll give you a star on github!

Nofnof · Post by **Nofnof** » 18 Dec 2018, 11:00

Here to say thank you too, I was trying to install the package for 2 hours and the solution is finally there

Help for Aimeos