Skip to main content

Checkout database problem

11 years 1 month ago #214749 by tidosho
-- 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.

11 years 1 month ago #214750 by Jerome
Replied by Jerome on topic Checkout database problem
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.
The following user(s) said Thank You: tidosho

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

11 years 1 month ago #214881 by tidosho
Replied by tidosho on topic Checkout database problem
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.049 seconds
Powered by Kunena Forum