Error in table create: 'TYPE=MyISAM' (SOLVED)
When installing Addons ...
If you're getting errors like this when running the SQL for a mod:
ERROR 1064 (42000): 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
What you need to do to fix it is edit the .sql file and change
Newer versions of MySQL have deprecated the use of "TYPE=" parameters in favor of "ENGINE=".
You could alternatively just remove it altogether, since in the majority of cases MyISAM will be the default anyway.
That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.
By rocket707 in forum Installing on a Windows Server
Last Post: 24 Feb 2009, 04:22 AM
By millo_magno in forum Setting Up Categories, Products, Attributes
Last Post: 22 Jan 2007, 01:41 PM
By Beez in forum Setting Up Categories, Products, Attributes
Last Post: 7 Dec 2006, 02:44 PM
Content and Graphics Copyright (c) 2003 - 2016 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC