Trouble with order export

[Ollie]

I'm not being able to export orders via the Admin panel.

Error message: warning: AbanteCart core v.1.2.0 include(config.php): failed to open stream: No such file or directory in <b>/home2/xxx/public_html/store/admin/view/default/template/pages/sale/order_details.tpl</b> on line <b>2</b>

I already checked the setting in config.php and they all look good.

How can I fix this problem?

[abolabo]

what is on line 2 of your /home2/xxx/public_html/store/admin/view/default/template/pages/sale/order_details.tpl file?

[Ollie]

what is on line 2 of your /home2/xxx/public_html/store/admin/view/default/template/pages/sale/order_details.tpl file?

Line 2 reads --> include("config.php");

I tried to download again and this time it says "There has been a critical error processing your request".

Below is a record of the Error Log:

2015-03-18 11:16:07 - database error: AbanteCart core v.1.2.0 Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
Error No: 1104
SELECT shipping_zones.code AS shipping_zone_code, payment_zones.code AS payment_zone_code, orders.*,
GROUP_CONCAT(DISTINCT order_options.order_option_id SEPARATOR " - ") AS order_options0order_option_id,
GROUP_CONCAT(DISTINCT order_options.order_product_id SEPARATOR " - ") AS order_options0order_product_id,
GROUP_CONCAT(DISTINCT order_options.product_option_value_id SEPARATOR " - ") AS order_options0product_option_value_id,
GROUP_CONCAT(DISTINCT order_options.name SEPARATOR " - ") AS order_options0name,
GROUP_CONCAT(DISTINCT order_options.value SEPARATOR " - ") AS order_options0value,
GROUP_CONCAT(DISTINCT order_options.price SEPARATOR " - ") AS order_options0price,
GROUP_CONCAT(DISTINCT order_options.prefix SEPARATOR " - ") AS order_options0prefix,
order_products.order_product_id AS order_products0order_product_id,
order_products.product_id AS order_products0product_id,
order_products.name AS order_products0name,
GROUP_CONCAT(DISTINCT CONCAT(order_products.model,IFNULL(product_option_values.sku,"")) SEPARATOR " - ") AS order_products0model,
order_products.price AS order_products0price,
order_products.total AS order_products0total,
order_products.tax AS order_products0tax,
order_products.quantity AS order_products0quantity,
order_products.subtract AS order_products0subtract,
order_totals0.order_total_id AS order_totals0order_total_id,
order_totals0.title AS order_totals0title,
order_totals0.text AS order_totals0text,
order_totals0.value AS order_totals0value,
order_totals0.sort_order AS order_totals0sort_order,
order_totals0.type AS order_totals0type,
order_totals1.order_total_id AS order_totals1order_total_id,
order_totals1.title AS order_totals1title,
order_totals1.text AS order_totals1text,
order_totals1.value AS order_totals1value,
order_totals1.sort_order AS order_totals1sort_order,
order_totals1.type AS order_totals1type,
order_totals2.order_total_id AS order_totals2order_total_id,
order_totals2.title AS order_totals2title,
order_totals2.text AS order_totals2text,
order_totals2.value AS order_totals2value,
order_totals2.sort_order AS order_totals2sort_order,
order_totals2.type AS order_totals2type,
order_totals3.order_total_id AS order_totals3order_total_id,
order_totals3.title AS order_totals3title,
order_totals3.text AS order_totals3text,
order_totals3.value AS order_totals3value,
order_totals3.sort_order AS order_totals3sort_order,
order_totals3.type AS order_totals3type
FROM orders
JOIN order_products ON orders.order_id=order_products.order_id
LEFT JOIN order_options ON order_products.order_product_id=order_options.order_product_id
JOIN order_totals as order_totals0 ON orders.order_id=order_totals0.order_id AND order_totals0.type="subtotal"
LEFT JOIN order_totals as order_totals1 ON orders.order_id=order_totals1.order_id AND order_totals1.type="shipping"
LEFT JOIN order_totals as order_totals2 ON orders.order_id=order_totals2.order_id AND order_totals2.type="tax"
LEFT JOIN order_totals as order_totals3 ON orders.order_id=order_totals3.order_id AND order_totals3.type="total"
LEFT JOIN product_option_values on order_options.product_option_value_id = product_option_values.product_option_value_id
LEFT JOIN zones AS shipping_zones on orders.shipping_zone_id = shipping_zones.zone_id
LEFT JOIN zones AS payment_zones on orders.payment_zone_id = payment_zones.zone_id
WHERE orders.order_status_id!=0 AND (orders.payment_method LIKE "Credit Card%" OR orders.payment_method="Paypal") GROUP BY order_products0order_product_id ORDER BY order_id in <b>/home2/xxx/public_html/store/core/database/mysql.php</b> on line <b>114</b>

[abolabo]

what is on line 2 of your /home2/xxx/public_html/store/admin/view/default/template/pages/sale/order_details.tpl file?

Line 2 reads --> include("config.php");

Are you sure?
1. abantecart do not include config.php by this way. At least include("config.php"); is wrong.
2. please compare you file with this https://github.com/abantecart/abantecart-src/blob/master/public_html/admin/view/default/template/pages/sale/order_details.tpl

[Ollie]

Indeed there are some differences. I believe this file was customized by my developer.