jDownloadsownloads.com


Author Topic: 500 illegal mix of collations  (Read 319 times)

0 Members and 1 Guest are viewing this topic.

Offline SITech

  • Newbie
  • *
  • Posts: 2
500 illegal mix of collations
« on: 31.10.2019 05:13:01 »
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.
Quote
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?

Offline Arno

  • Administrator
  • ***
  • Posts: 12.565
    • jDownloads.com
Re: 500 illegal mix of collations
« Reply #1 on: 31.10.2019 12:58:20 »
Hi.
Sorry but I have never see before an error like this with jdownloads. 
Have you already tried to find a solution via Google?
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline SITech

  • Newbie
  • *
  • Posts: 2
Re: 500 illegal mix of collations
« Reply #2 on: 01.11.2019 02:00:39 »

Offline Arno

  • Administrator
  • ***
  • Posts: 12.565
    • jDownloads.com
Re: 500 illegal mix of collations
« Reply #3 on: 01.11.2019 10:31:09 »
Thanks for the info.  ;)
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!