Back

Fulltext Index Length Error on Any String Attribute Size

  • 0
  • Databases
Infinil
10 Sep, 2023, 05:42
TL;DR
The user is experiencing a Fulltext Index Length Error on any string attribute size. They are unsure if they should add their issue to an existing thread or create a new one. The solution suggested is to check if there is a previously created index causing the error. It is mentioned that arrays automatically become longtext. The user also mentions that the small_title attribute is 100 characters long, but they are still getting the 768 error.
Infinil
10 Sep, 2023, 05:42

small_title attribute is 100 chars long

Infinil
10 Sep, 2023, 05:42

then why i get this 768 error

Infinil
10 Sep, 2023, 05:43

Fulltext Index Length Error on Any String Attribute Size

Infinil
10 Sep, 2023, 06:33

but small_title isnt an array?

Drake
10 Sep, 2023, 06:33

Oops sorry I thought this was the same as another message you posted

Drake
10 Sep, 2023, 06:35

It could be due to a previously created index πŸ˜•

Infinil
10 Sep, 2023, 06:35

um

Infinil
10 Sep, 2023, 06:36

small_title is a new attribute tho

Infinil
10 Sep, 2023, 06:36

but i did create a new index for category_ids in https://discord.com/channels/564160730845151244/1148232459843018843

Infinil
10 Sep, 2023, 06:36

because remember we talked about the 36 max size for id attributes

Drake
10 Sep, 2023, 06:41

Index validation is done on all indexes

Infinil
10 Sep, 2023, 06:46

so whats the solution...

Infinil
10 Sep, 2023, 06:47

new collection-?

Drake
10 Sep, 2023, 06:48

Sure. Or wait to see what happens with https://github.com/appwrite/appwrite/issues/6129

Infinil
10 Sep, 2023, 06:52

but that issue is somewhat different than mine right.. should i add my issues as well? or create a new one?

Drake
10 Sep, 2023, 06:55

Just comment about your problem and πŸ‘ it

Infinil
10 Sep, 2023, 07:30

done πŸ‘

Infinil
10 Sep, 2023, 07:30

hope it reverts back because lot of collections are dependant on it

Reply

Reply to this thread by joining our Discord

Reply on Discord

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