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 ozetrade in forum Installing on a Linux/Unix Server
Last Post: 8 Aug 2014, 10:34 PM
By DarkAngel in forum General Questions
Last Post: 29 Jul 2014, 03:26 PM
By slash88er in forum Addon Payment Modules
Last Post: 24 May 2009, 08:04 AM
By rocket707 in forum Installing on a Windows Server
Last Post: 24 Feb 2009, 04:22 AM
Content and Graphics Copyright (c) 2003 - 2017 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC