Skip to content
Start project
Back

[SOLVED] Failed - Index creating

  • 0
  • Flutter
View on Discord
Khushal@2303
1 Jun, 2023, 10:05

I have n numbers of data in appwrite collection. I want to get that data where id is something and createdAt DESC. But I 'm getting error while creating index in it.

TL;DR
User encountered an error while creating an index. Initially, others were able to create it successfully. User decided to work with a different attribute instead. No project ID was shared, and the use case for the index was questioned. Ultimately, user decided to use the $createAt key instead of creating an index.
joeyouss
1 Jun, 2023, 10:27

you don't need fulltext on $createdAt. There is index by default on all internal attributes. Leave it on "key" and try recreating once?

D5
1 Jun, 2023, 10:42

I thought that was related to yesterday issue 😅

D5
1 Jun, 2023, 10:42

@Khushal@2303 Try this

Khushal@2303
1 Jun, 2023, 10:43

okay, I'm trying @joeyouss

Khushal@2303
1 Jun, 2023, 10:46

Getting same error

joeyouss
1 Jun, 2023, 10:47

is it on cloud?

Khushal@2303
1 Jun, 2023, 10:48

Yes, in cloud

joeyouss
1 Jun, 2023, 10:56

weird, i tried creating it, it is successful for me

joeyouss
1 Jun, 2023, 10:56

Can you DM me your project ID please?

joeyouss
1 Jun, 2023, 10:58

Also, why are you creating a createdAt index? can you tell me your use case of this?

Khushal@2303
1 Jun, 2023, 11:40

I think I don't need to create index for it. I will work with $createAt. So I will manage it with key $createAt. Thank you @joeyouss for you time.

Khushal@2303
1 Jun, 2023, 16:13

it's strange, I'm trying with other attribute and it's still failing

D5
1 Jun, 2023, 16:34

Seems like there are problems with the database cluster

joeyouss
1 Jun, 2023, 19:13

would be helpful if you share your project ID with me once?

D5
2 Jun, 2023, 14:10

@Khushal@2303 Does it work now? If not, send your project ID to Jyoti

Khushal@2303
4 Jun, 2023, 13:15

@D5 and @joeyouss Now working perfectly, don't know how but it's working fine now.

joeyouss
4 Jun, 2023, 13:16

That’s great to know, I shall close this then

D5
4 Jun, 2023, 13:20

[SOLVED] Failed - Index creating

D5
4 Jun, 2023, 13:24

Error in line 92749718848: Jyoti couldn't fetch further information

joeyouss
6 Jun, 2023, 04:03

I wonder if I might be an AI as well

Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more