Problem upgrading to 6.0.10

[rob209]

Hello,

I'm upgrading from v5.9.4 to v6.0.10

php command.php upgrade

I get the info that I need to convert tables

php convert-myisam-to-innodb.php

This works for all tables except account, email, email_address, next_number, opportunity, unique_id

Error
InnoDbConverter: FAILED convering "account" table to InnoDB, details: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.

Please help me what to do here, thanks!

[tarasm]

It seems like you have an old version of MySQL / MariaDB which is not supported by EspoCRM. EspoCRM supports the following versions:
- MySQL 5.7 (and later)
- MariaDB 10.1 (and later)

[rob209]

Thanks for commenting, but the system is on MariaDB 10.1

I fixed it by running this command on all the tables above

ALTER TABLE tablename ROW_FORMAT=DYNAMIC;

Please add this to your convert script.

During upgrade from v6.0.10 to v6.1.5 this command was also needed for tables "webhook" and "layout_record"
It would be good if upgrade tool checks required ROW_FORMAT before upgrading.

Thanks & have a nice day!