Cannot install SpeedyTranslate_Full_Package_v1.10.0 on MySQL 8 - key too long

This is the error I get:

JInstaller: :Install: Error SQL Specified key was too long; max key length is 1000 bytes
Extension Update: SQL error processing query: DB function failed with error number 1071
Specified key was too long; max key length is 1000 bytes
SQL =
CREATE TABLE `#__translations` (
`language_id` int(11) NOT NULL,
`reference_values` varchar(100) NOT NULL,
`reference_table` varchar(100) NOT NULL,
`reference_field` varchar(100) NOT NULL,
`original_value` mediumtext NOT NULL,
`value` mediumtext NOT NULL,
`published` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`language_id`, `reference_values`, `reference_table`, `reference_field`)
) ENGINE=MyISAM;
Package Install: There was an error installing an extension: com_speedytranslate.zip

Known issue on MySQL 8?

Seems like the problematic SQL is in file backend/com_speedytranslate/sql/updates/mysql/0.7.0.sql

Why would this file be executed in a fresh install?

Hi,

Please raise a new support ticket and provide us your website info + phpMyAdmin account, we will check it further for you.

Regards,

I'd love to. _Where_ would I open a support ticket?

Ah, it's in the menu if I bought the package? Will ask my boss about credentials.

Seems like the installation problem was due to a unfinished installation before. Cleared all files and now got this error instead:

JHtmlBootstrap::tab not found.

Fixed by commenting out a line here:

plugins/system/speedytranslate/speedytranslate.php

HTMLHelper::_('bootstrap.tab');