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