#appwrite indexes not working (?

4 messages · Page 1 of 1 (latest)

strong flicker
#

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

image.png image.png
sturdy stirrup
#

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

image.jpg
#

So try updating the length to something like 255 for both

strong flicker
#

mmm apparently was a tremendous bug