Categories
View Replies (30)

Resolved error message : "message":"Duplicate entry '0' for key 'PRIMARY'"

  1. owegen
    owegen
  2. RO CSVI
  3. Tuesday, 05 November 2019
  4.  Subscribe via email
Hello,

Have anyone an idea what is the problem here?

Status error: 200
Status message: OK
Warning: strstr(): Empty needle in ....../plugins/csviaddon/virtuemart/com_virtuemart/table/productprice.php on line 152 {"error":true,"process":false,"url":"administrator\/index.php?option=com_csvi&view=imports","message":"Duplicate entry '0' for key 'PRIMARY'"}

Many thanks
0
Responses (30)
owegen
owegen
Accepted Answer Pending Moderation
hello,

I see the categories (and the articles inside), but the categories become a number as category name
Attachments (2)
categories2.png categories2.png
categories3.png categories3.png
  1. more than a month ago
  2. RO CSVI
  3. # 1
owegen
owegen
Accepted Answer Pending Moderation
category name should be something like that
Attachments (1)
categories4.png categories4.png
  1. more than a month ago
  2. RO CSVI
  3. # 2
owegen
owegen
Accepted Answer Pending Moderation
it looks like the product price is imported as the category_path (name)
Attachments (2)
categories5.png categories5.png
categories6.png categories6.png
  1. more than a month ago
  2. RO CSVI
  3. # 3
owegen
owegen
Accepted Answer Pending Moderation
You need to place custom_title field in the right place in your template fields and run the import again.

can you tell me where? I'm sorry, I'm beginner with this tool and need your assistance
Attachments (1)
categories7.png categories7.png
  1. more than a month ago
  2. RO CSVI
  3. # 4
owegen
owegen
Accepted Answer Pending Moderation
Hello, I made the changes to be correct with my import files. But I become an error, the same as before.

Can you take a look at the new xml file?
Attachments (1)
csvi_templates_2020.fabien-bike.ch_20191219.zip
  1. more than a month ago
  2. RO CSVI
  3. # 5
owegen
owegen
Accepted Answer Pending Moderation
I think I found the problem. Now the import template is correct and I can see the right category name and the articles inside the categories with right price.

One last problem: I don't see any Image for article and categories.
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
One last problem: I don't see any Image for article and categories.

Can you post the debug log of your product import to check? To get the debug log check How to collect debug information? document.

For categories, you need to use VirtueMart Categories import operation to import images and by using file_url field. VirtueMart Product import will only import images for a product.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
owegen
owegen
Accepted Answer Pending Moderation
please take a look at this error
Attachments (1)
path1.png path1.png
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Yes and that is the reason images are not imported for products. Are the images placed in the given location on your server?


/home/httpd/vhosts/lemusse.ch/2020.fabien-bike.ch/images/stories/virtuemart/product


The error shows that RO CSVI is not able to find the images in the location and so it is not able to link it to the product.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
owegen
owegen
Accepted Answer Pending Moderation
hello, I made the changes, now it work as expected. Many thanks :-)
  1. more than a month ago
  2. RO CSVI
  3. # 10
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!