Solved: installing with web Magento Installer 2.1.6 with s...

rcveen · ‎05-09-2017

I try to install magento 2.1.6 with sample data. but after entering all input and running input I get an error.

Starting Magento installation:
File permissions check...

Required extensions check...

Enabling Maintenance Mode...

Installing deployment configuration...
Upgrading schema...

Module 'Magento_CatalogUrlRewrite':
Installing schema...

Module 'Magento_Widget':
Installing schema...
Installing database schema:

Module 'Magento_SalesSequence':
Installing schema... Schema creation/updates:
Module 'Magento_Store':

Module 'Magento_AdvancedPricingImportExport':

Module 'Magento_Directory':

Module 'Magento_Theme':

Module 'Magento_Backend':

Module 'Magento_Backup':

Module 'Magento_Eav':

Module 'Magento_Customer':

Module 'Magento_BundleImportExport':

Module 'Magento_AdminNotification':

Module 'Magento_CacheInvalidate':

Module 'Magento_Indexer':

Module 'Magento_Cms':

Module 'Magento_CatalogImportExport':

Module 'Magento_Catalog':

Module 'Magento_Rule':

Module 'Magento_Msrp':

Module 'Magento_Search':

Module 'Magento_Bundle':

Module 'Magento_Quote':

Module 'Magento_CatalogUrlRewrite':

Module 'Magento_Widget':

Module 'Magento_SalesSequence':
Installing schema...
[ERROR] PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Magento_SalesSequence' for key 'PRIMARY' in /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/quiniv/mag/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#3 /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `q5...', Array)
#5 /var/www/quiniv/mag/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(465): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `q5...', Array)
#6 /var/www/quiniv/mag/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(520): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('INSERT INTO `q5...', Array)
#7 /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(576): Magento\Framework\DB\Adapter\Pdo\Mysql->query('INSERT INTO `q5...', Array)
#8 /var/www/quiniv/mag/vendor/magento/framework/Module/ModuleResource.php(104): Zend_Db_Adapter_Abstract->insert('q5_setup_module', Array)
#9 /var/www/quiniv/mag/setup/src/Magento/Setup/Model/Installer.php(852): Magento\Framework\Module\ModuleResource->setDbVersion('Magento_SalesSe...', '2.0.0')
#10 /var/www/quiniv/mag/setup/src/Magento/Setup/Model/Installer.php(779): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
#11 [internal function]: Magento\Setup\Model\Installer->installSchema()
#12 /var/www/quiniv/mag/setup/src/Magento/Setup/Model/Installer.php(344): call_user_func_array(Array, Array)
#13 /var/www/quiniv/mag/setup/src/Magento/Setup/Controller/Install.php(109): Magento\Setup\Model\Installer->install(Array)
#14 /var/www/quiniv/mag/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#15 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#16 /var/www/quiniv/mag/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#17 /var/www/quiniv/mag/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#18 /var/www/quiniv/mag/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#19 /var/www/quiniv/mag/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#20 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#21 /var/www/quiniv/mag/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#22 /var/www/quiniv/mag/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#23 /var/www/quiniv/mag/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#24 /var/www/quiniv/mag/setup/index.php(31): Zend\Mvc\Application->run()
#25 {main}

Next Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Magento_SalesSequence' for key 'PRIMARY', query was: INSERT INTO `q5_setup_module` (`module`, `schema_version`) VALUES (?, ?) in /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /var/www/quiniv/mag/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#2 /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `q5...', Array)
#4 /var/www/quiniv/mag/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(465): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `q5...', Array)
#5 /var/www/quiniv/mag/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(520): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('INSERT INTO `q5...', Array)
#6 /var/www/quiniv/mag/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(576): Magento\Framework\DB\Adapter\Pdo\Mysql->query('INSERT INTO `q5...', Array)
#7 /var/www/quiniv/mag/vendor/magento/framework/Module/ModuleResource.php(104): Zend_Db_Adapter_Abstract->insert('q5_setup_module', Array)
#8 /var/www/quiniv/mag/setup/src/Magento/Setup/Model/Installer.php(852): Magento\Framework\Module\ModuleResource->setDbVersion('Magento_SalesSe...', '2.0.0')
#9 /var/www/quiniv/mag/setup/src/Magento/Setup/Model/Installer.php(779): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
#10 [internal function]: Magento\Setup\Model\Installer->installSchema()
#11 /var/www/quiniv/mag/setup/src/Magento/Setup/Model/Installer.php(344): call_user_func_array(Array, Array)
#12 /var/www/quiniv/mag/setup/src/Magento/Setup/Controller/Install.php(109): Magento\Setup\Model\Installer->install(Array)
#13 /var/www/quiniv/mag/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#14 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#15 /var/www/quiniv/mag/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#16 /var/www/quiniv/mag/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#17 /var/www/quiniv/mag/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#18 /var/www/quiniv/mag/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#19 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#20 /var/www/quiniv/mag/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#21 /var/www/quiniv/mag/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#22 /var/www/quiniv/mag/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#23 /var/www/quiniv/mag/setup/index.php(31): Zend\Mvc\Application->run()
#24 {main}

Module 'Magento_CheckoutAgreements':
Installing schema... Upgrading schema...

Module 'Magento_Payment':

Module 'Magento_SampleData':

Module 'Magento_CmsUrlRewrite':

Module 'Magento_Config':
Installing schema...

Module 'Magento_ConfigurableImportExport':

Module 'Magento_Downloadable':
Installing schema...

This is my os and software:

root@robmagento:/var/www/quiniv# mysql -V

mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper

root@robmagento:/var/www/quiniv/mag1# php -v

PHP 7.0.18-1~dotdeb+8.1 (cli) ( NTS )

root@robmagento:/var/www/quiniv# apachectl -V

AH00557: apache2: apr_sockaddr_info_get() failed for robmagento

AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1. Set the 'ServerName' directive globally to suppress this message

Server version: Apache/2.4.10 (Debian)

Server built: Feb 24 2017 18:40:28

Server's Module Magic Number: 20120211:37

Server loaded: APR 1.5.1, APR-UTIL 1.5.4

Compiled using: APR 1.5.1, APR-UTIL 1.5.4

Architecture: 64-bit

Server MPM: prefork

threaded: no

forked: yes (variable process count)

Server compiled with....

-D APR_HAS_SENDFILE

-D APR_HAS_MMAP

-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)

-D APR_USE_SYSVSEM_SERIALIZE

-D APR_USE_PTHREAD_SERIALIZE

-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT

-D APR_HAS_OTHER_CHILD

-D AP_HAVE_RELIABLE_PIPED_LOGS

-D DYNAMIC_MODULE_LIMIT=256

-D HTTPD_ROOT="/etc/apache2"

-D SUEXEC_BIN="/usr/lib/apache2/suexec"

-D DEFAULT_PIDLOG="/var/run/apache2.pid"

-D DEFAULT_SCOREBOARD="logs/apache_runtime_status"

-D DEFAULT_ERRORLOG="logs/error_log"

-D AP_TYPES_CONFIG_FILE="mime.types"

-D SERVER_CONFIG_FILE="apache2.conf”

root@robmagento:/var/www/quiniv# cat /etc/os-release

PRETTY_NAME="Debian GNU/Linux 8 (jessie)"

NAME="Debian GNU/Linux"

VERSION_ID="8"

VERSION="8 (jessie)"

ID=debian

HOME_URL="http://www.debian.org/"

SUPPORT_URL="http://www.debian.org/support"

BUG_REPORT_URL="https://bugs.debian.org/"

rcveen · ‎05-12-2017

ok I fixed it.
what I did.
#I removed everything.
cd <magentoDIR>
#installed it again
gunzip < files.tar.ga | tar xvf -

#dropped my database and created my database with mysql

mysql -u root -p
drop database dbName
create database dbName

#then I installed it with a a script from the shell

#enable magento

chmod u+x bin/magento

./bin/magento setup:install --base-url=http://127.0.0.1/magento2/ \ --db-host=localhost --db-name=magento --db-user=magento --db-password=magento \ --admin-firstname=Magento --admin-lastname=User --admin-email=user@example.com \ --admin-user=admin --admin-password=admin123 --language=en_US \ --currency=USD --timezone=America/Chicago --use-rewrites=1

#correct all rights

chown -R www-data:www-data *

# I had still that same issieu with that I had a version name in my js and css call but my shop was enabled still js and gif's not shown because rewrites were not working.

# the fix for that: enable the rewrite module since all .htaccess were there !!!

a2enmod rewrite

# restart apache

service apache2 restart

# DONE now not alle my pictures are still not shown in my frontend.. so my cache is not updated !

Those steps are already explained elsewhere :-)

View solution in original post

rcveen · ‎05-10-2017

A small update:
I found the problem that the default install stopped but I run inanother problem.

first the solution for me was: stick to the defaults.

so no timezone selection/ language selection et all. just keep the en_US

then it will run further but also stops on it way.

Then I did the following

correct all the rights:

find . -type f -exec chmod 644 {} \;

find . -type d -exec chmod 755 {} \;

find ./var -type d -exec chmod 777 {} \;

find ./pub/media -type d -exec chmod 777 {} \;

find ./pub/static -type d -exec chmod 777 {} \;

chmod 777 app/etc

chmod 644 ./app/etc/*.xml

chmod u+x bin/magento

chown -R www-data:www-data *.*

chown -R www-data:www-data .*

I found a problem that still some version number was seen in my code and no images etc..

this was fixed with

php bin/magento -vvv setup:static-content:deploy en_US

./bin/magento -vvv cache:flush

./bin/magento -vvv sampledata:deploy

./bin/magento -vvv setup:di:compile

chown -R www-data:www-data *.*

Still now the problem I face is that my static pages ar not functioning and also my admin page is not working.

so no <SITE>/men/tops-men.html

and no <Site>/adminpage

what todo with that ??

rcveen · ‎05-12-2017

ok I fixed it.
what I did.
#I removed everything.
cd <magentoDIR>
#installed it again
gunzip < files.tar.ga | tar xvf -

#dropped my database and created my database with mysql

mysql -u root -p
drop database dbName
create database dbName

#then I installed it with a a script from the shell

#enable magento

chmod u+x bin/magento

./bin/magento setup:install --base-url=http://127.0.0.1/magento2/ \ --db-host=localhost --db-name=magento --db-user=magento --db-password=magento \ --admin-firstname=Magento --admin-lastname=User --admin-email=user@example.com \ --admin-user=admin --admin-password=admin123 --language=en_US \ --currency=USD --timezone=America/Chicago --use-rewrites=1

#correct all rights

chown -R www-data:www-data *

# I had still that same issieu with that I had a version name in my js and css call but my shop was enabled still js and gif's not shown because rewrites were not working.

# the fix for that: enable the rewrite module since all .htaccess were there !!!

a2enmod rewrite

# restart apache

service apache2 restart

# DONE now not alle my pictures are still not shown in my frontend.. so my cache is not updated !

Those steps are already explained elsewhere :-)

installing with web Magento Installer 2.1.6 with sample data Installation crashes.

installing with web Magento Installer 2.1.6 with sample data Installation crashes.

Re: installing with web Magento Installer 2.1.6 with sample data Installation crashes.

Re: installing with web Magento Installer 2.1.6 with sample data Installation crashes.

Re: installing with web Magento Installer 2.1.6 with sample data Installation crashes.