Zen Cart install problems (MySQL errors)

[joel]

I keep getting this 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 zen_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;]

I am currently running FreeBSD 4.11-STABLE, PHP 5.1.2, and MySQL 5.1.7-beta .

I have tried installing 1.3.0.2, first, then I thought, perhaps, there could be a problem with the latest version, so I attempted to install 1.3.0 and it still created the same error.

Can anyone give me a little direction? :)

Thanks!

[DrByte]

I suspect your problem is MySQL 5.1.x-beta.

It could be that your MySQL settings are set to disallow TYPE=MYISAM table definitions.

Zen Cart isn't fully tested nor certified for MySQL5 at the present time.

Downgrading to MySQL 4 should do away with the reported error.

[Vger]

I'm not 100% certain on this, but I don't think that it's necessary to speciify MYISAM in the sql file, so you could try doing a find and replace on all instances of TYPE=MYISAM in the installation sql file - and replace with nothing of course.

Downgrading to MySQL 4 would be safer option if it is open to you to do so - as MySQL 5 is not exactly stable (beta release or not).

Vger