1. southwoods
  2. RO CSVI
  3. Tuesday, 20 September 2022
  4.  Subscribe via email
I setup a Joomla User import template which worked fine to update custom fields for joomla user accounts until the last update... Now I am getting the following error when I run the same template:

An error has occurred during the import. Below the information received from the server:
Duplicate entry '71-4' for key 'PRIMARY'

Which is the user ID for the first user it is trying to update. I even deleted all of the users and tried running the template again, but it only creates the first user with that ID and then gives the error again.

Any help would be greatly appreciated as I am not sure what has changed to cause this behavior.
Accepted Answer Pending Moderation
Hello,
Please post the import debug log, import file and template XML file to check. To get the debug log see How to collect debug information? document. To get template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select the import template and download the XML file. Post the XML file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 5 days ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Thank you for your response... the import file is a Google Spreadsheet, please see the xml and logs attached.
Attachments (2)
  1. 5 days ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Thank you for posting the requested files. From the debug log I see that import breaks when inserting user groups for the first user with ID 71. There seems to be already an existing record in #__user_usergroup_map with user_id 71 and group_id 4. To check the existing records, do an export using Custom table export by setting table as #__user_usergroup_map on Options tab. Add user_id and group_id as template fields and run the export. Post the export file to check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 5 days 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!