Error: BLOB/TEXT column 'long_desc' used in key specification without a key length

Running the upgrade script from 502 I received the following error message:

Query Error

ERROR: query failed: ALTER TABLE icd10_dx_order_code MODIFY long_desc text

Error: BLOB/TEXT column ‘long_desc’ used in key specification without a key length

Not sure why this is happening. Any clue?

OK. It looks like I had to drop the index associated with “long_desc”. Since I’m working with a custom database, there is a chance that I had added the index at some time in the past. After dropping the index the import worked fine.

Database upgrade issue with solution