Illegal mix of collations

-- HikaShop version -- : 5.1.5
-- HikaSerial version -- : 5.0.0
-- Joomla version -- : 5.2.4
-- PHP version -- : 8.2.27
-- Browser(s) name and version -- : Brave

Bonjour,
j'utilise HikaSubscription et j'ai cette erreur:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'

j'ai fait une recherche sur un n° de série de mon produit.

Cordialement,
Nicolas

Bonjour,
voici ce que dit le mode debug:
An error has occurred.
1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'
Call Stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:411
2 Joomla\Database\Mysqli\MysqliStatement->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:651
3 Joomla\Database\DatabaseDriver->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1336
4 Joomla\Database\DatabaseDriver->loadResult() JROOT/administrator/components/com_hikaserial/helpers/helper.php:868
5 hikaserialView->getPageInfoTotal() JROOT/administrator/components/com_hikaserial/views/subscription/view.html.php:82
6 subscriptionViewSubscription->listing() JROOT/administrator/components/com_hikaserial/views/subscription/view.html.php:21
7 subscriptionViewSubscription->display() JROOT/libraries/src/MVC/Controller/BaseController.php:697
8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikaserial/helpers/helper.php:696
9 hikaserialController->display() JROOT/administrator/components/com_hikaserial/helpers/helper.php:608
10 hikaserialController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:730
11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikaserial/helpers/helper.php:725
12 hikaserialController->execute() JROOT/administrator/components/com_hikaserial/hikaserial.php:50
13 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
14 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
15 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
16 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:150
17 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:205
18 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:306
19 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:58
20 require_once() JROOT/administrator/index.php:32
Previous Error

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'

Call Stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:407
2 mysqli_stmt->execute() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:407
3 Joomla\Database\Mysqli\MysqliStatement->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:651
4 Joomla\Database\DatabaseDriver->execute() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1336
5 Joomla\Database\DatabaseDriver->loadResult() JROOT/administrator/components/com_hikaserial/helpers/helper.php:868
6 hikaserialView->getPageInfoTotal() JROOT/administrator/components/com_hikaserial/views/subscription/view.html.php:82
7 subscriptionViewSubscription->listing() JROOT/administrator/components/com_hikaserial/views/subscription/view.html.php:21
8 subscriptionViewSubscription->display() JROOT/libraries/src/MVC/Controller/BaseController.php:697
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikaserial/helpers/helper.php:696
10 hikaserialController->display() JROOT/administrator/components/com_hikaserial/helpers/helper.php:608
11 hikaserialController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:730
12 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikaserial/helpers/helper.php:725
13 hikaserialController->execute() JROOT/administrator/components/com_hikaserial/hikaserial.php:50
14 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
15 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
16 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:150
18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:205
19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:306
20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:58
21 require_once() JROOT/administrator/index.php:32

ça ne fait le pb que lorsque j'inscris une numéro de série dans la recherche (genre Y6GG-KNRT, etc...). si j'inscris un email, pas de pb

Nicolas