-- url of the page with the problem -- :
lenfantaubateaudepapier.fr/administrator...ale&filter_partner=0
-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.5.0
-- PHP version -- : PHP 5.6.17
-- Error-message(debug-mod must be tuned on) -- : Une erreur s'est produite
1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM #__hikashop_order AS b LEFT JOIN #__hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN #__hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN #__users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20
Bonjour
je suis sur Joomla 3.5 avec Hikashop 2.6.1
Je n'arrive plus à accéder à la page commande du composant, je reçois un massage d'erreur :
Une erreur s'est produite
1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM #__hikashop_order AS b LEFT JOIN #__hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN #__hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN #__users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20
Je ne peux plus avoir accès à la page commande du composant .
Pouvez-vous m'aider svp ?
Merci