[Skip to main content](#vessel-content) # Erreur BBD ## - **[sudkarting](/forum/user/23503-sudkarting "View sudkarting's Profile")** - [![sudkarting's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23503.png)](/forum/user/23503-sudkarting "View sudkarting's Profile") Topic Author - [ Away](/forum/user/23503-sudkarting) Less More - Posts: 421 - Thank you received: 18 - - 3 months 2 weeks ago [\#372841](#372841) by [sudkarting](/forum/user/23503-sudkarting "View sudkarting's Profile") *[Erreur BBD](/forum/5-support-en-francais-french-support-/910721-erreur-bbd#372841 "-- url of the page with the problem -- : www.sudkarting.fr -- HikaShop version -- : 6.5.2 -- Joomla version -- : 5.4.7 Bonjour, Si je fais une vérification de la base de données, j'ai une erreur : Error Could not convert the table "hikashop_etickets" to InnoDB Incorrect table definition; there can be only one auto column and it must be defined as a key Info Missing core categories fixed Une idée? Merci")* was created by *[sudkarting](/forum/user/23503-sudkarting "View sudkarting's Profile")* -- url of the page with the problem -- : [ www.sudkarting.fr](http://www.sudkarting.fr) -- HikaShop version -- : 6.5.2 -- Joomla version -- : 5.4.7 Bonjour, Si je fais une vérification de la base de données, j'ai une erreur : **Error Could not convert the table "hikashop\_etickets" to InnoDB Incorrect table definition; there can be only one auto column and it must be defined as a key Info Missing core categories fixed** Une idée? Merci Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vOTEwNzIxLWVycmV1ci1iYmQ/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: 86359 - Thank you received: 14293 - - 3 months 2 weeks ago [\#372842](#372842) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Erreur BBD](/forum/5-support-en-francais-french-support-/910721-erreur-bbd#372842 "-- url of the page with the problem -- : www.sudkarting.fr -- HikaShop version -- : 6.5.2 -- Joomla version -- : 5.4.7 Bonjour, Si je fais une vérification de la base de données, j'ai une erreur : Error Could not convert the table "hikashop_etickets" to InnoDB Incorrect table definition; there can be only one auto column and it must be defined as a key Info Missing core categories fixed Une idée? Merci")* Bonjour, Ce message n'est pas bloquant, votre boutique fonctionne normalement. Lors de la vérification de la base de données, HikaShop essaie de convertir en InnoDB toutes les tables dont le nom commence par hikashop_, et il signale simplement celle qu'il n'a pas réussi à convertir. Avoir une table en MyISAM au milieu de tables InnoDB ne pose aucun problème de fonctionnement. La table hikashop_etickets n'est pas créée par HikaShop (ni par HikaSerial, HikaMarket ou HikaAuction). Elle provient d'une autre extension qui a utilisé le préfixe hikashop_. Sa structure comporte un défaut (une colonne auto_increment qui n'est pas définie comme clé), et c'est MySQL qui refuse la conversion pour cette raison, indépendamment de HikaShop. Pour voir sa structure et retrouver son origine (pensez à remettre le préfixe de tables de votre site devant hikashop_etickets) : Code: SHOW CREATE TABLE `hikashop_etickets`; Si cette table est un reste d'une extension que vous n'utilisez plus, vous pouvez la supprimer. Si vous vous en servez encore, il faut corriger sa structure en ajoutant la clé primaire manquante sur la colonne auto_increment. Dans les deux cas, HikaShop n'est pas affecté. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vOTEwNzIxLWVycmV1ci1iYmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sudkarting](/forum/user/23503-sudkarting "View sudkarting's Profile")** - [![sudkarting's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23503.png)](/forum/user/23503-sudkarting "View sudkarting's Profile") Topic Author - [ Away](/forum/user/23503-sudkarting) Less More - Posts: 421 - Thank you received: 18 - - 3 months 2 weeks ago [\#372848](#372848) by [sudkarting](/forum/user/23503-sudkarting "View sudkarting's Profile") Replied by *[sudkarting](/forum/user/23503-sudkarting "View sudkarting's Profile")* on topic *[Erreur BBD](/forum/5-support-en-francais-french-support-/910721-erreur-bbd#372848 "-- url of the page with the problem -- : www.sudkarting.fr -- HikaShop version -- : 6.5.2 -- Joomla version -- : 5.4.7 Bonjour, Si je fais une vérification de la base de données, j'ai une erreur : Error Could not convert the table "hikashop_etickets" to InnoDB Incorrect table definition; there can be only one auto column and it must be defined as a key Info Missing core categories fixed Une idée? Merci")* Merci Effectivement c'est une ancienne extension fonctionnant avec Hikashop mais non compatible J5. En fait je recherche des explications à mon problème toujours sans réponse : [ www.hikashop.com/forum/18-support-en-fra...ion-de-commande.html](https://www.hikashop.com/forum/18-support-en-francais-de-hikaserial-french-support/910720-pas-d-email-de-confirmation-de-commande.html) Cordialement, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vOTEwNzIxLWVycmV1ci1iYmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4077 - - [](http://obsi.dev) - 3 months 2 weeks ago [\#372853](#372853) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Erreur BBD](/forum/5-support-en-francais-french-support-/910721-erreur-bbd#372853 "-- url of the page with the problem -- : www.sudkarting.fr -- HikaShop version -- : 6.5.2 -- Joomla version -- : 5.4.7 Bonjour, Si je fais une vérification de la base de données, j'ai une erreur : Error Could not convert the table "hikashop_etickets" to InnoDB Incorrect table definition; there can be only one auto column and it must be defined as a key Info Missing core categories fixed Une idée? Merci")* L'autre sujet/ticket a été traité. --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [sudkarting](/forum/user/23503-sudkarting "View sudkarting's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vOTEwNzIxLWVycmV1ci1iYmQ/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.046 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)