Problems with QuickUpdates installation

[Reesy]

No need to apologise Dr.
Without your help I wouldnt have had much of an idea.

[Reesy]

Hi,
Ive tried to install the quick updates contrib but have run into an error...
1062 Duplicate entry '300' for key 1

Can someone please help me out with how to drop these configuration settings so I can try again please?

INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');

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 the model.', 'QUICKUPDATES_DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'false', 'Allow/Disallow the model modification', 300, 2, '2003-06-04 05:04:07', '2003-06-04 04:25:57', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Display the name.', 'QUICKUPDATES_DISPLAY_NAME', 'true', 'Enable/Disable the name displaying', 300, 3, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Modify the name of the products.', 'QUICKUPDATES_MODIFY_NAME', 'false', 'Allow/Disallow the name modification?', 300, 4, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Display the Description.', 'QUICKUPDATES_DISPLAY_DESCRIPTION', 'true', 'Enable/Disable the displaying of description', 300, 5, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Modify the description of the products.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Allow/Disallow the Description modification?', 300, 6, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Modify the status of the products.', 'QUICKUPDATES_DISPLAY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', 300, 7, '2003-06-04 05:07:11', '2003-06-04 05:00:58', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Modify the weight of the products.', 'QUICKUPDATES_DISPLAY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', 300, 8, '2003-06-04 05:06:44', '2003-06-04 04:33:16', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Modify the quantity of the products.', 'QUICKUPDATES_DISPLAY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', 300, 9, '2003-06-04 05:06:48', '2003-06-04 04:34:34', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', 300, 10, '2003-06-04 05:06:57', '2003-06-04 04:37:40', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', 300, 11, '2003-06-04 05:06:40', '2003-06-04 04:31:53', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Display price with all included of tax.', 'QUICKUPDATES_DISPLAY_TVA_OVER', 'true', 'Enable/Disable the displaying of the Price with all tax included when your mouse is over a product', 300, 12, '2003-06-04 05:07:02', '2003-06-04 04:38:45', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Display the link towards the products information page.', 'QUICKUPDATES_DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', 300, 14, '2003-06-04 05:19:13', '2003-06-04 05:15:50', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Display the link towards the page where you will be able to edit the product.', 'QUICKUPDATES_DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link towards the page where you will be able to edit the product', 300, 15, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Display the manufacturer.', 'QUICKUPDATES_DISPLAY_MANUFACTURER', 'false', 'Do you want just display the manufacturer ?', 300, 16, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Display the tax.', 'QUICKUPDATES_DISPLAY_TAX', 'true', 'Do you want just display the tax ?', 300, 17, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('', 'Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?', 300, 18, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

Thanks in advance.

Im hoping someone can be kind enough to help me out here again please.

I tried to run the above again and I get 2 warning errors...

2 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I think this is coming from this line....

('', 'Display the model.', 'QUICKUPDATES_DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),

But am not sure what it should be....

[DrByte]

Are "quick updates" working for you?

If the entry already exists, you don't need to insert it again ... esp since the reason for its existence is probably from "before" you "removed" it the other day.

[Reesy]

Hi,
No they are not, because of this problem which is why I asked how to remove it so I could try again.
Its my understanding which is confirmed by a post above that '' is meant to autoincrement so this is why im confused.

[DrByte]

configuration_id 's are auto-increment
configuration_key's are not ... they are text strings.

the "already exists" warning is related to configuration_key "unique" index, not to anything auto-increment-related.



Try breaking the SQL statement down into separate INSERT's and run them one at a time to find out what's the problem.
Or try running the whole batch in phpMyAdmin and find out how many items it successfully inserted.



Or, better yet, why not explain what's "not working" with the quick-updates mod ... so it can be determined whether it's related to the SQL at all.

Even better, why not try contacting the author of the mod ... since they should understand it better than you or I.

[DrByte]

You could also try inserting without the blank strings, like this:

INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('Display the model.', 'QUICKUPDATES_DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'false', 'Allow/Disallow the model modification', 300, 2, '2003-06-04 05:04:07', '2003-06-04 04:25:57', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the name.', 'QUICKUPDATES_DISPLAY_NAME', 'true', 'Enable/Disable the name displaying', 300, 3, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the name of the products.', 'QUICKUPDATES_MODIFY_NAME', 'false', 'Allow/Disallow the name modification?', 300, 4, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the Description.', 'QUICKUPDATES_DISPLAY_DESCRIPTION', 'true', 'Enable/Disable the displaying of description', 300, 5, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the description of the products.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Allow/Disallow the Description modification?', 300, 6, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the status of the products.', 'QUICKUPDATES_DISPLAY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', 300, 7, '2003-06-04 05:07:11', '2003-06-04 05:00:58', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the weight of the products.', 'QUICKUPDATES_DISPLAY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', 300, 8, '2003-06-04 05:06:44', '2003-06-04 04:33:16', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the quantity of the products.', 'QUICKUPDATES_DISPLAY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', 300, 9, '2003-06-04 05:06:48', '2003-06-04 04:34:34', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', 300, 10, '2003-06-04 05:06:57', '2003-06-04 04:37:40', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', 300, 11, '2003-06-04 05:06:40', '2003-06-04 04:31:53', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display price with all included of tax.', 'QUICKUPDATES_DISPLAY_TVA_OVER', 'true', 'Enable/Disable the displaying of the Price with all tax included when your mouse is over a product', 300, 12, '2003-06-04 05:07:02', '2003-06-04 04:38:45', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the link towards the products information page.', 'QUICKUPDATES_DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', 300, 14, '2003-06-04 05:19:13', '2003-06-04 05:15:50', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the link towards the page where you will be able to edit the product.', 'QUICKUPDATES_DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link towards the page where you will be able to edit the product', 300, 15, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the manufacturer.', 'QUICKUPDATES_DISPLAY_MANUFACTURER', 'false', 'Do you want just display the manufacturer ?', 300, 16, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the tax.', 'QUICKUPDATES_DISPLAY_TAX', 'true', 'Do you want just display the tax ?', 300, 17, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?', 300, 18, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

[Reesy]

You could also try inserting without the blank strings, like this:

INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('Display the model.', 'QUICKUPDATES_DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the model.', 'QUICKUPDATES_MODIFY_MODEL', 'false', 'Allow/Disallow the model modification', 300, 2, '2003-06-04 05:04:07', '2003-06-04 04:25:57', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the name.', 'QUICKUPDATES_DISPLAY_NAME', 'true', 'Enable/Disable the name displaying', 300, 3, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the name of the products.', 'QUICKUPDATES_MODIFY_NAME', 'false', 'Allow/Disallow the name modification?', 300, 4, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the Description.', 'QUICKUPDATES_DISPLAY_DESCRIPTION', 'true', 'Enable/Disable the displaying of description', 300, 5, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the description of the products.', 'QUICKUPDATES_MODIFY_DESCRIPTION', 'true', 'Allow/Disallow the Description modification?', 300, 6, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the status of the products.', 'QUICKUPDATES_DISPLAY_STATUS', 'true', 'Allow/Disallow the Status displaying and modification', 300, 7, '2003-06-04 05:07:11', '2003-06-04 05:00:58', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the weight of the products.', 'QUICKUPDATES_DISPLAY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', 300, 8, '2003-06-04 05:06:44', '2003-06-04 04:33:16', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the quantity of the products.', 'QUICKUPDATES_DISPLAY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', 300, 9, '2003-06-04 05:06:48', '2003-06-04 04:34:34', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the manufacturer of the products.', 'QUICKUPDATES_MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', 300, 10, '2003-06-04 05:06:57', '2003-06-04 04:37:40', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Modify the class of tax of the products.', 'QUICKUPDATES_MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', 300, 11, '2003-06-04 05:06:40', '2003-06-04 04:31:53', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display price with all included of tax.', 'QUICKUPDATES_DISPLAY_TVA_OVER', 'true', 'Enable/Disable the displaying of the Price with all tax included when your mouse is over a product', 300, 12, '2003-06-04 05:07:02', '2003-06-04 04:38:45', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the link towards the products information page.', 'QUICKUPDATES_DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', 300, 14, '2003-06-04 05:19:13', '2003-06-04 05:15:50', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the link towards the page where you will be able to edit the product.', 'QUICKUPDATES_DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link towards the page where you will be able to edit the product', 300, 15, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the manufacturer.', 'QUICKUPDATES_DISPLAY_MANUFACTURER', 'false', 'Do you want just display the manufacturer ?', 300, 16, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Display the tax.', 'QUICKUPDATES_DISPLAY_TAX', 'true', 'Do you want just display the tax ?', 300, 17, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Activate or desactivate the commercial margin.', 'QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?', 300, 18, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

Thanks for your help again doc.
I tried the above and got the same
I checked out upgrade_exceptions and it reports the same as the error above.
phpmyadmin reports that 2 items were succesfully inserted.
When I click the quick updates mod, all I get is a table with the prices only, Im pretty sure its an sql issue as none of the configs are being read from the config settings as they cant be inserted.
I will try inserting one by one now
PS yes I have searched the forum and read 4 threads related to this mod (some are 7 pages long) but havent tried contacting the author yet as im 99% sure its an sql thing.

[DrByte]

What's in the "Quick Updates" group under Admin->Configuration?

[Reesy]

A nice blank table with the headings title value and action with a heading above saying quick updates.

[Reesy]

I just tried running this...

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');
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 the model.', 'QUICKUPDATES_DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

and it failed at the first.