Problems with QuickUpdates installation

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

[whocaresanyway]

change the top line to this

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

[Reesy]

Thank you for your suggestion but I dont want to add another configuration somehow.

[whocaresanyway]

that is where your error is,
300 has been used by another module.

so by adding it as '' it will auto increment.

you will need this to have the module work.

[DrByte]

A. BE SURE TO DO A DATABASE BACKUP FIRST !!!

1. Find out what id#300 is:

SELECT configuration_group_title FROM configuration_group where configuration_group_id = 300;

2. if the result from the statement above is "Quick Updates", then you can run the following to remove it:

DELETE from configuration_group where configuration_title = 'Quick Updates';
DELETE from configuration where configuration_key like 'QUICKUPDATES_%';

3. If the result from step 1 is NOT "Quick Updates", then you have some other mod using that group id, and removing it may cause you other grief.

[Reesy]

Sorry, I re-read the above and I forgot to add.
Id like to drop the changes first before applying the fix above for the sql.
Thanks for the fix.

Can anyone help with removing it first?
Thanks

[Reesy]

A. BE SURE TO DO A DATABASE BACKUP FIRST !!!

1. Find out what id#300 is:

SELECT configuration_group_title FROM configuration_group where configuration_group_id = 300;

2. if the result from the statement above is "Quick Updates", then you can run the following to remove it:

DELETE from configuration_group where configuration_title = 'Quick Updates';
DELETE from configuration where configuration_key like 'QUICKUPDATES_%';

3. If the result from step 1 is NOT "Quick Updates", then you have some other mod using that group id, and removing it may cause you other grief.

Database is backed up :)

Hi Chris,
Thanks for the above. It is definately quick updates and it definately has a config id of 300 as I can see it in the task bar but when I tried your code I received...

1054 Unknown column 'configuration_title' in 'where clause'

[Reesy]

I THINK that should have read...
configuration_group_title not configuration_title
Can anyone confirm please?

DELETE from configuration_group where configuration_group_title = 'Quick Updates';
DELETE from configuration where configuration_key like 'QUICKUPDATES_%';

[Reesy]

Well the database is backed up and the sql errors suggested to me the above was correct so I tried it and it worked!

Thanks to all those that helped!!!!!!!!!!!!!!!

[DrByte]

yup - correct ... sorry for the typo.