This error is caused by the fact that when you were building the table, you set the key to be UNIQUE. When a user with the same name appears, the user will report
user_name INT NOT NULL UNIQUE
It’s also possible that this is the key that you just want to make unique but you insert this key twice later
for example you insert something with id 1
and then you insert something with id 1 because you can only have one field with id 1 so you get an error here
Read More:
- django.db.utils.IntegrityError: UNIQUE constraint failed: auth_user.username
- greendao insert data UNIQUE constraint failed: PURCHASE_ORDER_TABLE._id (code 1555)
- [Oracle] when inserting data, “ora-00001: unique constraint” appears
- IntegrityError at ** NOT NULL constraint failed: learning_logs_topic.owner_id
- django.db.utils .IntegrityError: NOT NULL constraint failed: blog_ blog.author_ ID error resolution
- Failed to add the foreign key constraint. Missing index for constraint ‘stu_ibfk_1’ in the reference
- 1822 – Failed to add the foreign key constraint. Missing index for constraint ‘tb_emp_ibfk_1’ in the
- Utraiso recording DVD application area failed power calibration area error
- [resolved] superset failed to create admin user: error! User already exists user or attributeerror: ‘nonetype’‘
- entity framework core + SQLite Error 1: ‘no such table: Blogs’.
- MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
- How can Oracle query tables of other users without adding a table user name
- Mysql error when deleting the table structure: Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails
- sqoop-import ERROR tool.ImportTool: Import failed: No primary key could be found for table user_info
- Add samba user prompt Failed to add entry for user.
- sqlite3.OperationalError: no such column:
- Pymong adds a unique index pymongo. Errors. Duplicatekeyerror
- How to use the menu of elementui unique opened sidebar
- Error no module named ‘in newly installed Python_ sqlite3‘
- DB2 create table error – 104 42601 illegal symbol encountered in SQL statement