IGNORE INTO `#__hikashop_order` ( `order_user_id`,`order_status`,`order_shipping_address_id`,`order_billing_address_id`,`order_currency_id`,`order_currency_info`,`order_type`,`order_full_price`,`order_tax_info`,`order_shipping_price`,`order_shipping_tax`,`order_payment_price`,`order_discount_tax`,`order_discount_price`,`order_payment_id`,`order_payment_method`,`products`,`order_created`,`order_ip`,`order_modified`,`order_serial_params` ) VALUES ( '11','created','14','14','2','O:8:\"stdClass\":4:{s:13:\"currency_code\";s:3:\"USD\";s:13:\"currency_rate\";s:7:\"1.11570\";s:20:\"currency_percent_fee\";s:4:\"0.00\";s:17:\"currency_modified\";s:10:\"1469302235\";}','sale','0.99','a:1:{s:0:\"\";O:8:\"stdClass\":3:{s:11:\"tax_namekey\";s:0:\"\";s:8:\"tax_rate\";s:7:\"0.00000\";s:10:\"tax_amount\";i:0;}}','0','0','0','0','0','1','authorize','','1469303415','69.246.184.174','1469303415','{\"order\":[],\"product\":[],\"order_product\":[],\"serial\":[]}' )
The only thing I see wrong with this display is the '#__hikashop_order', whereas the table field has a prefix code that is not displayed instead of the '#'. I'm not sure if this is shown strictly for security purpose to keep the 'prefix' hidden. Other than that, I'm not sure why it didn't execute the SQL properly.