Problems with Discounts and also with Badges

-- 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"

Also how will reinstalling Hikashop affect the products. Can I install again over the present install or do I have to uninstall frist.

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

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.

I am going to redownload and reinstall again now just to be absolutely sure. Maybe it will work this time.

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' )

Thanks, after running the query I can save and display badges.