[Skip to main content](#vessel-content)

#   Error Message on Hikashop Dashboard

##

- **[vuudoo85](/forum/user/7409-vuudoo85 "View vuudoo85's Profile")**
- [![vuudoo85's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7409-vuudoo85 "View vuudoo85's Profile") Topic Author
- [ Offline](/forum/user/7409-vuudoo85)

Less More

- Posts: 3
- Thank you received: 0
-
-

13 years 8 months ago [\#94005](#94005) by [vuudoo85](/forum/user/7409-vuudoo85 "View vuudoo85's Profile")  *[Error Message on Hikashop Dashboard](/forum/3-bug-report/79193-error-message-on-hikashop-dashboard#94005 "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) &quot; ORDER BY a.order&#95;created DESC LIMIT 7&quot; string(234) &quot;SELECT b.&#42;,a.&#42; FROM #&#95;&#95;hikashop&#95;order AS a LEFT JOIN #&#95;&#95;hikashop&#95;user AS b ON a.order&#95;user&#95;id=b.user&#95;id WHERE a.order&#95;type='sale' AND a.order&#95;created &gt; 1360452324 AND a.order&#95;created  1360452324 AND a.order&#95;created  1360452324 AND a.order&#95;created  1362978000 AND a.order&#95;created rency&#95;id&quot;")* was created by *[vuudoo85](/forum/user/7409-vuudoo85 "View vuudoo85's Profile")*

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 &gt; 1360452324 AND a.order_created &lt; 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 &gt; 1360452324 AND a.order_created &lt; 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 &gt; 1360452324 AND a.order_created &lt; 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 &gt; 1362978000 AND a.order_created &lt; 1363044324 GROUP BY a.order_currency_id"
[ ![3-11-2013&#95;7-26-55&#95;PM.jpg](/forum/attachment/9052) ](/forum/attachment/9052 "...7-26-55&#95;PM.jpg")

- [ ![3-11-2013&#95;7-26-55&#95;PM.jpg](/forum/attachment/9052) ](/forum/attachment/9052 "...7-26-55&#95;PM.jpg") [ ](/forum/attachment/9052?download=1 "...7-26-55&#95;PM.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTE5My1lcnJvci1tZXNzYWdlLW9uLWhpa2FzaG9wLWRhc2hib2FyZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

13 years 8 months ago [\#94009](#94009) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error Message on Hikashop Dashboard](/forum/3-bug-report/79193-error-message-on-hikashop-dashboard#94009 "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) &quot; ORDER BY a.order&#95;created DESC LIMIT 7&quot; string(234) &quot;SELECT b.&#42;,a.&#42; FROM #&#95;&#95;hikashop&#95;order AS a LEFT JOIN #&#95;&#95;hikashop&#95;user AS b ON a.order&#95;user&#95;id=b.user&#95;id WHERE a.order&#95;type='sale' AND a.order&#95;created &gt; 1360452324 AND a.order&#95;created  1360452324 AND a.order&#95;created  1360452324 AND a.order&#95;created  1362978000 AND a.order&#95;created rency&#95;id&quot;")*

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](/forum/user/7409-vuudoo85 "View vuudoo85's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTE5My1lcnJvci1tZXNzYWdlLW9uLWhpa2FzaG9wLWRhc2hib2FyZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.049 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
