Forums / Basic Configuration / Duplicate listing in Admin > Config menu

Duplicate listing in Admin > Config menu

Locked

Views: 1,127

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
23 Jun 2010, 11:44 PM
#1
iscatech avatar

iscatech

New Zenner

Join Date:
Mar 2009
Posts:
48
Plugin Contributions:
0

Duplicate listing in Admin > Config menu

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!

9 Jul 2010, 9:56 AM
#2
jimmy2k0 avatar

jimmy2k0

New Zenner

Join Date:
Jan 2010
Posts:
2
Plugin Contributions:
0

Re: Duplicate listing in Admin > Config menu

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.

12 Aug 2010, 4:25 PM
#3
iscatech avatar

iscatech

New Zenner

Join Date:
Mar 2009
Posts:
48
Plugin Contributions:
0

Re: Duplicate listing in Admin > Config menu

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!