Random Error 1064 after Upgrade

  • Posts: 1
  • Thank you received: 0
10 years 8 months ago #147399

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

Last edit: 10 years 8 months ago by wende.

Please Log in or Create an account to join the conversation.

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
10 years 8 months ago #147403

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,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: wende

Please Log in or Create an account to join the conversation.

Time to create page: 0.058 seconds
Powered by Kunena Forum