AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: Ollie on March 17, 2015, 03:39:44 PM

Title: Trouble with order export
Post by: Ollie on March 17, 2015, 03:39:44 PM: 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 /home2/xxx/public_html/store/admin/view/default/template/pages/sale/order_details.tpl on line 2

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

How can I fix this problem?
Title: Re: Trouble with order export
Post by: abolabo on March 18, 2015, 03:10:11 AM: what is on line 2 of your /home2/xxx/public_html/store/admin/view/default/template/pages/sale/order_details.tpl file?
Title: Re: Trouble with order export
Post by: Ollie on March 18, 2015, 01:26:29 PM: Quote from: abolabo on March 18, 2015, 03:10:11 AM
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 /home2/xxx/public_html/store/core/database/mysql.php on line 114
Title: Re: Trouble with order export
Post by: abolabo on March 18, 2015, 03:01:07 PM: Quote from: Ollie on March 18, 2015, 01:26:29 PM
Quote from: abolabo on March 18, 2015, 03:10:11 AM
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
Title: Re: Trouble with order export
Post by: Ollie on March 19, 2015, 04:59:14 AM: Indeed there are some differences. I believe this file was customized by my developer.