Problem with setup. => Importing Data failed <=


#1

Hello guys,
I am trying out the Spryker demo shop by installing it on a private server.
So far the application works, but all the assets look missing.

I tried then to run a setup -i command, but here the procedure stops when it comes to Importing the data.

Here the full output of the setup command:

    which: no antelope in (/sbin:/bin:/usr/sbin:/usr/bin)

=> This script should be used only in development and NEVER IN PRODUCTION <=


-> Preparing to install Spryker Platform...


-> Setting up composer


-> Install Composer Dependencies

You are already using composer version 1.5.1 (stable channel).


-> Installing composer packages

Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Nothing to install or update
Package guzzle/guzzle is abandoned, you should avoid using it. Use guzzlehttp/guzzle instead.
Package sebastian/git is abandoned, you should avoid using it. No replacement was suggested.
Generating autoload files
> PhantomInstaller\Installer::installPhantomJS
/var/www/html/spryker.melvin-hamilton.store/public_html/vendor/bin/phantomjs: error while loading shared libraries: libfontconfig.so.1: cannot open shared object file: No such file or directory
Caught exception while checking PhantomJS version:
Undefined offset: 0
  - Installing phantomjs (2.1.1): Loading from cache

=> Zed setup <=


-> Stopping jenkins

Store: DE | Environment: development
Jenkins disabled (response: 403)


-> Flushing Elasticsearch index de_search

{"acknowledged":true}
-> Flushing Redis

OK
sudo: unknown user: postgres
sudo: unable to initialize policy plugin
Store: DE | Environment: development
Removed cache files
/var/www/html/spryker.melvin-hamilton.store/public_html/data/DE/cache
Removed auto-load cache files
Write propel config
Creating Database
Clean schema directory
Copy and merge schema files
Build propel models
Clean schema directory
Copy and merge schema files
Create diff
139 tables found in all databases.
Comparing models...
Same XML and database structures for all datasource - no diff to generate
Run migrations
All migrations were already executed - nothing to migrate.
Installing DB data for Price
Installing DB data for Locale
Installing DB data for Country
Installing DB data for User
Installing DB data for Acl
Installing DB data for Newsletter
Installing DB data for Glossary

-> Importing Data

Store: DE | Environment: development
Start "full" import
Propel\Runtime\Connection\Exception\RollbackException - Exception: Cannot commit because a nested transaction was rolled back
in /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php (230)

Command: vendor/bin/console data:import -v

Trace:
#0 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/spryker/data-import/src/Spryker/Zed/DataImport/Dependency/Propel/DataImportToPropelConnectionBridge.php(47): Propel\Runtime\Connection\ConnectionWrapper->commit()
#1 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/spryker/data-import/src/Spryker/Zed/DataImport/Business/Model/DataSet/DataSetStepBrokerTransactionAware.php(94): Spryker\Zed\DataImport\Dependency\Propel\DataImportToPropelConnectionBridge->endTransaction()
#2 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/spryker/data-import/src/Spryker/Zed/DataImport/Business/DataImportFacade.php(30): Spryker\Zed\DataImport\Business\Model\DataSet\DataSetStepBrokerTransactionAware->__destruct()
#3 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/spryker/data-import/src/Spryker/Zed/DataImport/Communication/Console/DataImportConsole.php(92): Spryker\Zed\DataImport\Business\DataImportFacade->import(Object(Generated\Shared\Transfer\DataImporterConfigurationTransfer))
#4 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/symfony/console/Command/Command.php(264): Spryker\Zed\DataImport\Communication\Console\DataImportConsole->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#5 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/symfony/console/Application.php(859): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#6 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/symfony/console/Application.php(206): Symfony\Component\Console\Application->doRunCommand(Object(Spryker\Zed\DataImport\Communication\Console\DataImportConsole), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#7 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/spryker/console/src/Spryker/Zed/Console/Communication/ConsoleBootstrap.php(132): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#8 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/symfony/console/Application.php(125): Spryker\Zed\Console\Communication\ConsoleBootstrap->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#9 /var/www/html/spryker.melvin-hamilton.store/public_html/vendor/spryker/console/bin/console(21): Symfony\Component\Console\Application->run()
#10 {main}
=> Importing Data failed <=


=> Command unsuccessful <=

#2

Ok… the main issue is that the demo shop doesn’t install over MySql.
Would be helpful to remark this in the readme


#3

Hi Enzo,
Thank your for the feedback, Spryker core is totally compatible with MySql, but our Demoshop as you mentioned in your post needs to be adjusted for it, we already did that and it’s under testing and we will release it in next days.
Thanks

Ehsan Zanjani
Spryker Core Developer


#4

Hi Enzo,

I would like to inform you that the mysql compatibility issue has been resolved and released, we recommended you to use MySql v5.7 or higher. Please use the latest version of Spryker Demoshop.

Best Regard

Ehsan Zanjani
Spryker Core Developer