SQL Patches with TYPE=MyISAM are failing
I'd dearly love to get my next website up as a v1.5.0, but I'm having issues installing SQL patches for many of the v1.5.0 compatible MODS.
My dev platform is MOWES which I've used for years. Current version using
Running on a win7 box
I manually created my UTF8 database using PhpMyAdmin
Installed v1.5.0 without issue - Awesome BTW.
The SQL patches fail to import in both Zencart SQL patch util and also when using PhpMyAdmin.
Any SQL patch file that starts with something similar to this fails:
From PhpMyAdmin I get the following error:
CREATE TABLE `notes_categories` (
`notes_categories_id` int(11) NOT NULL auto_increment,
`notes_categories_name` varchar(64) default NULL,
PRIMARY KEY (`notes_categories_id`)
Have I got the database configured wrong or am I missing something?
#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 5
Re: SQL Patches with TYPE=MyISAM are failing
TYPE=MyISAM is obsolete syntax in MySQL.
Change your code to ENGINE=MyISAM instead.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donations always welcome: www.zen-cart.com/donate
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
By swguy in forum All Other Contributions/Addons
Last Post: 1 May 2011, 07:04 PM
By Jay76 in forum Addon Shipping Modules
Last Post: 6 Feb 2010, 09:03 PM
By data_digger in forum All Other Contributions/Addons
Last Post: 17 Dec 2009, 09:56 AM
By rocket707 in forum Installing on a Windows Server
Last Post: 24 Feb 2009, 04:22 AM
Content and Graphics Copyright (c) 2003 - 2014 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC