Support

Admin Tools

#37706 Waf denylists Admin Tools for Joomla! - An unhandled Exception has been detected

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.2.2
PHP version
8.0.22
Admin Tools version
7.1.10

Latest post by nicholas on Monday, 12 September 2022 00:45 CDT

Wednesday, 07 September 2022 11:39 CDT

komir

HI when try to enter Waf denylists get a message 

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

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

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

Joomla 4.2.2 – PHP 8.0.22 on Linux

Debug information

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

#0 /home/konveks/public_html/libraries/src/MVC/Controller/BaseController.php(639): Akeeba\Component\AdminTools\Administrator\View\Wafdenylists\HtmlView->display()
#1 /home/konveks/public_html/administrator/components/com_admintools/src/Controller/Mixin/ControllerEvents.php(74): Joomla\CMS\MVC\Controller\BaseController->display()
#2 /home/konveks/public_html/libraries/src/Dispatcher/ComponentDispatcher.php(143): Akeeba\Component\AdminTools\Administrator\Controller\WafdenylistsController->execute()
#3 /home/konveks/public_html/administrator/components/com_admintools/src/Dispatcher/Dispatcher.php(61): Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()
#4 /home/konveks/public_html/libraries/src/Component/ComponentHelper.php(355): Akeeba\Component\AdminTools\Administrator\Dispatcher\Dispatcher->dispatch()
#5 /home/konveks/public_html/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent()
#6 /home/konveks/public_html/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch()
#7 /home/konveks/public_html/libraries/src/Application/CMSApplication.php(294): Joomla\CMS\Application\AdministratorApplication->doExecute()
#8 /home/konveks/public_html/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#9 /home/konveks/public_html/administrator/index.php(32): require_once('/home/konveks/p...')
#10 {main}
System information
Operating System (reported by PHP) Linux
PHP version (as reported by your server) 8.0.22
PHP Built On Linux cp029.mydataknox.com 3.10.0-962.3.2.lve1.5.63.el7.x86_64 #1 SMP Fri Oct 8 12:03:35 UTC 2021 x86_64
PHP SAPI litespeed
Server identity LiteSpeed
Browser identity Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36
Joomla! version 4.2.2
Database driver name mysqli
Database driver type mysql
Database server version 8.0.30
Database collation utf8mb4_0900_ai_ci
Database connection collation utf8mb4_0900_ai_ci
PHP Memory limit 512M
Peak Memory usage 25.56M
PHP Timeout (seconds) 90

4M CAD profesionalni CAD alat

Thursday, 08 September 2022 02:12 CDT

nicholas

Your database collation is utf8mb4_0900_ai_ci but Joomla only supports utf8mb4_unicode_ci. Please change your database collation.

If this is not enough please note that some database tables or some columns of your database tables may also be in the wrong collation. The easiest fix for that would be to take a backup with Akeeba Backup and restore it. In the Database Restoration page select Force UTF-8 collation on Database, Force UTF-8 collation on Tables and Allow UTF8MB4 auto-detection. This will fix the collation on the tables and their columns.

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!

Thursday, 08 September 2022 16:08 CDT

komir

Thank you.

I follow your instruction and after restoring still have the same problem

 

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

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

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

Joomla 4.2.2 – PHP 8.0.23 on Linux

Debug information

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

#0 /home/konveks/public_html/libraries/src/MVC/Controller/BaseController.php(639): Akeeba\Component\AdminTools\Administrator\View\Wafdenylists\HtmlView->display()
#1 /home/konveks/public_html/administrator/components/com_admintools/src/Controller/Mixin/ControllerEvents.php(74): Joomla\CMS\MVC\Controller\BaseController->display()
#2 /home/konveks/public_html/libraries/src/Dispatcher/ComponentDispatcher.php(143): Akeeba\Component\AdminTools\Administrator\Controller\WafdenylistsController->execute()
#3 /home/konveks/public_html/administrator/components/com_admintools/src/Dispatcher/Dispatcher.php(61): Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()
#4 /home/konveks/public_html/libraries/src/Component/ComponentHelper.php(355): Akeeba\Component\AdminTools\Administrator\Dispatcher\Dispatcher->dispatch()
#5 /home/konveks/public_html/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent()
#6 /home/konveks/public_html/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch()
#7 /home/konveks/public_html/libraries/src/Application/CMSApplication.php(294): Joomla\CMS\Application\AdministratorApplication->doExecute()
#8 /home/konveks/public_html/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#9 /home/konveks/public_html/administrator/index.php(32): require_once('/home/konveks/p...')
#10 {main}
System information
Operating System (reported by PHP) Linux
PHP version (as reported by your server) 8.0.23
PHP Built On Linux cp029.mydataknox.com 3.10.0-962.3.2.lve1.5.63.el7.x86_64 #1 SMP Fri Oct 8 12:03:35 UTC 2021 x86_64
PHP SAPI litespeed
Server identity LiteSpeed
Browser identity Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36
Joomla! version 4.2.2
Database driver name mysqli
Database driver type mysql
Database server version 8.0.30
Database collation utf8mb4_0900_ai_ci
Database connection collation utf8mb4_0900_ai_ci
PHP Memory limit 512M
Peak Memory usage 25.55M
PHP Timeout (seconds) 90

4M CAD profesionalni CAD alat

Friday, 09 September 2022 02:04 CDT

nicholas

The database collation is still reported as utf8mb4_0900_ai_ci. The first think I told you was

> Your database collation is utf8mb4_0900_ai_ci but Joomla only supports utf8mb4_unicode_ci. Please change your database collation.

Can you please do that? There's no point trying to do anything else unless you have already performed what is the action most likely to fix your issue.

 

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!

Saturday, 10 September 2022 05:07 CDT

komir

Yes I did try with instructions you send me, but, after restore get the same notification

4M CAD profesionalni CAD alat

Monday, 12 September 2022 00:45 CDT

nicholas

My instructions had two steps, you are skipping the first step:

> Your database collation is utf8mb4_0900_ai_ci but Joomla only supports utf8mb4_unicode_ci. Please change your database collation.

This means that you MUST change the database's collation to utf8mb4_unicode_ci (or utf8mb4_general_ci; both will work the same) before doing anything else.

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!