The Cart Blog

Sunday, January 15, 2012

Switching from TYPE=MyISAM to ENGINE=MyISAM for Zen Cart Mods

Filed under: That Software Guy,Zen Cart — thatsoftwareguy @ 9:22 am

If you have a newer version of MySQL, you may notice an error when you run SQL scripts (using Admin->Tools->Install SQL Patches) during mod installs on your Zen Cart.  The error will look something like this:

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 foo1 ( coupon_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL, copy_from_coupon_code varchar(32) NOT NULL default '', new_coupon_name varchar(32) NOT NULL default '', customers_id int(11) NOT NULL default '0', PRIMARY KEY (coupon_id), KEY idx_coupon_code (copy_from_coupon_code), KEY idx_coupon_name(new_coupon_name), KEY idx_customers_id (customers_id) ) TYPE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Solving this issue is straightforward: in the .sql file you are running, just change

TYPE=MyISAM

to

ENGINE=MyISAM

Of my Zen Cart mods, the following mods have a table create with TYPE=MyISAM, which could cause this issue:

 

1 Comment »

  1. Another mod to add to that list is “Newsletter Subscribe”: http://www.zen-cart.com/downloads.php?do=file&id=29

    Comment by Numinix — Monday, December 3, 2012 @ 8:33 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress