Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    339
    Plugin Contributions
    0

    cart error Short Description for Cat. Mod: SQL error

    I've just installed the "Short Description for Categories for Zen Cart 1.3.* Module.
    I'm getting a :
    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 'ADD categories_description_sub TEXT NOT NULL' at line 1 in:

    This is what I am entering to the Admin/Tools/Install SQL patches

    "# Short Description for categories
    # version 1.0
    #
    # SQL to add the 'categories_description_sub' row to the table 'categories_description'
    # ------------------------------------------------------------------------------------ALTER TABLE categories_description
    ADD categories_description_sub TEXT NOT NULL;

    Does anyone see any problems with the SQL command or is there a revised SQL file available.
    Thanks,
    Bob

  2. #2
    Join Date
    Nov 2009
    Posts
    339
    Plugin Contributions
    0

    Default Re: Short Description for Cat. Mod: SQL error

    The problem was in the instructions.
    I just added the:
    ALTER TABLE categories_description
    ADD categories_description_sub TEXT NOT NULL;

    To the SQL patch and it seems to have worked, no error messages

 

 

Similar Threads

  1. v150 Short Description Mod - PHP errors
    By CharBee in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 9 Jul 2012, 11:44 PM
  2. v139h cannot copy product after installing Short Description mod
    By AndyCZ in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 26 May 2012, 09:41 AM
  3. Short Description mod - bigger textbox for Product Add page?
    By christopherw in forum Addon Templates
    Replies: 9
    Last Post: 1 Nov 2010, 12:07 AM
  4. Short Description mod - left aligning the text?
    By sarad in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 15 Jan 2009, 08:20 AM
  5. Short Description Mod help
    By bswinnerton in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 27 Jul 2008, 02:34 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