{"action":"created","issue":{"url":"https://api.github.com/repos/magento/magento2/issues/1550","labels_url":"https://api.github.com/repos/magento/magento2/issues/1550/labels{/name}","comments_url":"https://api.github.com/repos/magento/magento2/issues/1550/comments","events_url":"https://api.github.com/repos/magento/magento2/issues/1550/events","html_url":"https://github.com/magento/magento2/issues/1550","id":96832775,"number":1550,"title":"Magento Installation Error on Mac OS 10.7 Lion with php 5.5, MySQL 5.6","user":{"login":"Galch24","id":1256942,"avatar_url":"https://avatars.githubusercontent.com/u/1256942?v=3","gravatar_id":"","url":"https://api.github.com/users/Galch24","html_url":"https://github.com/Galch24","followers_url":"https://api.github.com/users/Galch24/followers","following_url":"https://api.github.com/users/Galch24/following{/other_user}","gists_url":"https://api.github.com/users/Galch24/gists{/gist_id}","starred_url":"https://api.github.com/users/Galch24/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Galch24/subscriptions","organizations_url":"https://api.github.com/users/Galch24/orgs","repos_url":"https://api.github.com/users/Galch24/repos","events_url":"https://api.github.com/users/Galch24/events{/privacy}","received_events_url":"https://api.github.com/users/Galch24/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/magento/magento2/labels/bug","name":"bug","color":"eb6420"},{"url":"https://api.github.com/repos/magento/magento2/labels/PS","name":"PS","color":"fad8c7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-07-23T14:52:19Z","updated_at":"2015-07-24T15:32:51Z","closed_at":null,"body":"Starting Magento installation:\r\nFile permissions check...\r\n\r\nEnabling Maintenance Mode...\r\n\r\nInstalling deployment configuration...\r\n\r\nInstalling database schema:\r\nSchema creation/updates:\r\nModule 'Magento_Store':\r\n\r\nModule 'Magento_Directory':\r\n\r\nModule 'Magento_Theme':\r\n\r\nModule 'Magento_Backend':\r\n\r\nModule 'Magento_Backup':\r\n\r\nModule 'Magento_Eav':\r\nInstalling schema..\r\n[ERROR] exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause' in /Users/Galina/Sites/magento2.lan/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228\r\nStack trace:\r\n#0 /Users/Galina/Sites/magento2.lan/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)\r\n#1 /Users/Galina/Sites/magento2.lan/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)\r\n#2 /Users/Galina/Sites/magento2.lan/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\\Framework\\DB\\Statement\\Pdo\\Mysql->_execute(Array)\r\n#3 /Users/Galina/Sites/magento2.lan/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)\r\n#4 /Users/Galina/Sites/magento2.lan/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...', Array)\r\n#5 /Users/Galina/Sites/magento2.lan/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(433): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE IF...', Array)\r\n#6 /Users/Galina/Sites/magento2.lan/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(488): Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->_query('CREATE TABLE IF...', Array)\r\n#7 /Users/Galina/Sites/magento2.lan/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(1974): Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->query('CREATE TABLE IF...')\r\n#8 /Users/Galina/Sites/magento2.lan/app/code/Magento/Eav/Setup/InstallSchema.php(217): Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->createTable(Object(Magento\\Framework\\DB\\Ddl\\Table))\r\n#9 /Users/Galina/Sites/magento2.lan/setup/src/Magento/Setup/Model/Installer.php(761): Magento\\Eav\\Setup\\InstallSchema->install(Object(Magento\\Setup\\Module\\Setup), Object(Magento\\Setup\\Model\\ModuleContext))\r\n#10 /Users/Galina/Sites/magento2.lan/setup/src/Magento/Setup/Model/Installer.php(695): Magento\\Setup\\Model\\Installer->handleDBSchemaData(Object(Magento\\Setup\\Module\\Setup), 'schema')\r\n#11 [internal function]: Magento\\Setup\\Model\\Installer->installSchema()\r\n#12 /Users/Galina/Sites/magento2.lan/setup/src/Magento/Setup/Model/Installer.php(298): call_user_func_array(Array, Array)\r\n#13 /Users/Galina/Sites/magento2.lan/setup/src/Magento/Setup/Controller/Install.php(87): Magento\\Setup\\Model\\Installer->install(Array)\r\n#14 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\\Setup\\Controller\\Install->startAction()\r\n#15 [internal function]: Zend\\Mvc\\Controller\\AbstractActionController->onDispatch(Object(Zend\\Mvc\\MvcEvent))\r\n#16 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\\Mvc\\MvcEvent))\r\n#17 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\\EventManager\\EventManager->triggerListeners('dispatch', Object(Zend\\Mvc\\MvcEvent), Object(Closure))\r\n#18 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\\EventManager\\EventManager->trigger('dispatch', Object(Zend\\Mvc\\MvcEvent), Object(Closure))\r\n#19 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\\Mvc\\Controller\\AbstractController->dispatch(Object(Zend\\Http\\PhpEnvironment\\Request), Object(Zend\\Http\\PhpEnvironment\\Response))\r\n#20 [internal function]: Zend\\Mvc\\DispatchListener->onDispatch(Object(Zend\\Mvc\\MvcEvent))\r\n#21 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\\Mvc\\MvcEvent))\r\n#22 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\\EventManager\\EventManager->triggerListeners('dispatch', Object(Zend\\Mvc\\MvcEvent), Object(Closure))\r\n#23 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\\EventManager\\EventManager->trigger('dispatch', Object(Zend\\Mvc\\MvcEvent), Object(Closure))\r\n#24 /Users/Galina/Sites/magento2.lan/setup/index.php(31): Zend\\Mvc\\Application->run()\r\n#25 {main}\r\n\r\nNext exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause, query was: CREATE TABLE IF NOT EXISTS `eav_entity` (\r\n`entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id' ,\r\n`entity_type_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Entity Type Id' ,\r\n`attribute_set_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Set Id' ,\r\n`increment_id` varchar(50) NULL default NULL COMMENT 'Increment Id' ,\r\n`parent_id` int UNSIGNED NOT NULL default '0' COMMENT 'Parent Id' ,\r\n`store_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Store Id' ,\r\n`created_at` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT 'Created At' ,\r\n`updated_at` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At' ,\r\n`is_active` smallint UNSIGNED NOT NULL default '1' COMMENT 'Defines Is Entity Active' ,\r\nPRIMARY KEY (`entity_id`),\r\nINDEX `EAV_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),\r\nINDEX `EAV_ENTITY_STORE_ID` (`store_id`),\r\nCONSTRAINT `EAV_ENTITY_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE,\r\nCONSTRAINT `EAV_ENTITY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE\r\n) COMMENT='Eav Entity' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci' in /Users/Galina/Sites/magento2.lan/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235\r\nStack trace:\r\n#0 /Users/Galina/Sites/magento2.lan/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)\r\n#1 /Users/Galina/Sites/magento2.lan/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\\Framework\\DB\\Statement\\Pdo\\Mysql->_execute(Array)\r\n#2 /Users/Galina/Sites/magento2.lan/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)\r\n#3 /Users/Galina/Sites/magento2.lan/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...', Array)\r\n#4 /Users/Galina/Sites/magento2.lan/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(433): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE IF...', Array)\r\n#5 /Users/Galina/Sites/magento2.lan/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(488): Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->_query('CREATE TABLE IF...', Array)\r\n#6 /Users/Galina/Sites/magento2.lan/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(1974): Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->query('CREATE TABLE IF...')\r\n#7 /Users/Galina/Sites/magento2.lan/app/code/Magento/Eav/Setup/InstallSchema.php(217): Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->createTable(Object(Magento\\Framework\\DB\\Ddl\\Table))\r\n#8 /Users/Galina/Sites/magento2.lan/setup/src/Magento/Setup/Model/Installer.php(761): Magento\\Eav\\Setup\\InstallSchema->install(Object(Magento\\Setup\\Module\\Setup), Object(Magento\\Setup\\Model\\ModuleContext))\r\n#9 /Users/Galina/Sites/magento2.lan/setup/src/Magento/Setup/Model/Installer.php(695): Magento\\Setup\\Model\\Installer->handleDBSchemaData(Object(Magento\\Setup\\Module\\Setup), 'schema')\r\n#10 [internal function]: Magento\\Setup\\Model\\Installer->installSchema()\r\n#11 /Users/Galina/Sites/magento2.lan/setup/src/Magento/Setup/Model/Installer.php(298): call_user_func_array(Array, Array)\r\n#12 /Users/Galina/Sites/magento2.lan/setup/src/Magento/Setup/Controller/Install.php(87): Magento\\Setup\\Model\\Installer->install(Array)\r\n#13 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\\Setup\\Controller\\Install->startAction()\r\n#14 [internal function]: Zend\\Mvc\\Controller\\AbstractActionController->onDispatch(Object(Zend\\Mvc\\MvcEvent))\r\n#15 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\\Mvc\\MvcEvent))\r\n#16 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\\EventManager\\EventManager->triggerListeners('dispatch', Object(Zend\\Mvc\\MvcEvent), Object(Closure))\r\n#17 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\\EventManager\\EventManager->trigger('dispatch', Object(Zend\\Mvc\\MvcEvent), Object(Closure))\r\n#18 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\\Mvc\\Controller\\AbstractController->dispatch(Object(Zend\\Http\\PhpEnvironment\\Request), Object(Zend\\Http\\PhpEnvironment\\Response))\r\n#19 [internal function]: Zend\\Mvc\\DispatchListener->onDispatch(Object(Zend\\Mvc\\MvcEvent))\r\n#20 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\\Mvc\\MvcEvent))\r\n#21 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\\EventManager\\EventManager->triggerListeners('dispatch', Object(Zend\\Mvc\\MvcEvent), Object(Closure))\r\n#22 /Users/Galina/Sites/magento2.lan/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\\EventManager\\EventManager->trigger('dispatch', Object(Zend\\Mvc\\MvcEvent), Object(Closure))\r\n#23 /Users/Galina/Sites/magento2.lan/setup/index.php(31): Zend\\Mvc\\Application->run()\r\n#24 {main}\r\n\r\n================================================\r\n\r\nI tried install with Sample data and without it. The same errors comes out.\r\n\r\nMy system:\r\nMac OS 10.7 Lion.\r\n\r\n<code>\r\n$ httpd -v </code>\r\nServer version: Apache/2.2.26 (Unix)\r\nServer built:   Dec 15 2013 18:33:29\r\n\r\n<code>$ mysql -u root -p</code>\r\nServer version: 5.6.2-m5 MySQL Community Server (GPL)\r\n\r\n<code>$ php -v</code>\r\nPHP 5.5.27 (cli) (built: Jul 10 2015 23:02:22) \r\nCopyright (c) 1997-2015 The PHP Group\r\nZend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies\r\n    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2015, by Zend Technologies\r\n    with Xdebug v2.2.5, Copyright (c) 2002-2014, by Derick Rethans\r\n\r\nI use clean MySQL, PHP, Apache installed with this manual http://coolestguidesontheplanet.com/how-to-install-php-mysql-apache-on-os-x-10-6/ \r\n\r\nSo, I have errors that seems to be because of low version of MySQL. But  I already updated MySQL and PHP to max possible for Mac OS 10.7 Lion.  \r\n\r\nFirstly I was tried install Magento on MAMP 3.0.7 with php 5.6, mySql 5.6. But it caused the same errors with the same step (module). So, I decided repeat all  steps on cleared MySQL, PHP, Apache. However, this has no effect\r\n\r\nWhat else I can do to recognize whats wrong with my installation of Magento?"},"comment":{"url":"https://api.github.com/repos/magento/magento2/issues/comments/124559976","html_url":"https://github.com/magento/magento2/issues/1550#issuecomment-124559976","issue_url":"https://api.github.com/repos/magento/magento2/issues/1550","id":124559976,"user":{"login":"Galch24","id":1256942,"avatar_url":"https://avatars.githubusercontent.com/u/1256942?v=3","gravatar_id":"","url":"https://api.github.com/users/Galch24","html_url":"https://github.com/Galch24","followers_url":"https://api.github.com/users/Galch24/followers","following_url":"https://api.github.com/users/Galch24/following{/other_user}","gists_url":"https://api.github.com/users/Galch24/gists{/gist_id}","starred_url":"https://api.github.com/users/Galch24/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Galch24/subscriptions","organizations_url":"https://api.github.com/users/Galch24/orgs","repos_url":"https://api.github.com/users/Galch24/repos","events_url":"https://api.github.com/users/Galch24/events{/privacy}","received_events_url":"https://api.github.com/users/Galch24/received_events","type":"User","site_admin":false},"created_at":"2015-07-24T15:32:51Z","updated_at":"2015-07-24T15:32:51Z","body":"And I repeat all this action one more time. I have the same errors with the same step and module."}}