Checkout problem

-- url of the page with the problem -- : www.allergeko.se (
-- HikaShop version -- : 2.2.0
-- Joomla version -- : 2.5.14
-- PHP version -- : 5.4.10
-- Browser(s) name and version -- : IE 9 (32 & 64-bit), Firefox 23.0
-- Error-message(debug-mod must be tuned on) -- : Don't know if this message has anything to do with my problem but it shows up when i turn on debug (it shows when I enter the site, not specificly on checkout): 500 - JDatabaseMySQLi::query: 1054 - Unknown column 'a.badge_quantity' in 'where clause' SQL=SELECT a.* FROM jos_allergeko__1_hikashop_badge AS a WHERE a.badge_start <= 1376565311 AND ( a.badge_end >= 1376565311 OR a.badge_end =0 ) AND a.badge_published=1 AND (a.badge_quantity='' OR a.badge_quantity=-1) AND (badge_discount_id=0 OR badge_discount_id=0 )AND ((badge_category_childs = 0 AND (badge_category_id = 0 OR badge_category_id = 13))OR (badge_category_childs = 1 AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 13))) ORDER BY a.badge_ordering ASC,a.badge_id ASC

My problem is that when I reach checkout an wants to proceed to paying and click the button: Refresh/Next (Uppdatera/Nästa in Swedish) the checkout doesn't continue the page just refreshes. Nothing else ever happens. I have tried, updating joomla, reinstalling hikashop (latest version), updating firefox and so on. I have only one delivery option and only one payment option and they are pre-selected. I have searched the forums and only found semi-similar problems but no one exactly like mine. I have scratched my head plenty, can you help? Please!

Hi,

It seams you had a problem during the update of HikaShop, some tables in your database hasn't been updated.
You have to update your database using PHPmyAdmin, creating the missing columns. by replacing #_ by your database prefix. In your case it's: Regards,

The errors keep coming! Now I got this one! Is there a similar way to fix this?

500 - JDatabaseMySQLi::query: 1054 - Unknown column 'order_shipping_params' in 'field list' SQL=INSERT IGNORE INTO `jos_allergeko__1_hikashop_order` ( `order_user_id`,`order_status`,`order_shipping_address_id`,`order_billing_address_id`,`order_currency_id`,`order_type`,`order_full_price`,`order_tax_info`,`order_shipping_price`,`order_shipping_tax`,`order_shipping_params`,`order_payment_price`,`order_discount_tax`,`order_discount_price`,`order_shipping_id`,`order_shipping_method`,`order_payment_id`,`order_payment_method`,`order_created`,`order_ip`,`order_modified` ) VALUES ( '1','created','3','3','150','sale','220.0008048','a:1:{s:10:\"Moms (12%)\";O:8:\"stdClass\":4:{s:11:\"tax_namekey\";s:10:\"Moms (12%)\";s:8:\"tax_rate\";s:7:\"0.12000\";s:10:\"tax_amount\";d:23.571514799999999212332113529555499553680419921875;s:23:\"tax_amount_for_shipping\";d:8.0358000000000000540012479177676141262054443359375;}}','75.0008','8.0358','O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{i:5;O:8:\"stdClass\":{s:14:\"price_with_tax\";d:75.000799999999998135535861365497112274169921875;s:3:\"tax\";d:8.0357999999999947249307297170162200927734375;s:5:\"taxes\";a:1:{s:10:\"Moms (12%)\";d:8.0358000000000000540012479177676141262054443359375;}}}}','0','0','0','5','manual','1','paypal','1376682059','83.254.29.236','1376682059' )

It's the same issue. It comes from the update which wasn't successful for your database structure.

You'll have to run the other update queries manually in a similar manner.
You can find more information on the issue and the explanation to solve it here:
www.hikashop.com/support/documentation/6...lity-issues.html#SQL

So I have to run: ALTER TABLE `jos_allergeko__hikashop_order` ADD `order_user_id`,`order_status`,`order_shipping_address_id`,`order_billing_address_id`,`order_currency_id`,`order_type`,`order_full_price`,`order_tax_info`,`order_shipping_price`,`order_shipping_tax`,`order_shipping_params`,`order_payment_price`,`order_discount_tax`,`order_discount_price`,`order_shipping_id`,`order_shipping_method`,`order_payment_id`,`order_payment_method`,`order_created`,`order_ip`,`order_modified`` VARCHAR( 255 ) NULL DEFAULT '';

Or how should I go about to do this the easy way? mySQL is not my strong side!

No. The message says that you're missing the order_shipping_params columns, so you should just add that column, not all of them.
So like that:
ALTER TABLE `jos_allergeko__1_hikashop_order` ADD `order_shipping_params` VARCHAR( 255 ) NULL DEFAULT '';

TY - I had to repeat the procedure a couple of times to add som more missing fields but it's working now!