Back

Error upgrading to 1.5

  • 0
  • Self Hosted
  • Flutter
DennisLBC
8 Mar, 2024, 22:06

Successfully went from 1.4 to 1.4.13 but then during the migration on 1.5 I ran into this error.

TypeScript
41 / 294
2 / 43
2 / 43
2 / 43
3 / 43
Failed to delete index: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `1_2_hashTags`; check that it exists
3 / 43
3 / 43
3 / 43
3 / 43
9 / 43
9 / 43
9 / 43
9 / 43
9 / 43
Failed to delete index: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `1_4_search`; check that it exists
Failed to delete index: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `1_4_tags`; check that it exists
Failed to update project ("6592e8470b7f3a7f836a") version with error: SQLSTATE[HY000]: General error: 1283 Column 'name' cannot be part of FULLTEXT index
SQLSTATE[HY000]: General error: 1283 Column 'name' cannot be part of FULLTEXT index.```

I did find an index that fit this description so I deleted it, but the error persists when I retry the migration.
TL;DR
- Developer encountered an error upgrading to version 1.5 during migration process. - Failed to delete certain indexes due to SQL syntax error or access violation. - Deleting the identified index manually did not resolve the issue. - Solution: Check and modify the code responsible for index deletion, as the error could be related to the database query syntax.
Steven
8 Mar, 2024, 22:20

Btw, it's best to use 3 back ticks with multi-line code. See https://www.markdownguide.org/extended-syntax/#syntax-highlighting

Steven
8 Mar, 2024, 22:21

So it errors and won't continue?

DennisLBC
8 Mar, 2024, 22:23

Yea, even after retrying it just gives me the same error.

Steven
8 Mar, 2024, 22:34

Oh I see...are these projects/indexes important?

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