[Skip to main content](#vessel-content)

#   Bug ajout de réductions

##

- **[Jiwoks](/forum/user/2023-jiwoks "View Jiwoks's Profile")**
- [![Jiwoks's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2023-jiwoks "View Jiwoks's Profile") Topic Author
- [ Offline](/forum/user/2023-jiwoks)

Less More

- Posts: 18
- Thank you received: 0
-
-

15 years 2 months ago -  15 years 2 months ago [\#24615](#24615) by [Jiwoks](/forum/user/2023-jiwoks "View Jiwoks's Profile")  *[Bug ajout de réductions](/forum/3-bug-report/24615-bug-ajout-de-reductions#24615 "Bonjour petit problème lors de la création d'un coupon sur Joomla 1.7 et Hikashop Essential v 1.5.3.  En mode non débug: Erreur lors de la sauvegarde  En mode débug: JDatabaseMySQL::query: 1054 - Unknown column 'discount&#95;minimum&#95;products' in 'field list' SQL=INSERT IGNORE INTO &#96;jos&#95;hikashop&#95;discount&#96; ( &#96;discount&#95;id&#96;,&#96;discount&#95;code&#96;,&#96;discount&#95;type&#96;,&#96;discount&#95;flat&#95;amount&#96;,&#96;discount&#95;currency&#95;id&#96;,&#96;discount&#95;percent&#95;amount&#96;,&#96;discount&#95;tax&#95;id&#96;,&#96;discount&#95;used&#95;times&#96;,&#96;discount&#95;published&#96;,&#96;discount&#95;start&#96;,&#96;discount&#95;end&#96;,&#96;discount&#95;minimum&#95;order&#96;,&#96;discount&#95;minimum&#95;products&#96;,&#96;discount&#95;quota&#96;,&#96;discount&#95;quota&#95;per&#95;user&#96;,&#96;discount&#95;product&#95;id&#96;,&#96;discount&#95;category&#95;id&#96;,&#96;discount&#95;category&#95;childs&#96;,&#96;discount&#95;zone&#95;id&#96;,&#96;discount&#95;auto&#95;load&#96; ) VALUES ( '0','COUP','discount','10','1','','','','1','','','','0','','','','','0','','0' )  J'ai créé dans la table #&#95;&#95;hikashop&#95;discount les champs: int(11) discount&#95;quota&#95;per&#95;user et int(11) discount&#95;minimum&#95;products et ça fonctionne.  Jiwoks")* was created by *[Jiwoks](/forum/user/2023-jiwoks "View Jiwoks's Profile")*

Bonjour petit problème lors de la création d'un coupon sur Joomla 1.7 et Hikashop Essential v 1.5.3.

En mode non débug:
*Erreur lors de la sauvegarde*

En mode débug:
*JDatabaseMySQL::query: 1054 - Unknown column 'discount\_minimum\_products' in 'field list' SQL=INSERT IGNORE INTO &#96;jos\_hikashop\_discount&#96; ( &#96;discount\_id&#96;,&#96;discount\_code&#96;,&#96;discount\_type&#96;,&#96;discount\_flat\_amount&#96;,&#96;discount\_currency\_id&#96;,&#96;discount\_percent\_amount&#96;,&#96;discount\_tax\_id&#96;,&#96;discount\_used\_times&#96;,&#96;discount\_published&#96;,&#96;discount\_start&#96;,&#96;discount\_end&#96;,&#96;discount\_minimum\_order&#96;,&#96;discount\_minimum\_products&#96;,&#96;discount\_quota&#96;,&#96;discount\_quota\_per\_user&#96;,&#96;discount\_product\_id&#96;,&#96;discount\_category\_id&#96;,&#96;discount\_category\_childs&#96;,&#96;discount\_zone\_id&#96;,&#96;discount\_auto\_load&#96; ) VALUES ( '0','COUP','discount','10','1','','','','1','','','','0','','','','','0','','0' )*

J'ai créé dans la table #__hikashop_discount les champs: int(11) discount_quota_per_user et int(11) discount_minimum_products et ça fonctionne.

Jiwoks

Last edit: 15 years 2 months ago by [Jiwoks](/forum/user/2023-jiwoks "View Jiwoks's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDYxNS1idWctYWpvdXQtZGUtcmVkdWN0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14281
-
-

15 years 2 months ago [\#24618](#24618) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bug ajout de réductions](/forum/3-bug-report/24615-bug-ajout-de-reductions#24618 "Bonjour petit problème lors de la création d'un coupon sur Joomla 1.7 et Hikashop Essential v 1.5.3.  En mode non débug: Erreur lors de la sauvegarde  En mode débug: JDatabaseMySQL::query: 1054 - Unknown column 'discount&#95;minimum&#95;products' in 'field list' SQL=INSERT IGNORE INTO &#96;jos&#95;hikashop&#95;discount&#96; ( &#96;discount&#95;id&#96;,&#96;discount&#95;code&#96;,&#96;discount&#95;type&#96;,&#96;discount&#95;flat&#95;amount&#96;,&#96;discount&#95;currency&#95;id&#96;,&#96;discount&#95;percent&#95;amount&#96;,&#96;discount&#95;tax&#95;id&#96;,&#96;discount&#95;used&#95;times&#96;,&#96;discount&#95;published&#96;,&#96;discount&#95;start&#96;,&#96;discount&#95;end&#96;,&#96;discount&#95;minimum&#95;order&#96;,&#96;discount&#95;minimum&#95;products&#96;,&#96;discount&#95;quota&#96;,&#96;discount&#95;quota&#95;per&#95;user&#96;,&#96;discount&#95;product&#95;id&#96;,&#96;discount&#95;category&#95;id&#96;,&#96;discount&#95;category&#95;childs&#96;,&#96;discount&#95;zone&#95;id&#96;,&#96;discount&#95;auto&#95;load&#96; ) VALUES ( '0','COUP','discount','10','1','','','','1','','','','0','','','','','0','','0' )  J'ai créé dans la table #&#95;&#95;hikashop&#95;discount les champs: int(11) discount&#95;quota&#95;per&#95;user et int(11) discount&#95;minimum&#95;products et ça fonctionne.  Jiwoks")*

C'est un problème qui est apparue sur votre site lors de la mise à jour à cause d'un problème du coté de MySQL à ce moment là.
Cela fonctionne correctement sinon.
La solution que vous proposez est en effet la bonne.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNDYxNS1idWctYWpvdXQtZGUtcmVkdWN0aW9ucz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.070 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
