Printable catalog cont.

[blr044]

After searching the forum and hosting site, I did not find actually what I was looking for.

 

First of all, doing any kind of editing or adding in PhpMyAdmin, makes me a little worried.

 

Now I would like to install ( catalog_products_with_images_3_5 ). And would you know it, there is that word "SQL". But I am learning my way around, but slow.

 

When looking at the instructions, I see this:

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function) VALUES ('Printable Catalog-Customer Discount in Catalog', 'PRODUCT_LIST_CUSTOMER_DISCOUNT', 'hide', 'Setting to -show- will display the catalog with a customer discount applied if logged in. It will display pricing without discount if not logged in. (only valid if Members Discount Mod is loaded. Default if Mod not present is -hide-)', '899', 'show', now(), now(), 'tep_cfg_select_option(array(\'show\', \'hide\'),');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) VALUES ('Printable Catalog-Number of Page Breaks Displayed', 'PRODUCT_LIST_PAGEBREAK_NUMBERS_PERPAGE', '10', 'How page breaks numbers to display?', '899', '2', now(), now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) VALUES ('Printable Catalog-Results Per Page', 'PRODUCT_LIST_CATALOG_PERPAGE', '10', 'How many products do you want to list per page? (Setting this value 1 above the total number of products you have will list all products in one page. Then setting hide on -Show Results Per Page Link- might be wanted', '899', '3', now(), now());   and etc.

 

Now when I am in my PhpMyAdmin and enter this data into the white text box, which is the correct way, the first or second way?

 

First:

(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function) VALUES ('Printable Catalog-Customer Discount in Catalog', 'PRODUCT_LIST_CUSTOMER_DISCOUNT', 'hide', 'Setting to -show- will display the catalog with a customer discount applied if logged in. It will display pricing without discount if not logged in. (only valid if Members Discount Mod is loaded. Default if Mod not present is -hide-)', '899', 'show', now(), now(), 'tep_cfg_select_option(array(\'show\', \'hide\')

 

or second this way:

 

(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function) VALUES ('Printable Catalog-Customer Discount in Catalog', 'PRODUCT_LIST_CUSTOMER_DISCOUNT', 'hide', 'Setting to -show- will display the catalog with a customer discount applied if logged in. It will display pricing without discount if not logged in. (only valid if Members Discount Mod is loaded. Default if Mod not present is -hide-)', '899', 'show', now(), now(), 'tep_cfg_select_option(array(\'show\', \'hide\'),');

with those extra marks at the end and beginning.

 

Thanks.

 

blr044

Edited November 25, 2007 by blr044

[♥geoffreywalton]

SQL commands should always end in a semi-colon.

 

So relax, cut and paste it.

 

If it goes wrong you can delete the records in the configuration table.

[♥geoffreywalton]

http://www.oscommerce.com/forums/index.php?sho...=284459&hl=

 

Explains this too.

[blr044]

After searching the forum and hosting site, I did not find actually what I was looking for.

 

First of all, doing any kind of editing or adding in PhpMyAdmin, makes me a little worried.

 

Now I would like to install ( catalog_products_with_images_3_5 ). And would you know it, there is that word "SQL". But I am learning my way around, but slow.

 

When looking at the instructions, I see this:

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function) VALUES ('Printable Catalog-Customer Discount in Catalog', 'PRODUCT_LIST_CUSTOMER_DISCOUNT', 'hide', 'Setting to -show- will display the catalog with a customer discount applied if logged in. It will display pricing without discount if not logged in. (only valid if Members Discount Mod is loaded. Default if Mod not present is -hide-)', '899', 'show', now(), now(), 'tep_cfg_select_option(array(\'show\', \'hide\'),');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) VALUES ('Printable Catalog-Number of Page Breaks Displayed', 'PRODUCT_LIST_PAGEBREAK_NUMBERS_PERPAGE', '10', 'How page breaks numbers to display?', '899', '2', now(), now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) VALUES ('Printable Catalog-Results Per Page', 'PRODUCT_LIST_CATALOG_PERPAGE', '10', 'How many products do you want to list per page? (Setting this value 1 above the total number of products you have will list all products in one page. Then setting hide on -Show Results Per Page Link- might be wanted', '899', '3', now(), now());   and etc.

 

Now when I am in my PhpMyAdmin and enter this data into the white text box, which is the correct way, the first or second way?

 

First:

(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function) VALUES ('Printable Catalog-Customer Discount in Catalog', 'PRODUCT_LIST_CUSTOMER_DISCOUNT', 'hide', 'Setting to -show- will display the catalog with a customer discount applied if logged in. It will display pricing without discount if not logged in. (only valid if Members Discount Mod is loaded. Default if Mod not present is -hide-)', '899', 'show', now(), now(), 'tep_cfg_select_option(array(\'show\', \'hide\')

 

or second this way:

 

(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function) VALUES ('Printable Catalog-Customer Discount in Catalog', 'PRODUCT_LIST_CUSTOMER_DISCOUNT', 'hide', 'Setting to -show- will display the catalog with a customer discount applied if logged in. It will display pricing without discount if not logged in. (only valid if Members Discount Mod is loaded. Default if Mod not present is -hide-)', '899', 'show', now(), now(), 'tep_cfg_select_option(array(\'show\', \'hide\'),');

with those extra marks at the end and beginning.

 

Thanks.

 

blr044

 

 

 

Idid copy and paste the following code into PhpMyAdmin

 

(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function) VALUES ('Printable Catalog-Customer Discount in Catalog', 'PRODUCT_LIST_CUSTOMER_DISCOUNT', 'hide', 'Setting to -show- will display the catalog with a customer discount applied if logged in. It will display pricing without discount if not logged in. (only valid if Members Discount Mod is loaded. Default if Mod not present is -hide-)', '899', 'show', now(), now(), 'tep_cfg_select_option(array(\'show\', \'hide\'),');

 

But then I recieved this error:

 

Error

SQL query: Documentation

(
configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function
) VALUES (
'Printable Catalog-Customer Discount in Catalog', 'PRODUCT_LIST_CUSTOMER_DISCOUNT', 'hide', 'Setting to -show- will display the catalog with a customer discount applied if logged in. It will display pricing without discount if not logged in. (only valid if Members Discount Mod is loaded. Default if Mod not present is -hide-)', '899', 'show', now( ) , now( ) , 'tep_cfg_select_option(array(\'show\', \'hide\'),'
)

MySQL said: Documentation
#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 'configuration_title, configuration_key, configuration_value, configuration_descr' at line 1 

 

Any suggestions? This is the problem I have every time. A few times my host has helped by doing it them selves. I always ask, please explain the steps. Either they do not read the complete email or what, I don't know.

 

So if someone here can break this down a bit that is a little bit more user friendly, I would appreciate it.

 

Thanks.

 

blr044