Back

why it says `Can't find FULLTEXT index matching the column list`, when i do have the index

  • 0
  • Databases
  • Web
manazo
25 Mar, 2023, 01:38

the attachment shows my code. I'm trying to search a string array type column, but want to exclude docs that have a specific text, using the notEqual method. I've created a fullText type index with both of the columns included (the second attachment shows my index). but it still throws an error in the console saying Server Error. when I checked the container logs, I found Can't find FULLTEXT index matching the column list. don't know what's happening

TL;DR
User is experiencing an error message stating "Can't find FULLTEXT index matching the column list" despite having a full text index. They have two indexes: one full text index with 'betDigitArray' and one key index with 'betType'. They are requesting assistance to create a full text index only with 'betDigitArray'. User has provided code and attachments showing their index creation. They are trying to search a string array column and exclude documents with a specific text using the notEqual method. The error occurs and user is unsure of what is happening. Solution: It seems that the issue is caused by not having a full text index
Drake
25 Mar, 2023, 02:28

Did you create a full text index on betDigitArray?

manazo
25 Mar, 2023, 05:57

as the 2nd attachment shows, i created a fullText index with both betDigitArray and betType

Drake
25 Mar, 2023, 15:58

would you please create 1 full text index with only betDigitArray?

manazo
25 Mar, 2023, 17:33

1 fullText index with betDigitArray & 1 key index with betType?

Drake
25 Mar, 2023, 17:42

The one you currently have and 1 full text with only the search attribute

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