1064 You have an error in your SQL syntax ... TYPE=MyISAM

[rocket707]

Here is the full error:
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
in:
[CREATE TABLE ccbmx_upgrade_exceptions ( upgrade_exception_id smallint(5) NOT NULL auto_increment, sql_file varchar(50) default NULL, reason varchar(200) default NULL, errordate datetime default '0001-01-01 00:00:00', sqlstatement text, PRIMARY KEY (upgrade_exception_id) ) TYPE=MyISAM;]

This happens just after I try to install and click Save Database Settings in the DB Setup step. I have given the all permissions to everything and cannot figure out why it is giving me this error. Any help would be appreciated.

[DrByte]

What version of Zen Cart are you trying to install?
What version of MySQL is on your server?

[rocket707]

1.3.8 - It was the one at the top of the list. I downloaded it about a week or so ago.

MySQL 5.1

Thanks.

[DrByte]

Your version of MySQL probably requires that you edit the /zc_install/sql/mysql_zencart.sql file and replace every occurrence of

TYPE=MyISAM

with

ENGINE=MyISAM

.

The next version of Zen Cart will already incorporate this MYSQL5-specific change.

[rocket707]

As luck would have it I finally figured it out last night... You are right though... Changing it from Type to Engine worked and everything is up and running.

Thanks...