Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Vera
Vera
Brief
We have rewrote the MySQL query in 'admin_order_tables.php' script.
 
Description
Export of orders takes a lot of time and sometimes results in an empty page.
 
Solution
Download the updated version of the file:
http://www.viart.com/downloads/admin_table_orders-4.zip
 
Further, extract 'admin_order_tables.php' into 'admin' folder of your shop replacing an existing file. Please do not forget to make a backup copy of the current file in case something goes wrong.
 
8thSinCoffee
8thSinCoffee
Is this correct? The date on the admin_table_orders.php file in the .zip file is 2/9/2011. I didn't report this as an error until 3/25/2011.
 
Ibn Saeed
Ibn Saeed
Just checked
 
The change is from the following code :
 
============
if (isset($is_export) && $is_export) {
$sql .= " WHERE property_id IN (SELECT property_id FROM " . $table_prefix . "orders_items_properties ";
if (get_param("ids")) {
$sql .= " WHERE order_id IN (" . $db->tosql(get_param("ids"), INTEGERS_LIST) . ")";
}
$sql .= " GROUP BY property_id)";
$sql .= " GROUP BY property_id, property_name ";
} else {
$sql .= " GROUP BY property_name ";
}
 
=============
 
 
 
to
 
 
===============
 
 
if (get_param("ids")) {
$sql .= " WHERE order_id IN (" . $db->tosql(get_param("ids"), INTEGERS_LIST) . ")";
}
$sql .= " GROUP BY property_id, property_name ";
 
=================
 
 
Is this correct, you have removed a lot of lines.