Checkout database problem

  • Posts: 37
  • Thank you received: 1
9 years 2 months ago #214749

-- url of the page with the problem -- : maxmon.co.uk/buy/products
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'order_currency_info' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_order` ( `order_user_id`,`order_status`,`order_shipping_address_id`,`order_billing_address_id`,`order_discount_code`,`order_currency_id`,`order_currency_info`,`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 ( '16','created','16','16','SBS15','4','O:8:\"stdClass\":4:{s:13:\"currency_code\";s:3:\"GBP\";s:13:\"currency_rate\";s:7:\"1.00000\";s:20:\"currency_percent_fee\";s:4:\"0.00\";s:17:\"currency_modified\";s:10:\"1360151412\";}','sale','333','a:0:{}','0','0','O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{s:3:\"5@0\";O:8:\"stdClass\":2:{s:14:\"price_with_tax\";s:7:\"0.00000\";s:3:\"tax\";d:0;}}}','0','0','37','5','manual','1','banktransfer','1442756481','94.197.120.174','1442756481' )

Help! I'm at a trade show unable to access my admin site and my customers are reporting the error below at my online checkout. I'm on a fairly recent HS version. You can try the checkout at maxmon.co.uk/buy/products .

Martin

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
9 years 2 months ago #214750

Hi,

Click on the toolbar button "check database" when you are in the HikaShop backend configuration interface.
It will fix your database issues and add the missing column.

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.
The following user(s) said Thank You: tidosho

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

  • Posts: 37
  • Thank you received: 1
9 years 2 months ago #214881

Fantastic and prompt support as usual. Problem sorted!

Great product and people,

Martin

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

Time to create page: 0.061 seconds
Powered by Kunena Forum