DB errors when updating to 2.7.1 "Error updating table for class modResource"

Support
1

I just updated a number of sites from MODX version 2.7.0 (and 2.6.5) to version 2.7.1

I encountered the following errors:

upgrading from 2.7.0

Error updating table for class modResource
Array
(
[0] => 42S21
[1] => 1060
[2] => Duplicate column name 'alias_visible'
)

upgrading from 2.6.5 (and on one site from 2.7.0)

Error updating table for class modResource
Array
(
[0] => HY000
[1] => 1283
[2] => Column 'description' cannot be part of FULLTEXT index
)

all the sites seem to work fine notwithstanding the errors on upgrade . . .

2

Duplicate column errors are pretty common. It is possible the description error came if you change charset or collation at some point. Can you inspect the table to see that all the fields on the content table are matching charset and collation?

3

Fixed in 2.7.2