cieto featured products / SQL problem

[jogoto]

Hi,

I have a problem with the SQL-part in "cieto featured products"

### Database

### [ Step  1 ] ##################

 

  Now you need to create the database table that will be holding the

  featured products.  You need to run the following SQL command in your

  favourite sql interface to your database, either command-line mysql,

  or phpmysql, or whatever :

The part

ALTER TABLE `products` ADD `products_featured` TEXT AFTER `products_status` ;

ALTER TABLE `products` ADD `products_featured_until` TEXT AFTER `products_date_available` ;

ALTER TABLE `products_description` ADD `products_short` TEXT AFTER `products_name` ;

INSERT INTO configuration_group VALUES (99, 'Featured Products', 'Configure featured products', 15, 1);

works, but

INSERT INTO configuration VALUES ('', 'Display featured products', 'FEATURED_PRODUCTS_DISPLAY', 'false', 'Show featured products?', 99, 1, NULL, now(), '', 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration VALUES ('', 'Featured products maximum', 'MAX_DISPLAY_FEATURED_PRODUCTS', '2', 'How many featured products show?', 99, 2, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('', 'Columns in layout', 'FEATURED_PRODUCTS_COLUMNS', '1', 'How many columns do you want to use in your layout?', 99, 3, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('', 'Words per short description when it\'s not written', 'MAX_FEATURED_WORD_DESCRIPTION', '12', 'When you don\'t enter short description, truncate description upto how many words?', 99, 4, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('', 'Featured period', 'DAYS_UNTIL_FEATURED_PRODUCTS', '30', 'How many days do you want to add to the current date when you click on the green light.', 99, 5, NULL, now(), NULL, NULL);

does not work.

 

Why?

[John Doswell]

QUOTE]The part

ALTER TABLE `products` ADD `products_featured` TEXT AFTER `products_status` ;

ALTER TABLE `products` ADD `products_featured_until` TEXT AFTER `products_date_available` ;

ALTER TABLE `products_description` ADD `products_short` TEXT AFTER `products_name` ;

INSERT INTO configuration_group VALUES (99, 'Featured Products', 'Configure featured products', 15, 1);

works, but

INSERT INTO configuration VALUES ('', 'Display featured products', 'FEATURED_PRODUCTS_DISPLAY', 'false', 'Show featured products?', 99, 1, NULL, now(), '', 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration VALUES ('', 'Featured products maximum', 'MAX_DISPLAY_FEATURED_PRODUCTS', '2', 'How many featured products show?', 99, 2, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('', 'Columns in layout', 'FEATURED_PRODUCTS_COLUMNS', '1', 'How many columns do you want to use in your layout?', 99, 3, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('', 'Words per short description when it\'s not written', 'MAX_FEATURED_WORD_DESCRIPTION', '12', 'When you don\'t enter short description, truncate description upto how many words?', 99, 4, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('', 'Featured period', 'DAYS_UNTIL_FEATURED_PRODUCTS', '30', 'How many days do you want to add to the current date when you click on the green light.', 99, 5, NULL, now(), NULL, NULL);

does not work.

 

Why?

try changing all 99 to something else like 156 or 111

that should work

 

regards john