Skip to content
Back

Issue related to index

  • 0
  • 3
  • Databases
  • Cloud
9 Jul, 2026, 17:22

Why it is showing this error?

TL;DR
The string type is deprecated in the latest version. Use Text, Mediumtext, Longtext, and Varchar instead. Varchar is suitable for attributes like ids due to its variable size.
10 Jul, 2026, 05:59

I think this is happening because of the individual sizes of the followerId and followingId columns. So that when they're indexed together, the total size exceeds 767.

10 Jul, 2026, 06:00

Can you tell if their type & size ?

10 Jul, 2026, 08:33

this happens to me when i index an int i'm not sure how to fix this with a string but if i set the int limit to under 737 it works so it could possibly be a bug

10 Jul, 2026, 09:18

In latest version, the string type is deprecated. There are other types available according to different sizes i.e. Text, Mediumtext, Longtext & Varchar. For attributes like ids, you can use Varchar as it has variable size

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