Illegal mix of collations

  • Posts: 33
  • Thank you received: 4
  • Hikaserial Subscription Hikashop Business
1 month 1 week ago #366110

-- 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

Please Log in or Create an account to join the conversation.

  • Posts: 83603
  • Thank you received: 13533
  • MODERATOR
1 month 1 week ago #366111

Bonjour,

Pourriez-vous activer l'option "debug" de la configuration Joomla et essayer à nouveau ? Vous devriez avoir un message d'erreur plus complet qui devrait nous permettre de vous dire quoi faire.

Please Log in or Create an account to join the conversation.

  • Posts: 33
  • Thank you received: 4
  • Hikaserial Subscription Hikashop Business
1 month 1 week ago #366131

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

Last edit: 1 month 1 week ago by Jerome. Reason: [code] tag is nice

Please Log in or Create an account to join the conversation.

  • Posts: 26222
  • Thank you received: 4035
  • MODERATOR
1 month 1 week ago #366157

Bonjour,

Merci pour ces informations de debug.

Avez-vous fait des "fresh install" de Joomla 5, HikaShop et HikaSubscription où s'agit-il d'un site ayant eu différentes mises à jour majeurs ?

Dans le fichier "administrator/component/com_hikaserial/views/subscription/view.html.php" vous aller trouver le code suivant :

		$searchMap = array(
			'subscription.subscription_id',
			'subscription.subscription_data',
			'hk_user.user_email',
			'j_users.username',
			'j_users.name',
		);
Il va définir les différents champs dans lequel est il est possible d'effectuer une recherche.
L'erreur de "collation" indique que dans une de ces trois tables, votre base de donnée utilise l'encodage "latin1_swedish_ci" et non "utf8mb4_general_ci".

Si vous avez un accès à votre base de données avec un "PhpMyAdmin", il sera intéressant d'aller regarder si vos tables (hikaserial_subscription, hikashop_user et joomla_users) sont bien en collation "utf8mb4_general_ci".

Cordialement,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 33
  • Thank you received: 4
  • Hikaserial Subscription Hikashop Business
1 month 1 week ago #366160

bonjour,
merci pour votre retour,
jnew_hikaserial_subscription et certaines autres tables sont effectivement en latin1_swedish_ci.
le site est la suite de mise à jours.... pas de fresh install.

est-ce que dans PhpMyAdmin je peux les changer sans risques?

++
Nicolas

Please Log in or Create an account to join the conversation.

  • Posts: 26222
  • Thank you received: 4035
  • MODERATOR
1 month 6 days ago #366192

Bonjour,

Merci de votre message.
Le script d'installation d'HikaSubscription créant les tables en UTF8, il doit y avoir un manquement de spécification de la collation dans un processus de mise à jour. Je vais investiguer là dessus.

Vous pouvez modifier dans PhpMyAdmin sans risque, surtout sur une migration vers UTF8.

Cordialement,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Moderators: Obsidev
Time to create page: 0.049 seconds
Powered by Kunena Forum