Mysql Error on csv import

  • Posts: 6
  • Thank you received: 0
6 years 7 months ago #292497

-- HikaShop version -- : 3.2.0
-- Joomla version -- : 3.8.0
-- PHP version -- : 7.1
-- Browser(s) name and version -- : Chrome 66.0.3359.139

Hi,

I created a mass action which imports a csv file from server. However, when I try to execute this mass action, I get a mysql error 1064. What can cause this error?
I am enclosing a screenshot about the error.

Thanks,
Kristóf

Attachments:

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

  • Posts: 82967
  • Thank you received: 13393
  • MODERATOR
6 years 7 months ago #292500

Hi,

It's apparently a problem with the categories of the products in your CSV, but hard to say more.
Try changing the line:

$insert[]='('.$entry.','.$status.','.(int)@$olds[$entry]->ordering.')';
to:
$insert[]='('.(int)$entry.','.(int)$status.','.(int)@$olds[$entry]->ordering.')';
in the file administrator/components/com_hikashop/classes/product.php
That should avoid the problem.
Let us know how it goes so that we can include the patch on our end if it helps.

The following user(s) said Thank You: krisi94

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

  • Posts: 6
  • Thank you received: 0
6 years 7 months ago #292550

Hi,

Thank you very much. It works

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

Time to create page: 0.062 seconds
Powered by Kunena Forum