In the Short Descriptions mod here:
http://www.zen-cart.com/index.php?ma...roducts_id=271
the SQL patch instructs to add the following lines to the database:
-----
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Product Short Descriptions', 'PRODUCT_LIST_SHORT_DESC', '3', 'Set to 0 to disable, set to 1-99 to enable.', 8, 11, now(), now(), NULL, NULL);
ALTER TABLE products_description ADD products_short_desc VARCHAR( 255 ) DEFAULT NULL AFTER products_description;
ALTER TABLE categories_description ADD categories_description_sub TEXT NOT NULL;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Info - Display Product Short Descriptions', 'PRODUCT_INFO_SHORT_DESC', '1', 'Show Product''s short Description<br />0= off<br />1= on', 18, 30, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''On'')),');
----
So now my questions is, how can I change the number of characters from 255 to for example 30000? I guess I need to reload the line:
---
ALTER TABLE products_description ADD products_short_desc VARCHAR( 255 ) DEFAULT NULL AFTER products_description;
ALTER TABLE categories_description ADD categories_description_sub TEXT NOT NULL;
---
but can I simply change it to:
---
ALTER TABLE products_description ADD products_short_desc VARCHAR( 30000 ) DEFAULT NULL AFTER products_description;
ALTER TABLE categories_description ADD categories_description_sub TEXT NOT NULL;
---
and submit it via Admin -> Tools -> Install SQL Patches ?
Bookmarks