1064 Error in SQL Syntax - old v.1.3.8 on new MySQL

[Chasel]

Hi,

got a problem with finish installation of the zencart engine 1.3.8.
I needed to downgrade the V.1.5 to 1.3.8. Installation preparation is without any problems.

Now i got the following errror message:

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 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;]

So i think that i only need to edit something in the mysql_zencart.sql. Also got the displayed error lines:

DROP TABLE IF EXISTS upgrade_exceptions;
CREATE TABLE 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;

Does anybody know how to complete this installation. What do i need to edit?

Thanks a lot

[lat9]

Try changing TYPE to ENGINE.

[dbltoe]

I'm concerned that you are downgrading to 1.3.8
I can understand that one might have to downgrade to 1.3.9h due to a mod not working, but download to a version with known vulnerabilities?!?

Brings back memories of -- Illegal bounds interrupt STOP

[DrByte]

Right.

It's a bad idea to be downgrading to a version of Zen Cart that's designed for MUCH OLDER version of MySQL than what you're using on your server. And probably same with PHP.