- Posts: 1
- Thank you received: 0
Random Error 1064 after Upgrade
12 years 6 months ago - 12 years 6 months ago #147399
by wende
Random Error 1064 after Upgrade was created by wende
can anyone please help me with following error
**An error has occurred.**
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 '> 1394150400 AND < 1394229059 GROUP BY c.category_id ORDER BY Total DESC LIMIT' at line 1 SQL=SELECT *, SUM(order_product_quantity) as Total FROM xdmsj_hikashop_order as a LEFT JOIN xdmsj_hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN xdmsj_hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN xdmsj_hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN xdmsj_hikashop_category as c ON cat.category_id=c.category_id WHERE > 1394150400 AND < 1394229059 GROUP BY c.category_id ORDER BY Total DESC LIMIT 5
**An error has occurred.**
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 '> 1394150400 AND < 1394229059 GROUP BY c.category_id ORDER BY Total DESC LIMIT' at line 1 SQL=SELECT *, SUM(order_product_quantity) as Total FROM xdmsj_hikashop_order as a LEFT JOIN xdmsj_hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN xdmsj_hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN xdmsj_hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN xdmsj_hikashop_category as c ON cat.category_id=c.category_id WHERE > 1394150400 AND < 1394229059 GROUP BY c.category_id ORDER BY Total DESC LIMIT 5
Last edit: 12 years 6 months ago by wende.
Please Log in or Create an account to join the conversation.
12 years 6 months ago #147403
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Hi,
Please provide us some useful information :
- Your HikaShop version number
- Your Joomla version number
- The context where you have this error
- A link to your website, if possible.
Regards,
Please provide us some useful information :
- Your HikaShop version number
- Your Joomla version number
- The context where you have this error
- A link to your website, if possible.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
The following user(s) said Thank You: wende
Please Log in or Create an account to join the conversation.
Time to create page: 0.135 seconds