Forums / All Other Contributions/Addons / Short Description for Cat. Mod: SQL error

Short Description for Cat. Mod: SQL error

Locked

Started by robertg on 15 Feb 2010, 7:19 PM · Views: 1,887

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
15 Feb 2010, 7:19 PM
#1
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

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

15 Feb 2010, 7:50 PM
#2
robertg avatar

robertg

Zen Follower

Join Date:
Nov 2009
Posts:
341
Plugin Contributions:
0

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