Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'צביה -en' for key 'user__name

[morovinger]

Sometimes getUidByName in GigyaController.php returns empty array even though the name exists
This happens on regular basis if pre-gigya users exist in db
i suggest use user_load_by_name() as it tends to work more stability

[shaharzillber]

Hey,

Thank you for your message. Just to ensure security, we can't utilize user_load_by_name(). Have you encountered any specific cases where you received an empty array when you expected data to be present?

[Ynhockey]

Hi @morovinger It is necessary that the users are synchronized between Drupal and Gigya upon initial install. If your Drupal install has non-Gigya users that need to login with Gigya, they should be imported into Gigya. There is a system for quick mass import if you require – it's possible to open a support ticket and get help with this.

Does the issue also happen with any new users?