Zen Cart Logo
Forums / All Other Contributions/Addons / Too many SQL queries of the same contribution

Too many SQL queries of the same contribution

Locked

Views: 984

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
26 Apr 2007, 3:52 AM
#1
bigjoed avatar

bigjoed

Zen Follower

Join Date:
Apr 2006
Location:
Fort Bragg, North Carolina
Posts:
152
Plugin Contributions:
0

Too many SQL queries of the same contribution

I made a mistake:oops: and loaded the same SQL file twice on the "SQL Query Executor" of my admin. Now when I mouse over the menu, I get a several of the same option on the same dropdown menu. i.e. I mouse over "Configuration" and I get two "Easy Populate" options and three "News & Article Management". That's the number of times I added the same "sql query" into the database.

Because of that, when I look at my News & Article page on my site, I get three News & Article previews on the main page even though there is only one instance on the file that calls for the "News..."

Can anyone tell me how to: 1. Get rid of the extra options on the dropdown menu and 2. Fix the main page so that there's only one "News Preview"

Thanks

26 Apr 2007, 4:16 AM
#2
birdoasis avatar

birdoasis

Inactive

Join Date:
Jun 2005
Location:
Cheney WA
Posts:
1,123
Plugin Contributions:
0

Re: Too many SQL queries of the same contribution

I think if you can find the sql table that has that info in it you can delete the duplicate tables. And once you do that, then I believe the duplication in the menu's will be gone.

Usually there's a drop table if exist statement in the sql update, i'm surprised that it added the same fields again.