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

  • Posts: 81
  • Thank you received: 13
  • Hikaserial Standard Hikashop Business
4 years 8 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
Hikashop Joomla! Magazine in Spanish
Tu tienda Online Joomla! Hikashop
magazine.joomla.org/es/all-issues/februa...enda-online-joomla-3
Attachments:
Last edit: 4 years 8 months ago by nicolas.

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

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
4 years 8 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.060 seconds
Powered by Kunena Forum