Anyone know why I'm getting this?

I posted for help in the mod support thread but no answer..

I get 78 returns of ```php
ERROR: Cannot insert configuration_key "" because it already exists

Any idea on how to fix this?

take a look at the error

because it already exists

your OK

Merlin's right. The system is just telling you it couldn't create the key because it's already there. You don't have to worry about it. Everything's working just fine. :cool:

It's not though.. because of that half the mod isn't getting installed... I'm not able to set up any profiles for the printable price list.

what mod are you trying to install?

you may need to open the sql file and then copy and paste everything below that key

It's the printable price list... if I use the update SQL tool, I get those errors.. if I use it in PhPAdmin, I get a totally different crazy error..

The Printable Price List page shows up under config but all I get is the titles of: Title Value Action
.. and nothing else..

please post the sql here

SELECT @sortorder:=max(sort_order)
FROM configuration_group;

# Main Price-list settings
INSERT INTO `configuration_group`
VALUES (NULL, 'Printable Price-list', 'The main options for the printable price-list module are stored here.', @sortorder+1, 1);

SELECT @pricelistid:=max(configuration_group_id)
FROM configuration_group;

SELECT @pricelistid;

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Default Profile', 'PL_DEFAULT_PROFILE', '1', 'Choose the default profile to use.', @pricelistid , 10, NULL , 'zen_cfg_select_option(array(\'1\', \'2\', \'3\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Show Profiles', 'PL_SHOW_PROFILES', 'true', 'If true available enabled profiles are shown', @pricelistid , 20, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

# Profiles

# Profile 1

INSERT INTO `configuration_group`
VALUES (NULL, 'Price-list Profile-1', 'Settings for printable price-list profile-1.', @sortorder+2, 1);

SELECT @pricelistid:=max(configuration_group_id)
FROM configuration_group;

SELECT @pricelistid;

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Enable', 'PL_ENABLE_1', 'true', 'If enabled a link will be shown to this profile', @pricelistid , 10, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Profile Name', 'PL_PROFILE_NAME_1', 'A4 portrait', 'Give this profile a name', @pricelistid , 20, NULL , NULL );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Stylesheet', 'PL_PRINTING_STYLESHEET_1', 'a4-portrait', 'Choose the default printing stylesheet to use. If set to "profile-x", i.e. "profile-2.css" is loaded for profile-2', @pricelistid , 30, NULL , 'zen_cfg_select_option(array(\'a4-portrait\', \'a4-landscape\', \'profile-x\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Main Cats New Page', 'PL_MAINCATS_NEW_PAGE_1', 'true', 'If true main categories always start on a new page (also forces new table)', @pricelistid , 40, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Main Cats New Table', 'PL_MAINCATS_NEW_TABLE_1', 'true', 'If true main categories always start a new table (false is ignored if maincats start new pages)', @pricelistid , 50, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'No Wrap', 'PL_NOWRAP_1', 'false', 'To enable or disable wrapping on screen (nowrap is easier for debugging)', @pricelistid , 60, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Max Columns', 'PL_MAXCOLUMNS_1', '2', 'Maximum number of columns to show per page', @pricelistid , 70, NULL , NULL );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Max Rows', 'PL_MAXLINES_1', '36', 'Maximum number of rows that can be printed on one page', @pricelistid , 80, NULL , NULL );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Tax Free', 'PL_SHOW_TAX_FREE_1', 'false', 'To show taxfree price in additional column', @pricelistid , 90, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Model', 'PL_SHOW_MODEL_1', 'true', 'To show model in additional column', @pricelistid , 100, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Manufacturer', 'PL_SHOW_MANUFACTURER_1', 'false', 'To show the manufacturer', @pricelistid , 110, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Weight', 'PL_SHOW_WEIGHT_1', 'false', 'Show the weight', @pricelistid , 120, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Stock On Hand', 'PL_SHOW_SOH_1', 'true', 'Show the Stock on Hand', @pricelistid , 125, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Notes (A)', 'PL_SHOW_NOTES_A_1', 'false', 'Creates an empty comment field, i.e. to make notes on your pricelist.', @pricelistid , 130, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Notes (B)', 'PL_SHOW_NOTES_B_1', 'false', 'Creates another empty comment field, i.e. to make notes on your pricelist.', @pricelistid , 140, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Show Inactive', 'PL_SHOW_INACTIVE_1', 'false', 'To show inactive products and categories', @pricelistid , 150, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Sort By', 'PL_SORT_PRODUCTS_BY_1', 'products_name', 'How products are sorted within a category', @pricelistid , 160, NULL , 'zen_cfg_select_option(array(\'products_name\', \'products_price\', \'products_model\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Asc Desc', 'PL_SORT_ASC_DESC_1', 'asc', 'Sort ascending or descending', @pricelistid , 170, NULL , 'zen_cfg_select_option(array(\'asc\', \'desc\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'All Categories default', 'PL_DEFAULT_SHOW_ALL_CATS_1', 'true', 'If true all catgories are shown by default, for large shops you might want to set this to false (to reduce memory usage).', @pricelistid , 180, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Boxes', 'PL_SHOW_BOXES_1', 'true', 'If true boxes are shown (to switch languages, currencies etc).', @pricelistid , 190, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Debug', 'PL_DEBUG_1', 'false', 'If true debug info is shown', @pricelistid , 200, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

# Profile 2

INSERT INTO `configuration_group`
VALUES (NULL, 'Price-list Profile-2', 'Settings for printable price-list profile-2.', @sortorder+3, 1);

SELECT @pricelistid:=max(configuration_group_id)
FROM configuration_group;

SELECT @pricelistid;

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Enable', 'PL_ENABLE_2', 'true', 'If enabled a link will be shown to this profile', @pricelistid , 10, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Profile Name', 'PL_PROFILE_NAME_2', 'A4 landscape', 'Give this profile a name', @pricelistid , 20, NULL , NULL );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Stylesheet', 'PL_PRINTING_STYLESHEET_2', 'a4-landscape', 'Choose the default printing stylesheet to use. If set to "profile-x", i.e. "profile-2.css" is loaded for profile-2', @pricelistid , 30, NULL , 'zen_cfg_select_option(array(\'a4-portrait\', \'a4-landscape\', \'profile-x\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Main Cats New Page', 'PL_MAINCATS_NEW_PAGE_2', 'true', 'If true main categories always start on a new page (also forces new table)', @pricelistid , 40, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Main Cats New Table', 'PL_MAINCATS_NEW_TABLE_2', 'true', 'If true main categories always start a new table (false is ignored if maincats start new pages)', @pricelistid , 50, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'No Wrap', 'PL_NOWRAP_2', 'false', 'To enable or disable wrapping on screen (nowrap is easier for debugging)', @pricelistid , 60, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Max Columns', 'PL_MAXCOLUMNS_2', '3', 'Maximum number of columns to show per page', @pricelistid , 70, NULL , NULL );

Part 1 (because it's too long)

Part 2

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Max Rows', 'PL_MAXLINES_2', '25', 'Maximum number of rows that can be printed on one page', @pricelistid , 80, NULL , NULL );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Tax Free', 'PL_SHOW_TAX_FREE_2', 'false', 'To show taxfree price in additional column', @pricelistid , 90, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Model', 'PL_SHOW_MODEL_2', 'true', 'To show model in additional column', @pricelistid , 100, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Manufacturer', 'PL_SHOW_MANUFACTURER_2', 'false', 'To show the manufacturer', @pricelistid , 110, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Weight', 'PL_SHOW_WEIGHT_2', 'false', 'Show the weight', @pricelistid , 120, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Stock On Hand', 'PL_SHOW_SOH_2', 'true', 'Show the Stock on Hand', @pricelistid , 125, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Notes (A)', 'PL_SHOW_NOTES_A_2', 'false', 'Creates an empty comment field, i.e. to make notes on your pricelist.', @pricelistid , 130, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Notes (B)', 'PL_SHOW_NOTES_B_2', 'false', 'Creates another empty comment field, i.e. to make notes on your pricelist.', @pricelistid , 140, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Show Inactive', 'PL_SHOW_INACTIVE_2', 'false', 'To show inactive products and categories', @pricelistid , 150, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Sort By', 'PL_SORT_PRODUCTS_BY_2', 'products_name', 'How products are sorted within a category', @pricelistid , 160, NULL , 'zen_cfg_select_option(array(\'products_name\', \'products_price\', \'products_model\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Asc Desc', 'PL_SORT_ASC_DESC_2', 'asc', 'Sort ascending or descending', @pricelistid , 170, NULL , 'zen_cfg_select_option(array(\'asc\', \'desc\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'All Categories default', 'PL_DEFAULT_SHOW_ALL_CATS_2', 'true', 'If true all catgories are shown by default, for large shops you might want to set this to false (to reduce memory usage).', @pricelistid , 180, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Boxes', 'PL_SHOW_BOXES_2', 'false', 'If true boxes are shown (to switch languages, currencies etc).', @pricelistid , 190, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Debug', 'PL_DEBUG_2', 'false', 'If true debug info is shown', @pricelistid , 200, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

# Profile 3

INSERT INTO `configuration_group`
VALUES (NULL, 'Price-list Profile-3', 'Settings for printable price-list profile-3.', @sortorder+4, 1);

SELECT @pricelistid:=max(configuration_group_id)
FROM configuration_group;

SELECT @pricelistid;

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Enable', 'PL_ENABLE_3', 'false', 'If enabled a link will be shown to this profile', @pricelistid , 10, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Profile Name', 'PL_PROFILE_NAME_3', 'Testing', 'Give this profile a name', @pricelistid , 20, NULL , NULL );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Stylesheet', 'PL_PRINTING_STYLESHEET_3', 'profile-x', 'Choose the default printing stylesheet to use. If set to "profile-x", i.e. "profile-3.css" is loaded for profile-3', @pricelistid , 30, NULL , 'zen_cfg_select_option(array(\'a4-portrait\', \'a4-landscape\', \'profile-x\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Main Cats New Page', 'PL_MAINCATS_NEW_PAGE_3', 'true', 'If true main categories always start on a new page (also forces new table)', @pricelistid , 40, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Main Cats New Table', 'PL_MAINCATS_NEW_TABLE_3', 'true', 'If true main categories always start a new table (false is ignored if maincats start new pages)', @pricelistid , 50, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'No Wrap', 'PL_NOWRAP_3', 'true', 'To enable or disable wrapping on screen (nowrap is easier for debugging)', @pricelistid , 60, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Max Columns', 'PL_MAXCOLUMNS_3', '2', 'Maximum number of columns to show per page', @pricelistid , 70, NULL , NULL );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Max Rows', 'PL_MAXLINES_3', '20', 'Maximum number of rows that can be printed on one page', @pricelistid , 80, NULL , NULL );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Tax Free', 'PL_SHOW_TAX_FREE_3', 'true', 'To show taxfree price in additional column', @pricelistid , 90, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Model', 'PL_SHOW_MODEL_3', 'true', 'To show model in additional column', @pricelistid , 100, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Manufacturer', 'PL_SHOW_MANUFACTURER_3', 'true', 'To show the manufacturer', @pricelistid , 110, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Weight', 'PL_SHOW_WEIGHT_3', 'true', 'Show the weight', @pricelistid , 120, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Stock On Hand', 'PL_SHOW_SOH_3', 'true', 'Show the Stock on Hand', @pricelistid , 125, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Notes (A)', 'PL_SHOW_NOTES_A_3', 'true', 'Creates an empty comment field, i.e. to make notes on your pricelist.', @pricelistid , 130, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Notes (B)', 'PL_SHOW_NOTES_B_3', 'true', 'Creates another empty comment field, i.e. to make notes on your pricelist.', @pricelistid , 140, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Show Inactive', 'PL_SHOW_INACTIVE_3', 'true', 'To show inactive products and categories', @pricelistid , 150, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Sort By', 'PL_SORT_PRODUCTS_BY_3', 'products_name', 'How products are sorted within a category', @pricelistid , 160, NULL , 'zen_cfg_select_option(array(\'products_name\', \'products_price\', \'products_model\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Asc Desc', 'PL_SORT_ASC_DESC_3', 'asc', 'Sort ascending or descending', @pricelistid , 170, NULL , 'zen_cfg_select_option(array(\'asc\', \'desc\' ),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'All Categories default', 'PL_DEFAULT_SHOW_ALL_CATS_3', 'false', 'If true all catgories are shown by default, for large shops you might want to set this to false (to reduce memory usage).', @pricelistid , 180, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Boxes', 'PL_SHOW_BOXES_3', 'true', 'If true boxes are shown (to switch languages, currencies etc).', @pricelistid , 190, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
VALUES ( 'Debug', 'PL_DEBUG_3', 'true', 'If true debug info is shown', @pricelistid , 200, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

# link on/off switch
#INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function )
#VALUES ('Show Price List', 'SHOW_CATEGORIES_BOX_PRICELIST', 'true', 'If true Price-List link will show (in the Categories box for example, if you added the link code).', @pricelistid , 20, NULL , 'zen_cfg_select_option(array(\'true\', \'false\'),' );

I know this happens sometimes, but I don't know why. As far as I know it does not happen on a fresh install.

It's not really a (normal) duplicate key problem because phpMyAdmin always loads the sql without any issues.

I usually add the db prefix (if any) to all table names and use phpMyAdmin to load the sql.

Note that the script complains about an empty string as configuration key:> ERROR: Cannot insert configuration_key "" because it already exists

Paulm did PM me, told me that he had written a SQL patch that would work and wanted almost $40 Canadian from me before I could have it... I refused and said I could do it myself, never hearing from him again.

I got in touch with my IT friend in Scotland and he was able to fix it in less than 3 minutes.. I'm glad I didn't pay..

LOL, I did not say I had written a patch! I said I could write one for you and install it for you for 25 euro's (no idea how much canadian dollar that is, I only that it's really cheap in our country for fixing any kind of code). Also asuming there was some special kind of problem, since I already told how it could be done (in another thread).

But 3 minutes is fast I must say, usually it takes me longer even only to get all the needed details (like admin/phpMyAdmin login or whatever needed) etc to be able apply a fix.

Here it is:

paulm:

therealbelladonna:

OK.. I need this fixed ASAP because I have some people wanting wholesale orders waiting for this list..

Thanks.
If you can give me temporary phpMyAdmin access I can create and install an adapted sql for you. I think 25 euro's would cover the time.

Interested?

cu,
Paul

I did not want to write an adapted sql, but because you PM'ed me that you were in a hurry, and your customers were waiting, I decided to make my offer....

Quite sick this actually is. First you're asking for personal support, but not willing to pay anything. Then you are publicly posting my reply, or even much worse, you are publicly posting a lie about what I answered you in private :shocking:

Guys ... relax ... one needed help one tried to help ... if you take offense at the offer for help when you ask for it and consider it rude if someone would like payment for their time then you live in a different world ...

It is great that help was offered ... I don't see where any offense was intended nor was anyone wrong in asking for payment for their time ...

Let's all take a nice deep breath ...

Glad to see everything is working happily now ... :smile:

Ajeh:

Let's all take a nice deep breath ...Already taken :-)

I only don't agree that taking a private message, twisting it, and then post it publicly is no offense.