1. barracuda69
  2. RO CSVI
  3. Thursday, 11 May 2023
  4.  Subscribe via email
Hi,

I'm trying to import a csv file (attached here) and I'm getting Duplicate entry '0' for key 'PRIMARY'

Could you help me troubleshoot it?

Thanks!

Dennis
Attachments (3)
Accepted Answer Pending Moderation
Had a same issue, the patch solved it. Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Dennis,
Please load the attached patch file and run the import again. I was able to see that error with import and fix in patch file should solve it. Let me know on how it goes.
Attachments (1)
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. # 2
Accepted Answer Pending Moderation
Sorry again Tharuna,

Now I'm getting Field 'customsforall_value_label' doesn't have a default value.....

Any ideas?

Thanks!
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Thank youuuuuuuu!!!!!!!!!!

:D
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Dennis,
The problem is with product_in_stock field in import file. It has values like '100,0', '40,0' in import file but product_in_stock in #__virtuemart_products table takes only integer values. This is breaking import query and so duplicate error. Please correct this column to have only integer values and run the import.
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. # 5
  • Page :
  • 1


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