1. drmenzelit
  2. RO CSVI
  3. Monday, 25 July 2022
  4.  Subscribe via email
Hi,
I'm trying to export / import Virtuemart products between two installations (export from Joomla 3, import in Joomla 4), but I'm getting an error "Duplicate entry '0' for key 'PRIMARY'"
I already removed a lot of fields, but I can't find what is causing the problem.
Can you pelase help me?

Regards
Viviana
Attachments (2)
Accepted Answer
Accepted Answer Pending Moderation
Hello Viviana,
The problem is with the date format in your import file. The format is in d/m/Y H:i:s whereas database supported date format is Y-m-d H:i:s and so product insert query fails. You can solve this by setting date format to Y-m-d H:i:s in Joomla 3 export template and on File tab. See attached screenshot. Export and import with latest file 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. # Permalink
Accepted Answer Pending Moderation
Thank you very much!!! It worked now :D
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


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