Skip to content
Back

Creation failedUnknown sort order:asc. Must be one of ASC, DESC

  • 0
  • 3
  • Self Hosted
  • Databases
27 Jun, 2026, 22:13

Hi there,

I'm getting this error on self hosted when trying to create an Index. Any ideas?

TL;DR
Annoying bug prevents creation of field due to UI issue; will be fixed in next version.
28 Jun, 2026, 02:24

Are you writing small case asc instead of uppercase ASC ?

28 Jun, 2026, 02:24

Im not writing anything. Im selecting from the dropdown in the console ui.

28 Jun, 2026, 02:25

Ok. Can you share the screenshot?

28 Jun, 2026, 02:25

Cant write here. Latest version (setup today)

28 Jun, 2026, 02:25

Despite this the error is coming?

28 Jun, 2026, 02:26

Also when I dont put in a length (which is optional field) i get this: Index length is longer than the maximum: 1024

πŸ˜„

28 Jun, 2026, 02:26

Yepps

28 Jun, 2026, 02:26

Always have to create manually via curl request. Really sucks.

28 Jun, 2026, 02:27

Let me share this on <#636852860709240842> channel

28 Jun, 2026, 02:27

Alright, thx πŸ™‚

28 Jun, 2026, 06:11

i just tried this on self hosted branch installer:dev

28 Jun, 2026, 06:11

try using index lenght less than 1024 (optional defaults to php_int_max)

28 Jun, 2026, 16:16

Okay so I suppose its already fixed and it will work again on the next version πŸ™‚

28 Jun, 2026, 16:17

Yeah its just a annoying bug that i still have to fill an optional field out but it still won't create it due to the ui bug so it doesnt matter its just something I noticed aswell.

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