2

Today I set up a version of Magento 2.0 (build 0.1.0-alpha107). But the process has stuck at 23% with error:

Exception 'PDOException' with the 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'.

Here are some pieces of the error log:

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
1
  • What is the problem? Magento2 has one table which is setup incorrect, because "there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause'" – Fabian Blechschmidt Dec 7 '14 at 19:21
3

You need to upgrade to MySQL 5.6

Source: https://github.com/magento/magento2/issues/782

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.