[4.1.2] SQL query error trying to convert vw_301 to utf8mb4 via XF cmd.php (command line): Specified key was too long
Not an VW install/upgrade issue per say, but it happens when attempting to convert pre-XF2.0 utf8 tables to utf8mb4 using the XenForo provided conversion script. An admin may intend on executing this as part of an XF2.x upgrade in order to enable emoji support. The line:
Code:
php cmd.php xf:convert-utf8mb4
Ref:
https://xenforo.com/docs/xf2/unicode...version-script
The error returned:
Code:
xf_vw_301: MySQL query error [1071]: Specified key was too long; max key length is 1000 bytes
Background: Even though my public facing site has been running off XF2.1 for sometime, the table conversion step was not performed during the last upgrade. I'm in the process of doing a test upgrade to 2.2 using a test copy of the public site.