php - 异常 'PDOException'，消息为“SQLSTATE[HY000] : General error: 1293 Incorrect table definition when setup Magento 2. 0 (0.1.0-alpha107)”

Question

今天我安装了洋红色 2.0 版本(内部版本 0.1.0-alpha107)。但该过程一直停留在 23%，并出现错误:

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'

以下是一些错误日志:

Module 'Magento_Sales': 
Include /Applications/MAMP/htdocs/magento/app/code/Magento/Sales/sql/sales_setup/install-2.0.0.php 
[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 /Applications/MAMP/htdocs/magento/setup/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228

您能看一下错误，并建议我一个解决方案吗？

Answer 1

您需要升级到MySQL 5.6

来源:https://github.com/magento/magento2/issues/782

Magento 2 要求:https://github.com/magento/magento2#magento-2-system-requirements