Duplicate record detected
Options
![Jay](https://us.v-cdn.net/6037124/user_avatars/2364889.jpg)
Jay
Member ✭
Getting an error: "Duplicate record detected. Please check your input and try again."
This happens on an Add Record - User with only these fields:
[image.png]
How can an add record result in a duplicate record error? isn't the only unique ID is the "id" which is not set manually anyway?
This happens on an Add Record - User with only these fields:
[image.png]
How can an add record result in a duplicate record error? isn't the only unique ID is the "id" which is not set manually anyway?
Comments
-
Duplicate record errors are thrown when there is a Unique index in your database and a duplicate is being added. By default in the user table both the ID and email fields have individual unique indexes. If you haven't added additional custom unique indexes, please check the email field
-
There is only one existing record, which does not have an email set. And in the example above, i am not adding an email.
-
Solved: Had more than one unique index on the user table!
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback