why it says `Can't find FULLTEXT index matching the column list`, when i do have the index
- 0
- Databases
- Web
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
Did you create a full text index on betDigitArray?
as the 2nd attachment shows, i created a fullText index with both betDigitArray and betType
would you please create 1 full text index with only betDigitArray?
1 fullText index with betDigitArray & 1 key index with betType?
The one you currently have and 1 full text with only the search attribute
Recommended threads
- MariaDB refuses to connect to appwrite
Earlier, I tried updating my Appwrite version from 18.1.x to the latest release because my Flutter package required it to function properly. I used the official...
- Custom API domain is unreachable
Earlier my custom api domain was working fine. Now it seems to be offline without a trace a few hours later. I didn't change anything, all the relevant DNS reco...
- "Invalid console fingerprint" when unpau...
I've tried logging out and logging back in, still can't figure out why this is happening.