- Posts: 3
- Thank you received: 0
Error Message on Hikashop Dashboard
13 years 6 months ago #94005
by vuudoo85
Error Message on Hikashop Dashboard was created by vuudoo85
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"
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"
Please Log in or Create an account to join the conversation.
13 years 6 months ago #94009
by nicolas
Replied by nicolas on topic Error Message on Hikashop Dashboard
That's just a trace that was a leftover of a test. Download again HikaShop and install again over and the message will be removed.
The following user(s) said Thank You: vuudoo85
Please Log in or Create an account to join the conversation.
Time to create page: 0.222 seconds