Database queries took down host. Please help

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

[linnx]

Yes, that query is in there... I will rename that file.. I'll look at the other file now.

<?php
$show_recent_orders_sidebox = true;
define('MAX_DISPLAY_RECENTORDERS','20');
define('MIN_DISPLAY_RECENTORDERS','1');
define('BOX_HEADING_RECENTORDERS','Recently Sold items');
define('BOX_HEADING_TRUNCATE','30');
define('BOX_HEADING_TRUNCATE_MORE','...');

/*$recent_orders_query = "select distinct op.products_id,op.products_name , o.delivery_city , o.delivery_country
from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op ,". TABLE_PAYPAL ." p
where o.orders_id = p.order_id
and o.orders_id = op.orders_id
order by o.orders_id desc
limit " . MAX_DISPLAY_RECENTORDERS;*/
$recent_orders_query = "select distinct op.products_id,op.products_name , o.delivery_city , o.delivery_country
from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op ,". TABLE_PAYPAL ." p
where o.orders_id = op.orders_id
order by o.orders_id desc
limit " . MAX_DISPLAY_RECENTORDERS;
$recent_orders = $db->Execute($recent_orders_query);
if ($recent_orders->RecordCount() >= MIN_DISPLAY_RECENTORDERS) {
$title = BOX_HEADING_RECENTORDERS;
$box_id = 'recentorders';
$rows = 0;
while (!$recent_orders->EOF) {
$rows++;
$recentorders_list[$rows]['id'] = $recent_orders->fields['products_id'];
$recentorders_list[$rows]['name'] = $recent_orders->fields['products_name'];
$recentorders_list[$rows]['city'] = $recent_orders->fields['delivery_city'];
$recentorders_list[$rows]['country'] = $recent_orders->fields['delivery_country'];

$recent_orders->MoveNext();
}
require($template->get_template_dir('tpl_recent_orders.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_recent_orders.php');
$title = 'Recently Sold items';
$title_link = false;
if( $column_box_default==''){
require($down_column_box_default);
}else{
require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default); }
}
?>

[gjh42]

You didn't respond to Kuroi's request to identify the mods you disabled. Posting their names and something about the source could really help other people avoid the problems you have had.

[linnx]

We disabled all mods in the sideboxes controller. But for some reason these mods were still running which leads me to believe they are hard coded. So disabling the mods did nothing to help - So if I told you which ones we disabled it wouldn't give any insight. This is a foreign installation (China) and is not like the standard zen cart I am used to dealing with. I will provide full details once I resolve it.

Thanks

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