[SOLVED] Unable to create index in collection

Since yesterday whenever I try to create an index in the collection, it shows the success toast on the top but in the cloud dashboard, it shows as failed. Is this a server issue or something going wrong on my end?

Please provide an update on this issue it has been more than 12hrs.

You can only have full text indexes on string attributes. What's the type on those time attributes?

Time is int but I need it to order the search results.

Ya same problem. Maybe you can use a (iso formatted) string instead?

Ok I will try it out.

Even creating a Full text index with a string attribute is not working. The index creation gets failed all the time.

What's your project id?

647ad9717a0ab865a248

soooo your collection has somehow gotten into an inconsistent state. Were you creating indexes when we had our database upgrade/outage problems?

I did create two of the indexes and although they show as failed they actually work.

ya im not sure what happened. if you want to clean it up, the easiest thing to do would be to recreate the collection

Okk I will try that out and give an update.

Created a new collection based on the previous one however when I try to combine three fields in a index it still fails. Is this due to the inconsistent state or only two attributes can be combined in a index.

Same issue unable to create index even with two attributes.

the error was:

Specified key was too long; max key length is 3072 bytes

this had the same error:

Specified key was too long; max key length is 3072 bytes

for an explanation of that error, see https://medium.com/geekculture/appwrite-frequently-asked-questions-374ce81513fe#cab3

oh my bad I got it down now with some attribute modifications it works as intended. Thank you.

[SOLVED]Unable to create index in collection

[SOLVED] Unable to create index in collection