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

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.

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

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.

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.

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...