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

#   Discounts in Essential

##

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

Less More

- Posts: 35
- Thank you received: 0
-
-

15 years 4 months ago [\#19618](#19618) by [uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")  *[Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19618 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")* was created by *[uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")*

I'm working on trying to make a coupon code for 100% off the price of the shopping cart.

When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.

let me know what I'm missin'

twisty.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 4 months ago [\#19623](#19623) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19623 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")*

Please go in the joomla configuration page and activate the "debug mode" option. Then, try again. You should see another error message with more information. Please copy/paste it here so that we can give additional instructions to solve the problem.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

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

Less More

- Posts: 35
- Thank you received: 0
-
-

15 years 4 months ago [\#19627](#19627) by [uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")  Replied by *[uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")* on topic *[Re: Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19627 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")*

500 - An error has occurred.

JDatabaseMySQL::query: 1054 - Unknown column 'discount_quota_per_user' in 'field list' SQL=INSERT IGNORE INTO &#96;jml_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','fsgs','discount','','2','100','','','1','1308811380','1308897780','','0','','','4','','0','','0' )

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 4 months ago [\#19629](#19629) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19629 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")*

You can do like explained on that thread to solve the problem : [ www.hikashop.com/support/forum/3-bug-rep...e.html?lang=en#16239](http://www.hikashop.com/support/forum/3-bug-report/16236-cant-add-coupon-after-upgrade.html?lang=en#16239)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

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

Less More

- Posts: 35
- Thank you received: 0
-
-

15 years 4 months ago -  15 years 4 months ago [\#19636](#19636) by [uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")  Replied by *[uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")* on topic *[Re: Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19636 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")*

I'm not super familiar with PhpMyAdmin, is it a matter of copying and pasting something once I'm in there?

sorry for being that guy.

Twisty.

Last edit: 15 years 4 months ago by [uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 4 months ago [\#19638](#19638) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19638 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")*

Yes. You just need to open phpmyadmin, select the database of your website, click on the SQL tab at the top, paste the query of that thread in there and click on run.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

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

Less More

- Posts: 35
- Thank you received: 0
-
-

15 years 4 months ago [\#19644](#19644) by [uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")  Replied by *[uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")* on topic *[Re: Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19644 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")*

I get this error message. Should I change jos to jml? I wouldn't ask questions if I wasn't afraid of messing this up.. haha

thanks in advance.  [ ![&#91;img](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_shot_2011_06_23_at_8.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/Screen_shot_2011_06_23_at_8.png "&#91;img")

- [ ![Screen&#95;shot&#95;2011&#95;06&#95;23&#95;at&#95;8.png](/forum/attachment/1335) ](/forum/attachment/1335 "...06&#95;23&#95;at&#95;8.png") [ ](/forum/attachment/1335?download=1 "...06&#95;23&#95;at&#95;8.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 4 months ago [\#19647](#19647) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19647 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")*

Indeed, you need to use jml instead of jos.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

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

Less More

- Posts: 35
- Thank you received: 0
-
-

15 years 4 months ago [\#19649](#19649) by [uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")  Replied by *[uncletwisty](/forum/user/2510-uncletwisty "View uncletwisty's Profile")* on topic *[Re: Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19649 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")*

Thanks a million, works like a dream.

By the way, I'd like to comment on the fact that this is by far the best plug-in I've ever used, not because of it's versatility, which is great, but you guys do a top-notch job on the tech support, I'm sure I speak for many when I say thanks and keep it up!

Twisty.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 4 months ago [\#19650](#19650) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Discounts in Essential](/forum/4-how-to/19618-discounts-in-essential#19650 "I'm working on trying to make a coupon code for 100% off the price of the shopping cart.  When I try to make a discount, even when I fill everything out, it says error saving.. I searched the forums but didn't find a solution.  let me know what I'm missin'  twisty.")*

Thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE5NjE4LWRpc2NvdW50cy1pbi1lc3NlbnRpYWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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.064 seconds

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