Database error 1064 in HikaShop


  • Default avatar
    bmm01    
     9 years ago
    0

    Joomla version: 3.3.6
    HikaShop version: 2.3.2
    AwoRewards: 2.2.1
    AwoCoupon: 2.3.5. Pro

    I installed AwoRewards and it has stopped the sending of emails from HikaShop (order confirmation etc).

    When I edit the address details of a HikaShop order, I get the following error when saving:

    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 '' at line 1 SQL=SELECT o.*,u.user_cms_id as user_id FROM *****_hikashop_order o JOIN *****_hikashop_user u ON u.user_id=o.order_user_id WHERE o.order_id=

    I have had to disable AwoRewards.

    Thanks in advance for your help.
    Brett
  • Your avatar
    seyi    
     9 years ago
    0

    Hello,

    Please upgrade to the latest, 2.1.3, the issue has been fixed there.
  • Default avatar
    bmm01    
     9 years ago
    0

    Thanks for the quick response Seyi

    I have installed it OK and I can now edit the orders OK too.

    Just have to wait for a new order to see if the emails work :)

    Thanks and regards
    Brett