[Skip to main content](#vessel-content) # Error 1064 ## - **[darren](/forum/user/14044-darren "View darren's Profile")** - [![darren's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/14044-darren "View darren's Profile") Topic Author - [ Offline](/forum/user/14044-darren) Less More - Posts: 7 - Thank you received: 0 - - 12 years 4 months ago [\#161281](#161281) by [darren](/forum/user/14044-darren "View darren's Profile") *[Error 1064](/forum/25-install-update/869179-error-1064#161281 "-- url of the page with the problem -- : http://http://fermoy.com.au/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Google Chrome 35.0.1916.153 m -- Error-message(debug-mod must be tuned on) -- : Error_message 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '> 1400572800 AND 1400572800 AND P BY prod.order_product_name ORDER BY Total DESC LIMIT 7 I know this has been passed around a few times before and i believe i have read every post relating to this however i cannot find an answer that directly relates to my issue. I have just completed an upgrade from Joomla 2.5 to 3. and the problem has surfaced since then. Can you assist me in this matter? Please see below for Call Stack on Database Query Call Stack JROOT/administrator/components/com_hikashop/classes/widget.php:1643 JROOT/administrator/components/com_hikashop/classes/widget.php:675 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1396 JROOT/administrator/components/com_hikashop/helpers/helper.php:1136 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1384 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:159 JROOT/libraries/cms/application/cms.php:245 JROOT/administrator/index.php:42")* was created by *[darren](/forum/user/14044-darren "View darren's Profile")* -- url of the page with the problem -- : http://http://fermoy.com.au/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Google Chrome 35.0.1916.153 m -- Error-message(debug-mod must be tuned on) -- : Error_message 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '> 1400572800 AND < 1404187980 GROUP BY prod.order_product_name ORDER BY Total D' at line 1 SQL=SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity FROM mmp_pl7vu_hikashop_order_product AS prod LEFT JOIN mmp_pl7vu_hikashop_order AS a on a.order_id=prod.order_id WHERE > 1400572800 AND < 1404187980 GROUP BY prod.order_product_name ORDER BY Total DESC LIMIT 7 I know this has been passed around a few times before and i believe i have read every post relating to this however i cannot find an answer that directly relates to my issue. I have just completed an upgrade from Joomla 2.5 to 3. and the problem has surfaced since then. Can you assist me in this matter? Please see below for Call Stack on Database Query Call Stack JROOT/administrator/components/com_hikashop/classes/widget.php:1643 JROOT/administrator/components/com_hikashop/classes/widget.php:675 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1396 JROOT/administrator/components/com_hikashop/helpers/helper.php:1136 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1384 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:159 JROOT/libraries/cms/application/cms.php:245 JROOT/administrator/index.php:42 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2OTE3OS1lcnJvci0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 4 months ago [\#161327](#161327) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Error 1064](/forum/25-install-update/869179-error-1064#161327 "-- url of the page with the problem -- : http://http://fermoy.com.au/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Google Chrome 35.0.1916.153 m -- Error-message(debug-mod must be tuned on) -- : Error_message 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '> 1400572800 AND 1400572800 AND P BY prod.order_product_name ORDER BY Total DESC LIMIT 7 I know this has been passed around a few times before and i believe i have read every post relating to this however i cannot find an answer that directly relates to my issue. I have just completed an upgrade from Joomla 2.5 to 3. and the problem has surfaced since then. Can you assist me in this matter? Please see below for Call Stack on Database Query Call Stack JROOT/administrator/components/com_hikashop/classes/widget.php:1643 JROOT/administrator/components/com_hikashop/classes/widget.php:675 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1396 JROOT/administrator/components/com_hikashop/helpers/helper.php:1136 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1384 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:159 JROOT/libraries/cms/application/cms.php:245 JROOT/administrator/index.php:42")* Hello, Firstly can you download again the last Hikashop through our website, install it through your new joomla 3 and test it again ? Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2OTE3OS1lcnJvci0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[darren](/forum/user/14044-darren "View darren's Profile")** - [![darren's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/14044-darren "View darren's Profile") Topic Author - [ Offline](/forum/user/14044-darren) Less More - Posts: 7 - Thank you received: 0 - - 12 years 4 months ago [\#161352](#161352) by [darren](/forum/user/14044-darren "View darren's Profile") Replied by *[darren](/forum/user/14044-darren "View darren's Profile")* on topic *[Error 1064](/forum/25-install-update/869179-error-1064#161352 "-- url of the page with the problem -- : http://http://fermoy.com.au/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Google Chrome 35.0.1916.153 m -- Error-message(debug-mod must be tuned on) -- : Error_message 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '> 1400572800 AND 1400572800 AND P BY prod.order_product_name ORDER BY Total DESC LIMIT 7 I know this has been passed around a few times before and i believe i have read every post relating to this however i cannot find an answer that directly relates to my issue. I have just completed an upgrade from Joomla 2.5 to 3. and the problem has surfaced since then. Can you assist me in this matter? Please see below for Call Stack on Database Query Call Stack JROOT/administrator/components/com_hikashop/classes/widget.php:1643 JROOT/administrator/components/com_hikashop/classes/widget.php:675 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1396 JROOT/administrator/components/com_hikashop/helpers/helper.php:1136 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1384 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:159 JROOT/libraries/cms/application/cms.php:245 JROOT/administrator/index.php:42")* Hi Mohamed I had already done that a couple of times prior to this post. Just tried again but error still exists. Darren Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2OTE3OS1lcnJvci0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 12 years 4 months ago [\#161406](#161406) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error 1064](/forum/25-install-update/869179-error-1064#161406 "-- url of the page with the problem -- : http://http://fermoy.com.au/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Google Chrome 35.0.1916.153 m -- Error-message(debug-mod must be tuned on) -- : Error_message 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '> 1400572800 AND 1400572800 AND P BY prod.order_product_name ORDER BY Total DESC LIMIT 7 I know this has been passed around a few times before and i believe i have read every post relating to this however i cannot find an answer that directly relates to my issue. I have just completed an upgrade from Joomla 2.5 to 3. and the problem has surfaced since then. Can you assist me in this matter? Please see below for Call Stack on Database Query Call Stack JROOT/administrator/components/com_hikashop/classes/widget.php:1643 JROOT/administrator/components/com_hikashop/classes/widget.php:675 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1396 JROOT/administrator/components/com_hikashop/helpers/helper.php:1136 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1384 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:159 JROOT/libraries/cms/application/cms.php:245 JROOT/administrator/index.php:42")* Hi, Go in the menu Orders>Reports and disable all the enabled reports. Then, you should not have the problem. You can then create new reports and enable them and you should not get that error anymore. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2OTE3OS1lcnJvci0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[darren](/forum/user/14044-darren "View darren's Profile")** - [![darren's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/14044-darren "View darren's Profile") Topic Author - [ Offline](/forum/user/14044-darren) Less More - Posts: 7 - Thank you received: 0 - - 12 years 4 months ago [\#161690](#161690) by [darren](/forum/user/14044-darren "View darren's Profile") Replied by *[darren](/forum/user/14044-darren "View darren's Profile")* on topic *[Error 1064](/forum/25-install-update/869179-error-1064#161690 "-- url of the page with the problem -- : http://http://fermoy.com.au/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Google Chrome 35.0.1916.153 m -- Error-message(debug-mod must be tuned on) -- : Error_message 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '> 1400572800 AND 1400572800 AND P BY prod.order_product_name ORDER BY Total DESC LIMIT 7 I know this has been passed around a few times before and i believe i have read every post relating to this however i cannot find an answer that directly relates to my issue. I have just completed an upgrade from Joomla 2.5 to 3. and the problem has surfaced since then. Can you assist me in this matter? Please see below for Call Stack on Database Query Call Stack JROOT/administrator/components/com_hikashop/classes/widget.php:1643 JROOT/administrator/components/com_hikashop/classes/widget.php:675 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1396 JROOT/administrator/components/com_hikashop/helpers/helper.php:1136 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1384 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:159 JROOT/libraries/cms/application/cms.php:245 JROOT/administrator/index.php:42")* Works a treat. Thank you very much. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2OTE3OS1lcnJvci0xMDY0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.056 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)