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.