Categories
View Replies (8)

Resolved Duplicate entry '0' for key 'PRIMARY' - Category import

  1. RobertoDS
    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)
com_csvi.log.29.zip
0
Responses (8)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for posting the file. With your import file import finished without any errors. See attached screenshot. Can you clean the broken category records from your previous imports and then run the import? You can use Remove empty categories operation in Maintenance for VirtueMart to do that. Run import and see if that helps.
Attachments (2)
Screenshot 2025-09-03 at 4.06.34 PM.png Screenshot 2025-09-03 at 4.06.34 PM.png
Screenshot 2025-09-03 at 4.14.10 PM.png Screenshot 2025-09-03 at 4.14.10 PM.png
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. # 1
RobertoDS
RobertoDS
Accepted Answer Pending Moderation
here you are
Attachments (1)
PRODOTTI-LA-GOURMET - SOTTOCATEGORIE (2).tsv
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you post the import file as requested? I will run the import in my test site and check.
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. # 3
RobertoDS
RobertoDS
Accepted Answer Pending Moderation
Not there yet
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Please post the import file used. I will run the import and check.
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
RobertoDS
RobertoDS
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)
com_csvi.log.35.zip
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
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. more than a month ago
  2. RO CSVI
  3. # 7
RobertoDS
RobertoDS
Accepted Answer Pending Moderation
I tryed a different configuration but no change
Attachments (1)
com_csvi.log.34.zip
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


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