1. RobertoDS
  2. RO CSVI
  3. Tuesday, 02 September 2025
  4.  Subscribe via email
I'm trying to import the category tree but i'm getting "Duplicate entry '0' for key 'PRIMARY'" error and I don't know how to do it
Attachments (1)
Accepted Answer Pending Moderation
I tryed a different configuration but no change
Attachments (1)
  1. 1 day ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
If I run the query from your debug log I see error Data too long for column 'products_per_row' at row 1 and that is because products_per_row value is 24 in import file. VirtueMart has this field definition set to varchar(1) so it can take only one digit. That must be the reason for Duplicate entry '0' for key 'PRIMARY' error. Either change this value in import file or change products_per_row field definition in #__virtuemart_categories table. Check if that solves the error.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 1 hour ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Actually... in the second attempt Itried with the "products_per_row" field set to 1 and also without setting it up..
always Duplicate entry '0' for key 'PRIMARY' error
Attachments (1)
  1. 12 minutes ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


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