Checkout problem

  • Posts: 10
  • Thank you received: 0
11 years 9 months ago #119015

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

Please Log in or Create an account to join the conversation.

  • Posts: 26251
  • Thank you received: 4039
  • MODERATOR
11 years 9 months ago #119035

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.

ALTER TABLE `#__hikashop_badge` ADD `badge_quantity` VARCHAR( 255 ) NULL DEFAULT '';
by replacing #_ by your database prefix. In your case it's:
ALTER TABLE `jos_allergeko__1_hikashop_badge` ADD `badge_quantity` VARCHAR( 255 ) NULL DEFAULT '';
Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
11 years 9 months ago #119238

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\":3:{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' )

Please Log in or Create an account to join the conversation.

  • Posts: 83932
  • Thank you received: 13588
  • MODERATOR
11 years 9 months ago #119241

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

Please Log in or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
11 years 9 months ago #119248

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! :(

Please Log in or Create an account to join the conversation.

  • Posts: 83932
  • Thank you received: 13588
  • MODERATOR
11 years 9 months ago #119252

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

Last edit: 11 years 9 months ago by nicolas.
The following user(s) said Thank You: fantomet

Please Log in or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
11 years 9 months ago #119326

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.073 seconds
Powered by Kunena Forum