appwrite indexes not working (?

i have this index:

       "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

As I can see from the first screenshot you've shared, you haven't defined the length for the eventID and userID i.e. it is 0. Maybe that could be the possible reason behind the behaviour you're experiencing

So try updating the length to something like 255 for both

mmm apparently was a tremendous bug

thanks 🙂