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

  • Posts: 57
  • Thank you received: 8
  • Hikaserial Standard Hikashop Business
2 weeks 3 days 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
plus.google.com/+JavierBallester
Hikashop Joomla! Magazine in Spanish
Tu tienda Online Joomla! Hikashop
magazine.joomla.org/es/ediciones-anterio...enda-online-joomla-3
Attachments:
Last edit: 2 weeks 2 days ago by nicolas.

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

  • Posts: 66303
  • Thank you received: 9727
  • MODERATOR
2 weeks 2 days 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.056 seconds
Powered by Kunena Forum