[Skip to main content](#vessel-content) # Erreur base de données ## - **[hikaphil](/forum/user/37417-hikaphil "View hikaphil's Profile")** - [![hikaphil's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/bike_skid.png)](/forum/user/37417-hikaphil "View hikaphil's Profile") Topic Author - [ Offline](/forum/user/37417-hikaphil) Less More - Posts: 384 - Thank you received: 13 - - - 9 years 8 months ago [\#264182](#264182) by [hikaphil](/forum/user/37417-hikaphil "View hikaphil's Profile") *[Erreur base de données](/forum/5-support-en-francais-french-support-/889200-erreur-base-de-donnees#264182 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.65 Bonsoir j'ai une erreur sur la base de donnée ? Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=UPDATE `#__hikashop_user` AS hku JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id` Cordialement.")* was created by *[hikaphil](/forum/user/37417-hikaphil "View hikaphil's Profile")* -- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.65 Bonsoir j'ai une erreur sur la base de donnée ? Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=UPDATE `#__hikashop_user` AS hku JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id` Cordialement. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODg5MjAwLWVycmV1ci1iYXNlLWRlLWRvbm5lZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 9 years 8 months ago [\#264185](#264185) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Erreur base de données](/forum/5-support-en-francais-french-support-/889200-erreur-base-de-donnees#264185 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.65 Bonsoir j'ai une erreur sur la base de donnée ? Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=UPDATE `#__hikashop_user` AS hku JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id` Cordialement.")* bonjour, Pas vraiment. C'est juste que le charset de la colonne email de #__users et différent du charset de la coloone user_email de #__hikashop_user. Normalement cela devrait être le même. Vous pouvez potentiellement changer le charset si vous le souhaitez. [ stackoverflow.com/a/9037658/6390007](http://stackoverflow.com/a/9037658/6390007) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODg5MjAwLWVycmV1ci1iYXNlLWRlLWRvbm5lZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[contact.singier@gmail.com](/forum/user/46217-contact-singier-gmail-com "View contact.singier@gmail.com's Profile")** - [![contact.singier@gmail.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46217-contact-singier-gmail-com "View contact.singier@gmail.com's Profile") - [ Offline](/forum/user/46217-contact-singier-gmail-com) Less More - Posts: 22 - Thank you received: 1 - - 8 years 4 months ago [\#294349](#294349) by [contact.singier@gmail.com](/forum/user/46217-contact-singier-gmail-com "View contact.singier@gmail.com's Profile") Replied by *[contact.singier@gmail.com](/forum/user/46217-contact-singier-gmail-com "View contact.singier@gmail.com's Profile")* on topic *[Erreur base de données](/forum/5-support-en-francais-french-support-/889200-erreur-base-de-donnees#294349 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.65 Bonsoir j'ai une erreur sur la base de donnée ? Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=UPDATE `#__hikashop_user` AS hku JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id` Cordialement.")* Bonjour, Une question concernant la base de donnée, comment ajouter des caractéristiques avec des valeurs? j'ai fais un essai en faisant un export de ma base, en ajoutant une colonne de caractéristique celle ci ne s'ajoute pas. Un autre essai à été d'ajouter des valeurs à des caractéristique existante mais cela ne fonctionne pas également. Quel est la marche à suivre ? Cordialement. Nicolas Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODg5MjAwLWVycmV1ci1iYXNlLWRlLWRvbm5lZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 8 years 4 months ago [\#294351](#294351) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Erreur base de données](/forum/5-support-en-francais-french-support-/889200-erreur-base-de-donnees#294351 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.65 Bonsoir j'ai une erreur sur la base de donnée ? Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=UPDATE `#__hikashop_user` AS hku JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id` Cordialement.")* Bonjour, Pourtant c'est bien la solution. Il suffit d'exporter la table hikashop_characteristic en CSV via votre phpmyadmin. Vous pouvez rajouter des valeurs et des charactéristiques au CSV et l'importer ensuite toujours via votre phpmyadmin et vous aurez vos nouvelles caractéristiques / valeurs. PS: merci de créer un nouveau sujet lorsque votre question n'est pas directement lié au sujet. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODg5MjAwLWVycmV1ci1iYXNlLWRlLWRvbm5lZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[contact.singier@gmail.com](/forum/user/46217-contact-singier-gmail-com "View contact.singier@gmail.com's Profile")** - [![contact.singier@gmail.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46217-contact-singier-gmail-com "View contact.singier@gmail.com's Profile") - [ Offline](/forum/user/46217-contact-singier-gmail-com) Less More - Posts: 22 - Thank you received: 1 - - 8 years 4 months ago [\#294420](#294420) by [contact.singier@gmail.com](/forum/user/46217-contact-singier-gmail-com "View contact.singier@gmail.com's Profile") Replied by *[contact.singier@gmail.com](/forum/user/46217-contact-singier-gmail-com "View contact.singier@gmail.com's Profile")* on topic *[Erreur base de données](/forum/5-support-en-francais-french-support-/889200-erreur-base-de-donnees#294420 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.65 Bonsoir j'ai une erreur sur la base de donnée ? Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=UPDATE `#__hikashop_user` AS hku JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id` Cordialement.")* Bonjour, Merci pour votre réponse, je n'avais pas penser à passer par le phpmyadmin. J'ai donc fait un export en csv (probleme affichage des police), et quand j'importe via le phpmyadmin il m'affiche : Nombre de colonnes invalides dans les données CSV à la ligne 1. qu'elle serait le problème à votre avis ? PS :Voulez vous que j'ouvre un nouveaux sujet ? Nicolas [ ![Capturedecran2018-06-25a12.50.10.png](/forum/attachment/44004) ](/forum/attachment/44004 "...5a12.50.10.png") - [ ![Capturedecran2018-06-25a12.50.10.png](/forum/attachment/44004) ](/forum/attachment/44004 "...5a12.50.10.png") [ ](/forum/attachment/44004?download=1 "...5a12.50.10.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODg5MjAwLWVycmV1ci1iYXNlLWRlLWRvbm5lZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 8 years 4 months ago [\#294421](#294421) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Erreur base de données](/forum/5-support-en-francais-french-support-/889200-erreur-base-de-donnees#294421 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.65 Bonsoir j'ai une erreur sur la base de donnée ? Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=UPDATE `#__hikashop_user` AS hku JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id` Cordialement.")* Bonjour, Ouvrez le CSV avec notepad++ et regardez ce que vous avez sur la première ligne. VOus devez avoir le nom des colonnes séparés par des virgules ou des point-virgules. PS: non, c'était pour la prochaine fois. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODg5MjAwLWVycmV1ci1iYXNlLWRlLWRvbm5lZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.061 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)