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

More
2 years 1 week ago #18940 by ollehar
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?
The topic has been locked.
More
2 years 6 days ago - 2 years 6 days ago #18941 by ollehar
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?
Last edit: 2 years 6 days ago by ollehar.
The topic has been locked.
More
2 years 6 days ago #18942 by solidres
Hi,

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

Regards,
The topic has been locked.
More
2 years 6 days ago #18943 by ollehar
I'd love to. _Where_ would I open a support ticket?
The topic has been locked.
More
2 years 6 days ago #18944 by ollehar
Ah, it's in the menu if I bought the package? Will ask my boss about credentials.
The topic has been locked.
More
2 years 6 days ago #18945 by ollehar
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');
The topic has been locked.
Moderators: solidres
Powered by Kunena Forum

All the things you need to make your work easier. Did you like Solidres?