Back

[SOLVED] Index length is longer than the maximum error on 1.4

  • 0
  • Databases
obiwanzenobi
30 Aug, 2023, 22:08

Error while creating index:

Index length is longer than the maximum: 768 (400)

index type: unique index name: unique_externalId attributes params: String, 1024 length, dart server sdk ver 8.0.0

works fine on 1.3.8

TL;DR
The user encountered an error message stating "Index length is longer than the maximum" when working with the dart server sdk version 8.0.0. They discovered that the maximum index length is 768, but couldn't find documentation explaining why. The issue was resolved by updating to version 1.3.8, which did not have this error.
obiwanzenobi
30 Aug, 2023, 22:25

found it there

obiwanzenobi
30 Aug, 2023, 22:25

but why this is 768?

Drake
30 Aug, 2023, 22:28

this is the maximum by the database (mariadb/mysql)

obiwanzenobi
30 Aug, 2023, 22:51

[SOLVED] Index length is longer than the maximum error on 1.4

Drake
30 Aug, 2023, 22:54

let me discuss it with the team

obiwanzenobi
30 Aug, 2023, 22:56

It would be best to put that info into the docs

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