- Posts: 37
- Thank you received: 1
Checkout database problem
11 years 1 month ago #214749
by tidosho
Checkout database problem was created 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
-- 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
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
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,
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
Great product and people,
Martin
Please Log in or Create an account to join the conversation.
Time to create page: 0.049 seconds