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

**rocket707** · 16 Jan 2009, 04:02 AM

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** · 16 Jan 2009, 10:19 AM

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

**rocket707** · 17 Jan 2009, 01:20 AM

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** · 23 Feb 2009, 05:25 AM

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

Code:

TYPE=MyISAM

with

Code:

ENGINE=MyISAM

.

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

**rocket707** · 24 Feb 2009, 04:22 AM

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