We are running into an SQL error when running a Hikashop Order export. This is the error:
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 ') GROUP BY order_number,order_created,order_status,user_email,order_pay' at line 34 SQL=SELECT order_number, order_created, order_status, user_email, as.address_firstnameASshipping_address_firstname, as.address_lastnameASshipping_address_lastname, as.address_companyASshipping_address_company, as.address_streetASshipping_address_street, as.address_street2ASshipping_address_street2, as.address_cityASshipping_address_city, as.address_stateASshipping_address_state, as.address_post_codeASshipping_address_post_code, as.address_telephoneASshipping_address_telephone, as.address_countryASshipping_address_country, order_payment_method, order_product_name, order_product_quantity, order_product_price, order_shipping_method, order_shipping_price, order_product_tax, order_full_price, serial_number, order_discount_codeFROM#__hikashop_orderASoLEFT JOIN#__hikashop_order_productASpONp.order_id=o.order_idLEFT JOIN#__hikashop_userASuONu.user_id=o.order_user_idLEFT JOIN#__hikashop_addressASabONab.address_id=o.order_billing_address_idLEFT JOIN#__hikashop_addressASasONas.address_id=o.order_shipping_address_idLEFT JOIN#__hikashop_productASprodONprod.product_code=p.order_product_codeLEFT JOIN#__usersASuserONuser.id=u.user_cms_idLEFT JOIN#__hikashop_product_categoryASpcONpc.product_id=prod.product_idLEFT JOIN#__hikashop_categoryAScatONcat.category_id=pc.category_idWHEREpc.category_idIN () GROUP BYorder_number,order_created,order_status,user_email,order_payment_method,order_product_name,order_product_quantity,order_product_price,order_shipping_price,order_full_price,serial_number,order_discount_code`
Attached is our template backup
Hello,
Please load the attached patch file and then in your export template settings on options tab look for category filter, set it to "Don't use" if you have nothing to be set in there. That should solve your issue.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
That fixed everything. Thank you.
Log in to reply to this topic.