Anyone know why I'm getting this?

[therealbelladonna]

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

I get 78 returns of

ERROR: Cannot insert configuration_key "" because it already exists 

Any idea on how to fix this?

[Merlinpa1969]

take a look at the error

because it already exists

your OK

[afo]

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.

[therealbelladonna]

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.

[Merlinpa1969]

what mod are you trying to install?

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

[therealbelladonna]

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..

[Merlinpa1969]

please post the sql here

[therealbelladonna]

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)

[therealbelladonna]

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\'),' ); 

[paulm]

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.