I can't add customer user OTRS 5

[gecelann]

Hi!

Can I ask what are the possible cause if the customer user can't add in web interface but it actually add in database?
It always says that it has duplicate entry even if it is the first time to add.
Does it has the error if we have the same value/data in customer_id and in the email of the customer user?

Please see below the error in system log

Code: Select all

Duplicate entry '389' for key 'PRIMARY', SQL: 'INSERT INTO customer_user (title, first_name, last_name, login, email, customer_id, phone, fax, mobile, street, zip, city, country, comments, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

Even though it always says that it has duplicate error it will always add in customer user database but the it will not have customer information whenever we create a new ticket and it will not reflect in web interface. Please see the images below.

Selection_141.png

Selection_142.png

[reneeb]

What does the logs say?

[gecelann]

What does the logs say?

Hi reneeb!
Please see the images below.
It always says that it has duplicate entry but whenever i searched it in sql box it will show that it is successfully added in database but not in web user interface.

Selection_141.png

Selection_144.png

[gecelann]

It's weird because it will be actually seen when i searched it in customer user management
but it will show blank values please see the image, the data is invisible with dash value.

Selection_145.png

.