SQL queries

[xuechao]

Hi, I have a question about the SQL queries, since I am relatively new to MySQL, I don't have much experience to it. I try to install the Product_Description module and in the readme it said:

 

Run the following two SQL queries on your database:

 

The first is to enable the display of Products Description in the Listing 0 = No 99 = Yes

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL, NULL);

 

The second defines the number of characters to display before truncating the description

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '350', 'How many characters would you like to display? ', '8', '12', '2002-03-16 18:51:26', '2002-03-16 18:51:26', NULL, NULL);

 

I have phpMyAdmin on the server, but how do I suppose to run the queries?

 

 

 

Thank you

[mugitty]

You might want to back up your database first

 

The parts in bold are the actual queries. Select the proper database, go to the SQL tab and enter the queries only in the textbox, then click 'Go'

 

Run the following two SQL queries on your database:

 

The first is to enable the display of Products Description in the Listing 0 = No 99 = Yes

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL, NULL);

 

The second defines the number of characters to display before truncating the description

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '350', 'How many characters would you like to display? ', '8', '12', '2002-03-16 18:51:26', '2002-03-16 18:51:26', NULL, NULL);

[xuechao]

thanks for the info, but i think there's something wrong with my host's phpMyAdmin. So I have to ask him about it.

 

thanks anyway!