500 illegal mix of collations

[SITech]

J!3.9.12
jDownloads 3.2.65
PHP 7.1.24
MySQL 5.6.41-84.1
Hosted
Cache and compress deactivated

I'm a new user trying to set up jDownloads for the first time. When selecting various control panel options, eg Downloads, I get the following error: 500 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
/home3/sintl8/public_html/sitename/libraries/legacy/error/error.php:200

Following advice in previous posts I used phpMyAdmin and found and updated 5 tables using utf8_general_ci to the utfmb4_general_ci used by all other tables. The error remains.

An error has occurred.
500 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
/home3/sintl8/public_html/sowers-intl.org/libraries/legacy/error/error.php:200
Call stack
#
Function
Location
1
()
JROOT/libraries/legacy/error/error.php:200
2
JError::raise()
JROOT/libraries/legacy/error/error.php:277
3
JError::raiseError()
JROOT/administrator/components/com_jdownloads/views/downloads/view.html.php:61
4
jdownloadsViewdownloads->display()
JROOT/libraries/src/MVC/Controller/BaseController.php:672
5
Joomla\CMS\MVC\Controller\BaseController->display()
JROOT/administrator/components/com_jdownloads/controller.php:44
6
jdownloadsController->display()
JROOT/libraries/src/MVC/Controller/BaseController.php:710
7
Joomla\CMS\MVC\Controller\BaseController->execute()
JROOT/administrator/components/com_jdownloads/jdownloads.php:39
8
require_once()
JROOT/libraries/src/Component/ComponentHelper.php:402
9
Joomla\CMS\Component\ComponentHelper::executeComponent()
JROOT/libraries/src/Component/ComponentHelper.php:377
10
Joomla\CMS\Component\ComponentHelper::renderComponent()
JROOT/libraries/src/Application/AdministratorApplication.php:101
11
Joomla\CMS\Application\AdministratorApplication->dispatch()
JROOT/libraries/src/Application/AdministratorApplication.php:159
12
Joomla\CMS\Application\AdministratorApplication->doExecute()
JROOT/libraries/src/Application/CMSApplication.php:196
13
Joomla\CMS\Application\CMSApplication->execute()
JROOT/administrator/index.php:51

The result is the same with Use utf-8 on or off.

What else should be checked?

[Arno]

Hi.
Sorry but I have never see before an error like this with jdownloads. 
Have you already tried to find a solution via Google?

[SITech]

Solved today by the instructions on this link:
https://www.idlwebinc.com/blog/joomla-tips/joomla-500-error-illegal-mix-of-collations

[Arno]

Thanks for the info.