Database queries took down host. Please help

[linnx]

Ok thanks. We've disabled some "Popular Products, recently sold, modules." And the problem went away. What is strange is that it just happened today. Nothing has changed for the past year. Just kind of popped up.

[DrByte]

What is strange is that it just happened today. Nothing has changed for the past year. Just kind of popped up.

"sudden" changes are always something to pay serious attention to.

http://www.zen-cart.com/forum/showthread.php?t=130161

[kuroi]

Could you be more specific about the modules that you disabled? If the problem does lie with one or other of them, it would be helpful for other users to know.

[linnx]

Well we disabled all modules that may have caused it and the problem is still occurring. Did a search for "select distinct op.products_id," in developers tool kit and nothing came up.

Is that query being issued in one of the php files?

[linnx]

If someone can offer guidance or would like to peak at the admin/ftp I can do that.

thank you :)

[linnx]

I asked the host which files were doing that query and he said

includes/modules/sideboxes/ezppt/recent_orders.php
includes/modules/sideboxes/order_history.php

How can I make it so those don't execute? I disabled everything in the side boxes controller. It is probably hard coded into one of the files.

[kuroi]

I'm not sure that I believe them, at least about the includes/modules/sideboxes/order_history.php file. They may have just searched on the first part of the query, which would return that, not the bits that might be causing the problem.

The includes/modules/sideboxes/ezppt/recent_orders.php is a more likely candidate. It's not part of Zen Cart or any mods that I've used. Have you opened it up to see if it contains the errant query? Have you tried removing the file and seeing if that cures the problem?

[kuroi]

Can't say where the query is coming from - it's not part of Zen Cart.

It's badly-written, but that's not much of a clue. It might be part of a poorly-constructed mod - most problems like this are. Or it might be that you've been hacked and some php is being executed in a location that wouldn't normally have php, which could explain why the the developers toolbar doesn't find it. Or it could be instigated by somebody connecting directly to your database. There's no way to tell just by looking at the error message.

If this were one of my clients sites I'd do a full file comparison against a fresh download of Zen Cart and ensure that I understood all the differences. Another approach would be to download the entire site and do a search for that query using a development IDE such as Dreamweaver, Eclipse or Aptana, unless your webhost offers an onserver search facility.