Support

Admin Tools

#37199 An unhandled Exception has been detected Illegal mix of collations

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
4.1.4
PHP version
8.1.5
Admin Tools version
7.1.7

Latest post by nicholas on Monday, 30 May 2022 02:08 CDT

ssnobben
Hi I got this error and wonder if there is any guidance to what I can do to fix it?


Thks!

Admin Tools for Joomla! - An unhandled Exception has been detected 500 HY000, 1267, Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' HY000, 1267, Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

File <root>/administrator/components/com_admintools/src/View/Wafexceptions/HtmlView.php Line 94

The content below this point is for developers and power users.

Joomla 4.1.4 – PHP 8.1.5 on Linux

Debug information

Exception type: Joomla\CMS\MVC\View\GenericDataException

#0 /var/www/html/test2/libraries/src/MVC/Controller/BaseController.php(697): Akeeba\Component\AdminTools\Administrator\View\Wafexceptions\HtmlView->display()
#1 /var/www/html/test2/administrator/components/com_admintools/src/Controller/Mixin/ControllerEvents.php(74): Joomla\CMS\MVC\Controller\BaseController->display()
#2 /var/www/html/test2/libraries/src/Dispatcher/ComponentDispatcher.php(146): Akeeba\Component\AdminTools\Administrator\Controller\WafexceptionsController->execute()
#3 /var/www/html/test2/administrator/components/com_admintools/src/Dispatcher/Dispatcher.php(61): Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()
#4 /var/www/html/test2/libraries/src/Component/ComponentHelper.php(389): Akeeba\Component\AdminTools\Administrator\Dispatcher\Dispatcher->dispatch()
#5 /var/www/html/test2/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent()
#6 /var/www/html/test2/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch()
#7 /var/www/html/test2/libraries/src/Application/CMSApplication.php(278): Joomla\CMS\Application\AdministratorApplication->doExecute()
#8 /var/www/html/test2/administrator/includes/app.php(63): Joomla\CMS\Application\CMSApplication->execute()
#9 /var/www/html/test2/administrator/index.php(32): require_once('...')
#10 {main}
System information
Operating System (reported by PHP) Linux
PHP version (as reported by your server) 8.1.5
PHP Built On Linux php81 5.15.35-1-pve #1 SMP PVE 5.15.35-3 (Wed, 11 May 2022 07:57:51 +0200) x86_64
PHP SAPI apache2handler
Server identity Apache/2.4.41 (Ubuntu)
Browser identity Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:100.0) Gecko/20100101 Firefox/100.0
Joomla! version 4.1.4
Database driver name mysql
Database driver type mysql
Database server version 10.3.34-MariaDB-0ubuntu0.20.04.1
Database collation utf8mb4_general_ci
Database connection collation utf8mb4_general_ci
PHP Memory limit 8192M
Peak Memory usage 4.52M
PHP Timeout (seconds) 60

nicholas
Akeeba Staff
Manager

Not a bug.

All your database tables should have the utf8mb4_unicode_ci collation. Some of your tables don't, in this particular case the #__extensions table. Please fix that. Joomla will not work correctly with an invalid mix of collations.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!