Back
Error upgrading to 1.5
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.
Btw, it's best to use 3 back ticks with multi-line code. See https://www.markdownguide.org/extended-syntax/#syntax-highlighting
So it errors and won't continue?
Yea, even after retrying it just gives me the same error.
Oh I see...are these projects/indexes important?
