Mysql Error on csv import

Start
Prev
1
Next
End

krisi94
Topic Author
Offline

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.

nicolas
Away

Posts: 83024
Thank you received: 13403
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.