[Skip to main content](#vessel-content) # Can't add coupon after upgrade. ## - **[moe3615](/forum/user/1065-moe3615 "View moe3615's Profile")** - [![moe3615's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1065-moe3615 "View moe3615's Profile") Topic Author - [ Offline](/forum/user/1065-moe3615) Less More - Posts: 11 - Thank you received: 0 - - 15 years 5 months ago [\#16236](#16236) by [moe3615](/forum/user/1065-moe3615 "View moe3615's Profile") *[Can't add coupon after upgrade.](/forum/3-bug-report/16236-cant-add-coupon-after-upgrade#16236 "When I try to save a coupon or discount after upgrading from Free to Essentials I am getting an error: "Error Saving" I am fairly new to this and this site I built for a temporary sale/auction thats coming up soon. I really need this working soon-now. Thanks")* was created by *[moe3615](/forum/user/1065-moe3615 "View moe3615's Profile")* When I try to save a coupon or discount after upgrading from Free to Essentials I am getting an error: "Error Saving" I am fairly new to this and this site I built for a temporary sale/auction thats coming up soon. I really need this working soon-now. Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNjIzNi1jYW50LWFkZC1jb3Vwb24tYWZ0ZXItdXBncmFkZT90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 15 years 5 months ago [\#16237](#16237) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Can't add coupon after upgrade.](/forum/3-bug-report/16236-cant-add-coupon-after-upgrade#16237 "When I try to save a coupon or discount after upgrading from Free to Essentials I am getting an error: "Error Saving" I am fairly new to this and this site I built for a temporary sale/auction thats coming up soon. I really need this working soon-now. Thanks")* Could you activate the debug mode of joomla and try again ? That will display the real error message which will enable us to help you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNjIzNi1jYW50LWFkZC1jb3Vwb24tYWZ0ZXItdXBncmFkZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[moe3615](/forum/user/1065-moe3615 "View moe3615's Profile")** - [![moe3615's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1065-moe3615 "View moe3615's Profile") Topic Author - [ Offline](/forum/user/1065-moe3615) Less More - Posts: 11 - Thank you received: 0 - - 15 years 5 months ago [\#16238](#16238) by [moe3615](/forum/user/1065-moe3615 "View moe3615's Profile") Replied by *[moe3615](/forum/user/1065-moe3615 "View moe3615's Profile")* on topic *[Re: Can't add coupon after upgrade.](/forum/3-bug-report/16236-cant-add-coupon-after-upgrade#16238 "When I try to save a coupon or discount after upgrading from Free to Essentials I am getting an error: "Error Saving" I am fairly new to this and this site I built for a temporary sale/auction thats coming up soon. I really need this working soon-now. Thanks")* Here is the error I am getting once I enabled debug mode: 500 - An error has occurred. JDatabaseMySQL::query: 1054 - Unknown column 'discount_quota_per_user' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_discount` ( `discount_id`,`discount_code`,`discount_type`,`discount_flat_amount`,`discount_currency_id`,`discount_percent_amount`,`discount_tax_id`,`discount_used_times`,`discount_published`,`discount_start`,`discount_end`,`discount_minimum_order`,`discount_minimum_products`,`discount_quota`,`discount_quota_per_user`,`discount_product_id`,`discount_category_id`,`discount_category_childs`,`discount_zone_id`,`discount_auto_load` ) VALUES ( '0','testcode','discount','10','2','','','','1','','','','0','','','','','0','','0' ) all stack \# Function Location 1 JAdministrator->dispatch() /home/toraschaimauction/TORASCHAIMAUCTION.COM/administrator/index.php:67 2 JComponentHelper->renderComponent() /home/toraschaimauction/TORASCHAIMAUCTION.COM/administrator/includes/application.php:136 3 require_once() /home/toraschaimauction/TORASCHAIMAUCTION.COM/libraries/joomla/application/component/helper.php:162 4 JController->execute() /home/toraschaimauction/TORASCHAIMAUCTION.COM/administrator/components/com_hikashop/admin.hikashop.php:47 5 hikashopController->save() /home/toraschaimauction/TORASCHAIMAUCTION.COM/libraries/joomla/application/component/controller.php:236 6 hikashopController->store() /home/toraschaimauction/TORASCHAIMAUCTION.COM/administrator/components/com_hikashop/helpers/helper.php:680 7 hikashopDiscountClass->saveForm() /home/toraschaimauction/TORASCHAIMAUCTION.COM/administrator/components/com_hikashop/helpers/helper.php:731 8 hikashopDiscountClass->save() /home/toraschaimauction/TORASCHAIMAUCTION.COM/administrator/components/com_hikashop/classes/discount.php:31 9 hikashopClass->save() /home/toraschaimauction/TORASCHAIMAUCTION.COM/administrator/components/com_hikashop/classes/discount.php:40 10 JDatabaseMySQL->query() /home/toraschaimauction/TORASCHAIMAUCTION.COM/administrator/components/com_hikashop/helpers/helper.php:836 11 JError->raiseError() /home/toraschaimauction/TORASCHAIMAUCTION.COM/libraries/joomla/database/database/mysql.php:231 12 JError->raise() /home/toraschaimauction/TORASCHAIMAUCTION.COM/libraries/joomla/error/error.php:171 13 JException->__construct() /home/toraschaimauction/TORASCHAIMAUCTION.COM/libraries/joomla/error/error.php:136 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNjIzNi1jYW50LWFkZC1jb3Vwb24tYWZ0ZXItdXBncmFkZT90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 15 years 5 months ago [\#16239](#16239) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Can't add coupon after upgrade.](/forum/3-bug-report/16236-cant-add-coupon-after-upgrade#16239 "When I try to save a coupon or discount after upgrading from Free to Essentials I am getting an error: "Error Saving" I am fairly new to this and this site I built for a temporary sale/auction thats coming up soon. I really need this working soon-now. Thanks")* Please go in your phpmyadmin and run the query below on your database: ALTER TABLE `jos_hikashop_discount` ADD `discount_quota_per_user` INT UNSIGNED DEFAULT 0 That will solve the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNjIzNi1jYW50LWFkZC1jb3Vwb24tYWZ0ZXItdXBncmFkZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[moe3615](/forum/user/1065-moe3615 "View moe3615's Profile")** - [![moe3615's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1065-moe3615 "View moe3615's Profile") Topic Author - [ Offline](/forum/user/1065-moe3615) Less More - Posts: 11 - Thank you received: 0 - - 15 years 5 months ago [\#16241](#16241) by [moe3615](/forum/user/1065-moe3615 "View moe3615's Profile") Replied by *[moe3615](/forum/user/1065-moe3615 "View moe3615's Profile")* on topic *[Re: Can't add coupon after upgrade.](/forum/3-bug-report/16236-cant-add-coupon-after-upgrade#16241 "When I try to save a coupon or discount after upgrading from Free to Essentials I am getting an error: "Error Saving" I am fairly new to this and this site I built for a temporary sale/auction thats coming up soon. I really need this working soon-now. Thanks")* Great, that fixed it. I didn't realize there aren't access restrictions in the essentials version. Is there a way for me to upgrade from essentials to business? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNjIzNi1jYW50LWFkZC1jb3Vwb24tYWZ0ZXItdXBncmFkZT90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 15 years 5 months ago [\#16242](#16242) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Can't add coupon after upgrade.](/forum/3-bug-report/16236-cant-add-coupon-after-upgrade#16242 "When I try to save a coupon or discount after upgrading from Free to Essentials I am getting an error: "Error Saving" I am fairly new to this and this site I built for a temporary sale/auction thats coming up soon. I really need this working soon-now. Thanks")* Yes, you can buy that upgrade package: [ www.hikashop.com/en/component/hikashop/product/show/cid-3.html](http://www.hikashop.com/en/component/hikashop/product/show/cid-3.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNjIzNi1jYW50LWFkZC1jb3Vwb24tYWZ0ZXItdXBncmFkZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[moe3615](/forum/user/1065-moe3615 "View moe3615's Profile")** - [![moe3615's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1065-moe3615 "View moe3615's Profile") Topic Author - [ Offline](/forum/user/1065-moe3615) Less More - Posts: 11 - Thank you received: 0 - - 15 years 5 months ago [\#16243](#16243) by [moe3615](/forum/user/1065-moe3615 "View moe3615's Profile") Replied by *[moe3615](/forum/user/1065-moe3615 "View moe3615's Profile")* on topic *[Re: Can't add coupon after upgrade.](/forum/3-bug-report/16236-cant-add-coupon-after-upgrade#16243 "When I try to save a coupon or discount after upgrading from Free to Essentials I am getting an error: "Error Saving" I am fairly new to this and this site I built for a temporary sale/auction thats coming up soon. I really need this working soon-now. Thanks")* Thanks! this has been speedily solved! Thanks again. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNjIzNi1jYW50LWFkZC1jb3Vwb24tYWZ0ZXItdXBncmFkZT90bXBsPW1hcmtkb3du) 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.139 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)