Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2004
    Location
    Redcliffe QLD, Australia
    Posts
    195
    Plugin Contributions
    1

    Default 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
    Apache 2.2.11
    PHP 5.3.5
    MySql 5.5.8
    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:
    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`)
    ) TYPE=MyISAM;
    From PhpMyAdmin I get the following 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 5
    Have I got the database configured wrong or am I missing something?

  2. #2
    Join Date
    Jan 2004
    Posts
    60,313
    Blog Entries
    4
    Plugin Contributions
    144

    Default 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.



  3. #3
    Join Date
    May 2011
    Location
    Garland, Texas, United States
    Posts
    11
    Plugin Contributions
    0

    Default Re: SQL Patches with TYPE=MyISAM are failing

    This is STILL an issue with multiple current plugins. It would be so fabulous if they worked w/o code changes ... please update this plugin authors! Perhaps am I missing some obvious reason to leave obsolete code in plugins - I'm not a programmer after all - but for me they've been failing installs that require editing for a long time.

  4. #4
    Join Date
    Jul 2012
    Posts
    2,727
    Plugin Contributions
    5

    Default Re: SQL Patches with TYPE=MyISAM are failing

    Quote Originally Posted by Angeltown View Post
    This is STILL an issue with multiple current plugins. It would be so fabulous if they worked w/o code changes ... please update this plugin authors! Perhaps am I missing some obvious reason to leave obsolete code in plugins - I'm not a programmer after all - but for me they've been failing installs that require editing for a long time.
    While the rant is understandable, it would unfortunately be of more benefit in the applicable thread(s) where the code needs to be updated. For those plugins that you have worked your way through to repair, they could be submitted with the update by anyone, though ideally making contaact with either the author or last updater would be suggested.
    ZC Installation/Maintenance Support
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.1 from V1.5.0 from V1.3.9h

  5. #5
    Join Date
    May 2011
    Location
    Garland, Texas, United States
    Posts
    11
    Plugin Contributions
    0

    Default Re: SQL Patches with TYPE=MyISAM are failing

    Good point! I just thought it would be good to remind them in general this really needs updated, so that when they do the next update it could be easily corrected. I'll post to each author as I come across them again. I'm comfortable enough to edit files for my own sites, but not to post code for everyone so I would not want to update them publicly myself.

  6. #6
    Join Date
    Jul 2012
    Posts
    2,727
    Plugin Contributions
    5

    Default Re: SQL Patches with TYPE=MyISAM are failing

    Quote Originally Posted by Angeltown View Post
    Good point! I just thought it would be good to remind them in general this really needs updated, so that when they do the next update it could be easily corrected. I'll post to each author as I come across them again. I'm comfortable enough to edit files for my own sites, but not to post code for everyone so I would not want to update them publicly myself.
    It's a public service and one that will only benefit by those that kindly point out improvements. On a related note, though I haven't tried it myself, another has posted that the table type (presumed by me to mean under more recent versions of PHP/mySQL server) is no longer necessary. This is not a claim of fact, but a potential "fix" that if true could make some things a lot easier/cleaner at least until the standard changes again.

    Related to the updates of the software, well true there is a little more to it than simply changing a line of code. Going through the actions expected/described in the forum do offer a bit of growth and appreciation to the process. :) but please offer your input where it will provide improvements.
    ZC Installation/Maintenance Support
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.1 from V1.5.0 from V1.3.9h

 

 

Similar Threads

  1. Error in table create: 'TYPE=MyISAM' (SOLVED)
    By swguy in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 1 May 2011, 07:04 PM
  2. Replies: 5
    Last Post: 6 Feb 2010, 09:03 PM
  3. Change Storage Engine ( MyISAM to/from InnoDB converter)
    By data_digger in forum All Other Contributions/Addons
    Replies: 11
    Last Post: 17 Dec 2009, 09:56 AM
  4. 1064 You have an error in your SQL syntax ... TYPE=MyISAM
    By rocket707 in forum Installing on a Windows Server
    Replies: 4
    Last Post: 24 Feb 2009, 04:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •