How can i fix in order to have a smooth import to phpmyadmin on cpanel... I am getting error #1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

closed as off-topic by Raphael at Digital Pianism, Qaisar Satti, Amit Bera, Fabian Schmengler, philwinkle Apr 20 '16 at 15:36

  • This question does not appear to be about the Magento e-Commerce platform within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.


I'm guessing you are talking about Magento2, right? If so, check for Mysql Version, because Magento2 needs at least a Mysql with version 5.6 or higher.

This is a 'default' error, if you try to import a Magento2 Mysql Dump into a Mysql Server with Version 5.5 or lower

  • yes you are right. ok will check the versions. Thanks – Josephine Apr 20 '16 at 10:07
  • I see that i was right regarding your question yesterday: magento.stackexchange.com/questions/111491/… For sure your lamp stack is more up2date then your cpanel server. If this is the error, it would be nice, if you can accept the answer. – Michael Apr 20 '16 at 10:09

I will recommend to first create backup of your app/etc/env.php file. Then upload a fresh env.php file to the pp/etc folder then run your store then the setup wizard will come and after that with that wizard you can check that your server can fulfilled all requirements for magento2 or not.

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