Back
appwrite indexes not working (?
i have this index:
TypeScript
"indexes": [
{
"key": "single-user-per-event",
"type": "unique",
"status": "available",
"columns": [
"eventID",
"userID"
],
"orders": [
"asc",
"asc"
]
},
]
but for some reason i can continue creating multiple arrow with duplicate userID and eventID and appwrite dosen't get my an error...
as you can see in the picture 2, there're repeated userID and eventID in many rows
TL;DR
The developer is facing an issue where their indexes in Appwrite are not working properly, allowing multiple rows with duplicate `userID` and `eventID` to be created without generating an error.
Solution:
One possible solution could be to ensure that the unique index is applied correctly in the database schema settings of the Appwrite platform. Double-check the configuration and verify that the unique constraint is enforced on the `userID` and `eventID` columns to prevent duplicates.