[Solved] Error upgrading to 1.5

[tropic kraken]

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

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.

[north cosmos]

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

[north cosmos]

So it errors and won't continue?

[tropic kraken]

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

[north cosmos]

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

[tropic kraken]

not particularly, but ill have to rework them if they're gonna be gone. I reverted to a snapshot back to 1.4 and im fine again. But what's the procedure here, delete them before starting the migration initially? before the upgrade? I deleted name index and re-ran the migration command but it failed on the exact same stop. Maybe I needed to do compose or whatever?

[north cosmos]

Are they failed indexes or available?

Do you have something weird in the name attribute of that project?

[tropic kraken]

Not sure what you mean, they're just indexes I use for querying. The name attribute is just a simple string

[north cosmos]

It says it cant find the index so I'm thinking it failed to create.

The project name, not index name

[tropic kraken]

Oh whoops I misread, and the project name is just letters

[north cosmos]

Weird that it says it doesn't like the project name 🧐

[north cosmos]

Did the collation change somehow? https://stackoverflow.com/questions/653076/mysql-error-column-columnname-cannot-be-part-of-fulltext-index#:~:text=3 Answers&text=Oops%2C so I have found,utf8_general_ci on its other columns.

[tropic kraken]

Which part of the error suggests that? Im genuinely trying to learn. The project name is "Locals"

[north cosmos]

The last two lines

[tropic kraken]

Reading it I thought it was about attributes because of the full text comment. But name is generic and simple. In regards to collation I have no idea what that is about. I haven't done anything fancy, was using the 1.4 off the shelf, have like a dozen collections. It upgraded and migrated fine to 1.4.13 but not to 1.5

[north cosmos]

Nvm I was thrown off because of the "failed to update project"

[north cosmos]

It threw here: https://github.com/appwrite/appwrite/blob/e2344e11e11afc9d11e2ed7062e3f9f9b9e57d91/src/Appwrite/Migration/Version/V20.php#L106

[north cosmos]

I think you're going to need to delete that full text index

We don't support full text index on arrays anymore

[tropic kraken]

OK so im looking for an attribute called name with a full text index

This is the only one that fits. After the migration failed the first time, I found and deleted this index and tried to run migration again but it failed. I guess I can delete it prior to the upgrade.

Can you clarify the don't support full text index on arrays anymore? Cause I use full text on a lot of strings for searching for keywords. Name in this case is just a simple string not an array. If this is gonna be a problem im gonna have a ton of attributes that are a problem

[north cosmos]

How'd you delete it?

[north cosmos]

We have a contains query now to look for a certain string in a string array

[north cosmos]

Maybe don't focus on the name attribute. Look for array attributes with a full text index

[north cosmos]

@tropic kraken actually, 1.5.2 should fix this now

[tropic kraken]

Can I go right from 1.4.13 to 1.5.2?

[north cosmos]

Yep!

[midnight jackal]

If your issue has been solved, you can mark this post as closed by adding "[SOLVED]" to the beginning of the title

[tropic kraken]

So I am retrying my upgrade to 1.5.2 this time and have a new/different issue this time. Going from 1.4 to 1.4.13 went fine, the installation went fine from 1.4.13 to 1.5.2, but the migration again fails but with this new error

[north cosmos]

1.5.3 is available now!