DB error 1170 upgrading to 3.20

I just upgraded several websites from 3.0.5 to 3.2.0 without a problem, but the last (biggest) site gave me an error when doing the DB upgrade. The error I get is
"Database error 1170 while doing query BLOB/TEXT column ‘value’ used in key specification without a key length".
Otherwise it says “Success” right below that.

I don’t see any problems when looking, and the “Verify DB Structure” looks OK. Any way to see if there’s anything seriously wrong before I get too far along?

You got good backups etc?

Yes, backups good tho since this is live, they’re degrading in usefulness.

All still seems to be functioning OK.

Ok, well I don’t know anything else, unless @michiel has any concerns about it, I guess just leave it.

would be best to report in mantis

1 Like

Done. as Mantis issue 0017869

1 Like