Duplicate listing in Admin > Config menu

[iscatech]

Hey guys, I have a quick question. I was trying to install a new addon for Quickbooks and it seems I messed something up. I have multiple "Quickbooks Sync" entries in my Admin > Config section. How can I remove these duplicates?



Thanks!

[jimmy2k0]

run this tools > install SQL Patch

SQL Query Excutor

#NEXT_X_ROWS_AS_ONE_COMMAND:2
DELETE FROM `configuration_group` WHERE `configuration_group_id` NOT IN (
SELECT `configuration_group_id` FROM `configuration` WHERE 1);


This should delete the duplicate entries.

[iscatech]

Hi Jimmy2k0, thanks for the reply. I did run this in the SQL Query Executor, but I got this error:

1146 Table 'iscatech_cart.configuration' doesn't exist
in:
[DELETE FROM zen_configuration_group WHERE configuration_group_id NOT IN ( SELECT configuration_group_id FROM configuration WHERE 1);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any idea? Thank you!