DennisLBCOriginal post
Rank 2: Process
Successfully went from 1.4 to 1.4.13 but then during the migration on 1.5 I ran into this error.
Plain text
41 / 2942 / 432 / 432 / 433 / 43Failed to delete index: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `1_2_hashTags`; check that it exists3 / 433 / 433 / 433 / 439 / 439 / 439 / 439 / 439 / 43Failed to delete index: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `1_4_search`; check that it existsFailed to delete index: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `1_4_tags`; check that it existsFailed to update project ("6592e8470b7f3a7f836a") version with error: SQLSTATE[HY000]: General error: 1283 Column 'name' cannot be part of FULLTEXT indexSQLSTATE[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.Summary
- 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.