Ever since I first installed Hikashop Business, there's this code sequence on the dashboard.
Could anyone tell me what is wrong and how do I remedy the issue?
string(38) " ORDER BY a.order_created DESC LIMIT 7" string(234) "SELECT b.*,a.* FROM #__hikashop_order AS a LEFT JOIN #__hikashop_user AS b ON a.order_user_id=b.user_id WHERE a.order_type='sale' AND a.order_created > 1360452324 AND a.order_created < 1363044324 ORDER BY a.order_created DESC LIMIT 7" string(68) " GROUP BY calculated_date, currency_id ORDER BY calculated_date DESC" string(353) "SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(a.order_created AS SIGNED )+0),'%Y %j') AS calculated_date, SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id FROM #__hikashop_order AS a WHERE a.order_type='sale' AND a.order_created > 1360452324 AND a.order_created < 1363044324 GROUP BY calculated_date, currency_id ORDER BY calculated_date DESC" string(0) "" string(316) "SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id FROM #__hikashop_order AS a LEFT JOIN #__hikashop_order_product AS prod ON a.order_id=prod.order_id WHERE a.order_type='sale' AND a.order_created > 1360452324 AND a.order_created < 1363044324 GROUP BY a.order_currency_id" string(0) "" string(332) "SELECT COUNT(DISTINCT(a.order_id)) as Total, a.order_currency_id FROM #__hikashop_order AS a LEFT JOIN #__hikashop_order_product AS prod ON a.order_id=prod.order_id WHERE a.order_type='sale' AND a.order_status IN ('created','confirmed') AND a.order_created > 1362978000 AND a.order_created < 1363044324 GROUP BY a.order_currency_id"