[Skip to main content](#vessel-content) # Problems with Discounts and also with Badges ## - **[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")** - [![drandyb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24834-drandyb "View drandyb's Profile") Topic Author - [ Offline](/forum/user/24834-drandyb) Less More - Posts: 25 - Thank you received: 0 - - 13 years 2 months ago [\#118139](#118139) by [drandyb](/forum/user/24834-drandyb "View drandyb's Profile") *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118139 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* was created by *[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")* -- url of the page with the problem -- : [ mywebsite.com/mypage](http://mywebsite.com/mypage) -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/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: 4078 - - [](http://obsi.dev) - 13 years 2 months ago [\#118313](#118313) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118313 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* Hi, Please re-download and re-install HikaShop 2.2.0 in your website. We have include a patch which will fix your "badge" table with the missing column. After that, I recommend you to change your database drive from "mysql" to "mysqli". We submit some fixes in the mysqli Joomla 3 driver which allow to display error messages. Unfortunately, the patch that I have submitted was not ported to the mysql driver (but mysqli is recommended for Joomla 3, more stable than the mysql one). The discount system does not allow to select several products. You found the right solution by using a category. What you can do is to create "hidden categories". A category which is not publish (so not visible in the front-end) but which contains some products. A product can be in several categories so it does not create any problem. At this moment to add or remove a product from the discount, you just have to add or remove it from the category. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")** - [![drandyb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24834-drandyb "View drandyb's Profile") Topic Author - [ Offline](/forum/user/24834-drandyb) Less More - Posts: 25 - Thank you received: 0 - - 13 years 2 months ago [\#118325](#118325) by [drandyb](/forum/user/24834-drandyb "View drandyb's Profile") Replied by *[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118325 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* Jerome, thanks for the information. I have spent a lot of time setting up all my products and the website itself. I am new to this so my worry now is whether I will be able to preserve all this work or will I have to start all over with the site and products. How do I change the database drive from "mysql" to "mysqli" without losing the information in the databse or will it not be affected. Thank you for your patience with this "newbie" Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")** - [![drandyb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24834-drandyb "View drandyb's Profile") Topic Author - [ Offline](/forum/user/24834-drandyb) Less More - Posts: 25 - Thank you received: 0 - - 13 years 2 months ago [\#118326](#118326) by [drandyb](/forum/user/24834-drandyb "View drandyb's Profile") Replied by *[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118326 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* Also how will reinstalling Hikashop affect the products. Can I install again over the present install or do I have to uninstall frist. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")** - [![drandyb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24834-drandyb "View drandyb's Profile") Topic Author - [ Offline](/forum/user/24834-drandyb) Less More - Posts: 25 - Thank you received: 0 - - 13 years 2 months ago [\#118334](#118334) by [drandyb](/forum/user/24834-drandyb "View drandyb's Profile") Replied by *[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118334 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* OK after doing some more reading I did the following: 1) updated Joomla 3.1 to version 3.1.5; 2) Set the Database type to "mysqli" ; 3) downloaded and reinstalled Hikashop 2.2.0 When I try to save my badge I get the following error: An error has occurred. 1054 Unknown column 'badge_url' in 'field list' SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','','','','','0','2','','0','15','topright','5','5','badge4_394044966.png' ) message is different but still isn´t working ![:(](/media/kunena/emoticons/5.png ":(") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/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: 4078 - - [](http://obsi.dev) - 13 years 2 months ago [\#118351](#118351) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118351 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* Hi, You should find the HikaShop version in the HikaShop backend (in "Main > Advanced settings"). Like here : [ demo.hikashop.com/administrator/index.ph...config#main\_advanced](http://demo.hikashop.com/administrator/index.php?option=com_hikashop&ctrl=config#main_advanced) Can you please give us the exact version displayed ? I have re-check the installer of HikaShop 2.2.0 package and there is a special code which create the missing column in the badge table. That's why I tell you to re-download HikaShop 2.2.0 Otherwise you can add the column "manually" by using the SQL query (in PhpMyAdmin) Code: ALTER TABLE `#__hikashop_badge` ADD `badge_url` VARCHAR( 255 ) NULL DEFAULT ''; You have to replace "#_" by your database prefix. If your prefix is "jos" the table will be :"jos_hikashop_badge". Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")** - [![drandyb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24834-drandyb "View drandyb's Profile") Topic Author - [ Offline](/forum/user/24834-drandyb) Less More - Posts: 25 - Thank you received: 0 - - 13 years 2 months ago [\#118367](#118367) by [drandyb](/forum/user/24834-drandyb "View drandyb's Profile") Replied by *[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118367 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* Hi, Here is the exact version from the Hikashop configuration panel: HikaShop [1308100008] I went to my Hikashop account>subscriptions and from there downloaded the business version of Hikashop 2.2.0 and reinstalled it in Joomla. I did this twice several hours apart with the same results. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")** - [![drandyb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24834-drandyb "View drandyb's Profile") Topic Author - [ Offline](/forum/user/24834-drandyb) Less More - Posts: 25 - Thank you received: 0 - - 13 years 2 months ago [\#118368](#118368) by [drandyb](/forum/user/24834-drandyb "View drandyb's Profile") Replied by *[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118368 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* I am going to redownload and reinstall again now just to be absolutely sure. Maybe it will work this time. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")** - [![drandyb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24834-drandyb "View drandyb's Profile") Topic Author - [ Offline](/forum/user/24834-drandyb) Less More - Posts: 25 - Thank you received: 0 - - 13 years 2 months ago [\#118369](#118369) by [drandyb](/forum/user/24834-drandyb "View drandyb's Profile") Replied by *[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118369 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* Well I just went through the routine again - downloaded, and installed then tried to create and save a badge. Get this error: An error has occurred. 1054 Unknown column 'badge_url' in 'field list' SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','','','','','0','2','','0','15','topright','5','5','badge4_262562438.png' ) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 13 years 2 months ago [\#118404](#118404) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118404 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* Please run the query manually via PHPMyAdmin: ALTER TABLE `alb_hikashop_badge` ADD `badge_url` VARCHAR( 255 ) NULL DEFAULT ''; You can run more about that issue here: [ www.hikashop.com/support/documentation/6...lity-issues.html#SQL](http://www.hikashop.com/support/documentation/61-hikashop-compatibility-issues.html#SQL) The following user(s) said Thank You: [drandyb](/forum/user/24834-drandyb "View drandyb's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")** - [![drandyb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24834-drandyb "View drandyb's Profile") Topic Author - [ Offline](/forum/user/24834-drandyb) Less More - Posts: 25 - Thank you received: 0 - - 13 years 2 months ago [\#118428](#118428) by [drandyb](/forum/user/24834-drandyb "View drandyb's Profile") Replied by *[drandyb](/forum/user/24834-drandyb "View drandyb's Profile")* on topic *[Problems with Discounts and also with Badges](/forum/26-product-category-display/860862-problems-with-discounts-and-also-with-badges#118428 "-- url of the page with the problem -- : mywebsite.com/mypage -- HikaShop version -- : 2.2.0, Business -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.21 -- Browser(s) name and version -- : Torch version 25.0.0.3831 -- Error-message(debug-mod must be tuned on) -- : Error_message 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Hello, About 3 weeks ago I bought the business version of Hikashop (com_hikashop_business_2.2.0_2013-07-15.tar) and installed it. Since then I have been happily busy setting up all my products, etc. with no real problems - that is until today when two different issues came up. First issue: When I began to try to set up a discount badge to use, every time I try to save the configuration of the new badge I get the following error and am taken completely out of Hikashop back to Joomla. The following is the error I receive: 0 SQL=INSERT IGNORE INTO `alb_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','10% Discuento','1','1376067240','1376153640','','2','1','2','','0','30','topright','3','3','badge2_1806584738.png' ) Second Issue: When I tried to set up a discount and I select several products to apply the discount only one is actually applied and the only way to apply the discount to multiple products is using a category which does work but is too limited because I can´t chose which products to apply the discount to. I will appreciate it greatly if some one can help me resolve these two issues.")* Thanks, after running the query I can save and display badges. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjA4NjItcHJvYmxlbXMtd2l0aC1kaXNjb3VudHMtYW5kLWFsc28td2l0aC1iYWRnZXM/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.100 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)