Saturday, October 31, 2009

Zen cart 1064 TYPE=MyISAM Problem

If you're getting the following error when trying to install Zencart:

"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1"

It is likely that you are trying to install on a relatively old MySQL version. To get around this problem:

1) find and open the file "zc_install\sql\mysql_zencart.sql"

2) Replace all instances of "TYPE=MyISAM" with "ENGINE=MyISAM"

That should help solve the problem.


  1. super.. it worked..

    Have the problem when using the latest XAMPP - but your tip and alter the xcart_tables.sql in X-cart did the trick.

  2. Thanks! Worked perfect for me