Mass Action filter import csv file - Error 1064 You have an error in your SQL

  • Posts: 84
  • Thank you received: 13
  • Hikashop Business
5 years 4 months ago #308213

-- HikaShop version -- : 4.1.0
-- Joomla version -- : 3.9.8
-- PHP version -- : 7.1.3
-- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax;
/var/www/vhosts/.../httpdocs/libraries/joomla/database/driver/mysqli.php:665

Hi,
an error 1064 (info debug attached) is generated when I perform a mass action (display product) using as a filter a csv file import (see attached) that contains only the column product_code and only one record, and format UTF8.

I have reviewed the product.php , and it is ok.

I've done the test on other sites and I get the same result.

Regards
Javier


Javier Ballester
Attachments:
Last edit: 5 years 4 months ago by nicolas.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
5 years 4 months ago #308215

Hi,

Thank you for your feedback and all the details. We were able to reproduce the issue on our end and we'll add a fix in the next version of HikaShop.

The following user(s) said Thank You: Jabatec

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

Time to create page: 0.065 seconds
Powered by Kunena Forum