19316: Import Users Via Csv - Internal error 500 - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

19316	Bug reports	Import/Export	public	2023-12-18 20:12	2024-01-16 22:31

Reporter	openstudio	Assigned To	ollehar
Priority	none	Severity	crash
Status	assigned	Resolution	open
Product Version	6.4.x

Summary	19316: Import Users Via Csv - Internal error 500
Description	I am trying to import the existing users I have into my LimeSurvey system. I built the csv file to be imported, which correctly constructed (required fields and valid inputs) - but every time I upload it, only one user gets uploaded and then I get this error: "500: Internal Server Error CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-global-auth_db-12' for key 'lime_idx1_permissions'An internal error occurred while the Web server was processing your request."
Steps To Reproduce	I simply uploaded the csv file and got the error
Tags	error, import, users
Attached Files	Screenshot2023-12-18alle14.41.02.png (546,929 bytes)

Bug heat	8
Complete LimeSurvey version number (& build)	LimeSurvey Community Edition Version 6.4.0+231218
I will donate to the project if issue is resolved	No
Browser	Google Chrome
Database type & version	10.6.15-MariaDB-1:10.6.15+maria~ubu2204 - mariadb.org binary distribution
Server OS (if known)
Webserver software & version (if known)
PHP Version	8.1

User List	openstudio

ollehar 2023-12-19 10:16 administrator ~79041	Is this a regression from LimeSurvey 5.x?

openstudio 2023-12-19 10:59 reporter ~79042	@ollehar no, it’s a fresh installation

ollehar 2023-12-26 10:55 administrator ~79068	OK but does the user import work on an LS5 installation?

Mazi 2024-01-16 11:59 updater ~79176	@openstudio, can you provide a sample CSV file with dummy email addresses? @ollehar see also https://bugs.limesurvey.org/view.php?id=19349 -> Do you know who implemented this?

Mazi 2024-01-16 12:00 updater ~79177 Last edited: 2024-01-16 12:00

Mazi 2024-01-16 12:00 updater ~79178 Last edited: 2024-01-16 12:00

ollehar 2024-01-16 13:11 administrator ~79179	@Mazi Might have been Markus. Why?

openstudio 2024-01-16 22:31 reporter ~79191	@ollehar I don't have the chance to have a LS5 version, I would need to download and install a new version. Do you need me to do it? @Mazi here attached the csv file with dummy data test_survey_users_2024-01-16_21_27_14.csv (417 bytes) users_name;full_name;email;lang;password;brand_name;user_id;firstname;lastname john;john.d;john.doe@openstudio.one;en;ZjFa7H9PqM0D10gpeQGkE5gVW2VxLCYFXyJ4FfNo;#1 OpenStudio;1;John;Doe jane;jane.d;jane.doe@openstudio.one;en;5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8;#6 Test Brand name;261;Jane;Doe olivia;Olivia.g;olivia.grace@openstudio.one;En;723c86b357d57b4f378d174b52546b69ef38fbe0;#1 OpenStudio;262;Olivia;Grace test_survey_users_2024-01-16_21_27_14.csv (417 bytes)

Date Modified	Username	Field	Change
2023-12-18 20:12	openstudio	New Issue
2023-12-18 20:12	openstudio	File Added: Screenshot2023-12-18alle14.41.02.png
2023-12-18 20:12	openstudio	Tag Attached: import
2023-12-18 20:12	openstudio	Tag Attached: users
2023-12-18 20:13	openstudio	Tag Attached: error
2023-12-18 20:13	openstudio	Issue Monitored: openstudio
2023-12-18 20:13	openstudio	Bug heat	0 => 2
2023-12-19 10:16	ollehar	Assigned To	=> ollehar
2023-12-19 10:16	ollehar	Status	new => feedback
2023-12-19 10:16	ollehar	Note Added: 79041
2023-12-19 10:16	ollehar	Bug heat	2 => 4
2023-12-19 10:59	openstudio	Note Added: 79042
2023-12-19 10:59	openstudio	Bug heat	4 => 6
2023-12-19 10:59	openstudio	Status	feedback => assigned
2023-12-26 10:55	ollehar	Note Added: 79068
2023-12-26 10:55	ollehar	Status	assigned => feedback
2024-01-16 11:59	Mazi	Note Added: 79176
2024-01-16 11:59	Mazi	Bug heat	6 => 8
2024-01-16 12:00	Mazi	Note Added: 79177
2024-01-16 12:00	Mazi	Note Added: 79178
2024-01-16 12:00	Mazi	Note Edited: 79178
2024-01-16 12:00	Mazi	Note Edited: 79177
2024-01-16 13:11	ollehar	Note Added: 79179
2024-01-16 22:31	openstudio	Note Added: 79191
2024-01-16 22:31	openstudio	File Added: test_survey_users_2024-01-16_21_27_14.csv
2024-01-16 22:31	openstudio	Status	feedback => assigned