Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2007
    Location
    Emporia, Kansas
    Posts
    1,762
    Plugin Contributions
    0

    Default mysql error 1064 ... near 'TYPE=MyISAM'

    this is the 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 6
    in:
    [CREATE TABLE IF NOT EXISTS zen_custom_zen ( id int(11) NOT NULL auto_increment, module varchar(50) NOT NULL default '', version char(10) NOT NULL default '', UNIQUE KEY id (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.

    It is for a paid for module called Private Area which is so my merchants can log into their own area of "admin" then enter the description/price and so forth to their own products while awaiting testing.

    I get that error when trying to access the "Edit Permissions" button.

    I see from searching that most likely it is due to the Type needing to be changed to Engine but it was functioning perfectly before our move..

    If that is what is the problem with this portion of the controls not working anymore--- how does one go about editing only the tables from Type to Engine, this does not seem to affect anywhere that needs permissions changed, only this mod.

  2. #2
    Join Date
    Nov 2007
    Location
    Sunny Coast, Australia
    Posts
    3,379
    Plugin Contributions
    9

    Default Re: mysql error

    Back Up First!!

    Then in that code try and replace

    TYPE=MyISAM

    with

    ENGINE=MyISAM

    If this was working before and the error only appears now then it is most likely due to and update of the MySQL version on the server.

  3. #3
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: mysql error

    or just remove "TYPE=MyISAM" altogether.. Truthfully it's not needed..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  4. #4
    Join Date
    Oct 2007
    Location
    Emporia, Kansas
    Posts
    1,762
    Plugin Contributions
    0

    Default Re: mysql error

    But, the table is already there, it has been for a very long time. It just started not letting me edit permissions for the merchants just a few days ago and everything else works.

    maybe if I reupload its files, could be something got corrupted in the move?

    I did try to run the sql but it won't let me since the table is there.

  5. #5
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: mysql error

    Quote Originally Posted by DarkAngel View Post
    But, the table is already there, it has been for a very long time. It just started not letting me edit permissions for the merchants just a few days ago and everything else works.

    maybe if I reupload its files, could be something got corrupted in the move?

    I did try to run the sql but it won't let me since the table is there.
    That SQL comes from your custom module.. edit the part of the code which contains that piece of code to remove the offending part and see if that fixes it..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  6. #6
    Join Date
    Oct 2007
    Location
    Emporia, Kansas
    Posts
    1,762
    Plugin Contributions
    0

    Default Re: mysql error

    Quote Originally Posted by DivaVocals View Post
    That SQL comes from your custom module.. edit the part of the code which contains that piece of code to remove the offending part and see if that fixes it..

    I think I did it right but as you can see it doesn't look right and nope still get the error when trying to edit permissions.

    Attachment 14338

  7. #7
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: mysql error

    Quote Originally Posted by DarkAngel View Post
    I think I did it right but as you can see it doesn't look right and nope still get the error when trying to edit permissions.

    Attachment 14338
    Based on what you posted, your custom code appears to attempting to run a "create table" bit of SQL.. You need to use the developers tool kit to figure our what part of your code is attempting to execute this bit of SQL and remove the code that is causing the issue..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  8. #8
    Join Date
    Oct 2007
    Location
    Emporia, Kansas
    Posts
    1,762
    Plugin Contributions
    0

    Default Re: mysql error

    ok, will do that later when i get up...been up for 24 hours and now need to sleep before my head falls off...not a pretty sight...LOL

 

 

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. 1064 mysql error
    By m4rtyj in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 28 Mar 2010, 11:31 PM
  3. 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
  4. Dreaded mYSQL 1064 error when importing MySQL 4 database into MySQL5
    By dml311071 in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Jun 2008, 05:38 AM
  5. MySQL error ... near '000000 where products_id = '50'
    By kairen in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 18 Dec 2007, 11: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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR