Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## 2018-01-17 09:00:42
- ## 17923 ## QUERY
- SQL: UPDATE `mg_sales_flat_order` SET `state` = ?, `status` = ?, `coupon_code` = ?, `protect_code` = ?, `shipping_description` = ?, `is_virtual` = ?, `store_id` = ?, `customer_id` = ?, `base_discount_amount` = ?, `base_discount_canceled` = ?, `base_discount_invoiced` = ?, `base_discount_refunded` = ?, `base_grand_total` = ?, `base_shipping_amount` = ?, `base_shipping_canceled` = ?, `base_shipping_invoiced` = ?, `base_shipping_refunded` = ?, `base_shipping_tax_amount` = ?, `base_shipping_tax_refunded` = ?, `base_subtotal` = ?, `base_subtotal_canceled` = ?, `base_subtotal_invoiced` = ?, `base_subtotal_refunded` = ?, `base_tax_amount` = ?, `base_tax_canceled` = ?, `base_tax_invoiced` = ?, `base_tax_refunded` = ?, `base_to_global_rate` = ?, `base_to_order_rate` = ?, `base_total_canceled` = ?, `base_total_invoiced` = ?, `base_total_invoiced_cost` = ?, `base_total_offline_refunded` = ?, `base_total_online_refunded` = ?, `base_total_paid` = ?, `base_total_qty_ordered` = ?, `base_total_refunded` = ?, `discount_amount` = ?, `discount_canceled` = ?, `discount_invoiced` = ?, `discount_refunded` = ?, `grand_total` = ?, `shipping_amount` = ?, `shipping_canceled` = ?, `shipping_invoiced` = ?, `shipping_refunded` = ?, `shipping_tax_amount` = ?, `shipping_tax_refunded` = ?, `store_to_base_rate` = ?, `store_to_order_rate` = ?, `subtotal` = ?, `subtotal_canceled` = ?, `subtotal_invoiced` = ?, `subtotal_refunded` = ?, `tax_amount` = ?, `tax_canceled` = ?, `tax_invoiced` = ?, `tax_refunded` = ?, `total_canceled` = ?, `total_invoiced` = ?, `total_offline_refunded` = ?, `total_online_refunded` = ?, `total_paid` = ?, `total_qty_ordered` = ?, `total_refunded` = ?, `can_ship_partially` = ?, `can_ship_partially_item` = ?, `customer_is_guest` = ?, `customer_note_notify` = ?, `billing_address_id` = ?, `customer_group_id` = ?, `edit_increment` = ?, `email_sent` = ?, `forced_shipment_with_invoice` = ?, `payment_auth_expiration` = ?, `quote_address_id` = ?, `quote_id` = ?, `shipping_address_id` = ?, `adjustment_negative` = ?, `adjustment_positive` = ?, `base_adjustment_negative` = ?, `base_adjustment_positive` = ?, `base_shipping_discount_amount` = ?, `base_subtotal_incl_tax` = ?, `base_total_due` = ?, `payment_authorization_amount` = ?, `shipping_discount_amount` = ?, `subtotal_incl_tax` = ?, `total_due` = ?, `weight` = ?, `customer_dob` = ?, `increment_id` = ?, `applied_rule_ids` = ?, `base_currency_code` = ?, `customer_email` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_middlename` = ?, `customer_prefix` = ?, `customer_suffix` = ?, `customer_taxvat` = ?, `discount_description` = ?, `ext_customer_id` = ?, `ext_order_id` = ?, `global_currency_code` = ?, `hold_before_state` = ?, `hold_before_status` = ?, `order_currency_code` = ?, `original_increment_id` = ?, `relation_child_id` = ?, `relation_child_real_id` = ?, `relation_parent_id` = ?, `relation_parent_real_id` = ?, `remote_ip` = ?, `shipping_method` = ?, `store_currency_code` = ?, `store_name` = ?, `x_forwarded_for` = ?, `customer_note` = ?, `created_at` = '2018-01-16 21:52:16', `updated_at` = '2018-01-17 09:00:42', `total_item_count` = ?, `customer_gender` = ?, `hidden_tax_amount` = ?, `base_hidden_tax_amount` = ?, `shipping_hidden_tax_amount` = ?, `base_shipping_hidden_tax_amnt` = ?, `hidden_tax_invoiced` = ?, `base_hidden_tax_invoiced` = ?, `hidden_tax_refunded` = ?, `base_hidden_tax_refunded` = ?, `shipping_incl_tax` = ?, `base_shipping_incl_tax` = ?, `coupon_rule_name` = ?, `paypal_ipn_customer_notified` = ?, `gift_message_id` = ?, `invoice_date` = ?, `delivery_date` = ?, `iwd_backup_id` = ?, `iwd_om_fee_amount` = ?, `iwd_om_fee_base_amount` = ?, `iwd_om_fee_description` = ?, `awb_id` = ?, `mailchimp_sync_delta` = '-0001-11-30 00:00:00', `mailchimp_sync_error` = ?, `mailchimp_campaign_id` = ?, `mailchimp_abandonedcart_flag` = ?, `mailchimp_landing_page` = ?, `mailchimp_sync_modified` = ?, `origin_type` = ?, `sameday_delivery` = ?, `so_order_id` = ?, `order_type` = ?, `azero_type` = ?, `f64_survey_sent` = ?, `f64_course_email_notification` = ?, `f64_has_course` = ?, `f64_course_email_sent` = ?, `f64_parale_commission` = ?, `f64_order_reserved_date` = '-0001-11-30 00:00:00', `f64_has_rent` = ? WHERE (entity_id='856')
- BIND: array (
- 0 => 'new',
- 1 => 'pending',
- 2 => NULL,
- 3 => '2a7a16',
- 4 => 'FAN Courier - Standard',
- 5 => 0,
- 6 => 1,
- 7 => 7342,
- 8 => 0.0,
- 9 => NULL,
- 10 => NULL,
- 11 => NULL,
- 12 => 1584.68,
- 13 => 0.0,
- 14 => NULL,
- 15 => NULL,
- 16 => NULL,
- 17 => 0.0,
- 18 => NULL,
- 19 => 1331.66,
- 20 => NULL,
- 21 => NULL,
- 22 => NULL,
- 23 => 253.02,
- 24 => NULL,
- 25 => NULL,
- 26 => NULL,
- 27 => 1.0,
- 28 => 1.0,
- 29 => NULL,
- 30 => NULL,
- 31 => NULL,
- 32 => NULL,
- 33 => NULL,
- 34 => NULL,
- 35 => NULL,
- 36 => NULL,
- 37 => 0.0,
- 38 => NULL,
- 39 => NULL,
- 40 => NULL,
- 41 => 1584.68,
- 42 => 0.0,
- 43 => NULL,
- 44 => NULL,
- 45 => NULL,
- 46 => 0.0,
- 47 => NULL,
- 48 => 1.0,
- 49 => 1.0,
- 50 => 1331.66,
- 51 => NULL,
- 52 => NULL,
- 53 => NULL,
- 54 => 253.02,
- 55 => NULL,
- 56 => NULL,
- 57 => NULL,
- 58 => NULL,
- 59 => NULL,
- 60 => NULL,
- 61 => NULL,
- 62 => NULL,
- 63 => 1.0,
- 64 => NULL,
- 65 => NULL,
- 66 => NULL,
- 67 => 0,
- 68 => 1,
- 69 => 1634,
- 70 => 1,
- 71 => NULL,
- 72 => 1,
- 73 => NULL,
- 74 => NULL,
- 75 => NULL,
- 76 => 1225,
- 77 => 1635,
- 78 => NULL,
- 79 => NULL,
- 80 => NULL,
- 81 => NULL,
- 82 => 0.0,
- 83 => 1584.68,
- 84 => 1584.68,
- 85 => NULL,
- 86 => 0.0,
- 87 => 1584.68,
- 88 => 1584.68,
- 89 => 0.245,
- 90 => NULL,
- 91 => '6100000804',
- 92 => NULL,
- 93 => 'RON',
- 94 => 'et200@pintea.ro',
- 95 => 'pt200',
- 96 => 'nt200',
- 97 => NULL,
- 98 => NULL,
- 99 => NULL,
- 100 => NULL,
- 101 => NULL,
- 102 => NULL,
- 103 => NULL,
- 104 => 'RON',
- 105 => NULL,
- 106 => NULL,
- 107 => 'RON',
- 108 => NULL,
- 109 => NULL,
- 110 => NULL,
- 111 => NULL,
- 112 => NULL,
- 113 => '192.168.56.1',
- 114 => 'FANCourier_Standard',
- 115 => 'RON',
- 116 => 'Main Website
- Main Website Store
- Default Store View',
- 117 => NULL,
- 118 => NULL,
- 119 => 1,
- 120 => NULL,
- 121 => 0.0,
- 122 => 0.0,
- 123 => 0.0,
- 124 => 0.0,
- 125 => NULL,
- 126 => NULL,
- 127 => NULL,
- 128 => NULL,
- 129 => 0.0,
- 130 => 0.0,
- 131 => NULL,
- 132 => 0,
- 133 => NULL,
- 134 => NULL,
- 135 => NULL,
- 136 => NULL,
- 137 => 0.0,
- 138 => NULL,
- 139 => NULL,
- 140 => NULL,
- 141 => '',
- 142 => NULL,
- 143 => 0,
- 144 => '',
- 145 => NULL,
- 146 => 'online_agent',
- 147 => 'No',
- 148 => 2509974,
- 149 => NULL,
- 150 => NULL,
- 151 => 0,
- 152 => 0,
- 153 => 0,
- 154 => 0,
- 155 => NULL,
- 156 => 0,
- )
- AFF: 1
- TIME: 0.0009
- TRACE: #1 Magento_Db_Adapter_Pdo_Mysql[Varien_Db_Adapter_Pdo_Mysql]#000000005505141200000000388d2b82#->_debugStat(2, 'UPDATE `mg_sales...', array('new', 'pending', NULL, '2a7a16', 'FAN Courier - St...', 0, 1, 7342, 0, NULL, NULL, NULL, 1584.68, 0, NULL, NULL, NULL, 0, NULL, 1331.66, NULL, NULL, NULL, 253.02, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 1584.68, 0, NULL, NULL, NULL, 0, NULL, 1, 1, 1331.66, NULL, NULL, NULL, 253.02, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 1, 1634, 1, NULL, 1, NULL, NULL, NULL, 1225, 1635, NULL, NULL, NULL, NULL, 0, 1584.68, 1584.68, NULL, 0, 1584.68, 1584.68, 0.245, NULL, 6100000804, NULL, 'RON', 'et200@pintea.ro', 'pt200', 'nt200', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RON', NULL, NULL, 'RON', NULL, NULL, NULL, NULL, NULL, '192.168.56.1', 'FANCourier_Stand...', 'RON', 'Main Website\nMai...', NULL, NULL, 1, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, '', NULL, 0, '', NULL, 'online_agent', 'No', 2509974, NULL, NULL, 0, 0, 0, 0, NULL, 0), &Varien_Db_Statement_Pdo_Mysql#000000005505116700000000388d2b82#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:509]
- #2 Magento_Db_Adapter_Pdo_Mysql[Varien_Db_Adapter_Pdo_Mysql]#000000005505141200000000388d2b82#->query('UPDATE `mg_sales...', array('new', 'pending', NULL, '2a7a16', 'FAN Courier - St...', 0, 1, 7342, 0, NULL, NULL, NULL, 1584.68, 0, NULL, NULL, NULL, 0, NULL, 1331.66, NULL, NULL, NULL, 253.02, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 1584.68, 0, NULL, NULL, NULL, 0, NULL, 1, 1, 1331.66, NULL, NULL, NULL, 253.02, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 1, 1634, 1, NULL, 1, NULL, NULL, NULL, 1225, 1635, NULL, NULL, NULL, NULL, 0, 1584.68, 1584.68, NULL, 0, 1584.68, 1584.68, 0.245, NULL, 6100000804, NULL, 'RON', 'et200@pintea.ro', 'pt200', 'nt200', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RON', NULL, NULL, 'RON', NULL, NULL, NULL, NULL, NULL, '192.168.56.1', 'FANCourier_Stand...', 'RON', 'Main Website\nMai...', NULL, NULL, 1, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, '', NULL, 0, '', NULL, 'online_agent', 'No', 2509974, NULL, NULL, 0, 0, 0, 0, NULL, 0)) called at [lib/Zend/Db/Adapter/Abstract.php:635]
- #3 Magento_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#000000005505141200000000388d2b82#->update('mg_sales_flat_or...', array('state' => 'new', 'status' => 'pending', 'coupon_code' => NULL, 'protect_code' => '2a7a16', 'shipping_descrip...' => 'FAN Courier - St...', 'is_virtual' => 0, 'store_id' => 1, 'customer_id' => 7342, 'base_discount_am...' => 0, 'base_discount_ca...' => NULL, 'base_discount_in...' => NULL, 'base_discount_re...' => NULL, 'base_grand_total' => 1584.68, 'base_shipping_am...' => 0, 'base_shipping_ca...' => NULL, 'base_shipping_in...' => NULL, 'base_shipping_re...' => NULL, 'base_shipping_ta...' => 0, 'base_shipping_ta...' => NULL, 'base_subtotal' => 1331.66, 'base_subtotal_ca...' => NULL, 'base_subtotal_in...' => NULL, 'base_subtotal_re...' => NULL, 'base_tax_amount' => 253.02, 'base_tax_cancele...' => NULL, 'base_tax_invoice...' => NULL, 'base_tax_refunde...' => NULL, 'base_to_global_r...' => 1, 'base_to_order_ra...' => 1, 'base_total_cance...' => NULL, 'base_total_invoi...' => NULL, 'base_total_invoi...' => NULL, 'base_total_offli...' => NULL, 'base_total_onlin...' => NULL, 'base_total_paid' => NULL, 'base_total_qty_o...' => NULL, 'base_total_refun...' => NULL, 'discount_amount' => 0, 'discount_cancele...' => NULL, 'discount_invoice...' => NULL, 'discount_refunde...' => NULL, 'grand_total' => 1584.68, 'shipping_amount' => 0, 'shipping_cancele...' => NULL, 'shipping_invoice...' => NULL, 'shipping_refunde...' => NULL, 'shipping_tax_amo...' => 0, 'shipping_tax_ref...' => NULL, 'store_to_base_ra...' => 1, 'store_to_order_r...' => 1, 'subtotal' => 1331.66, 'subtotal_cancele...' => NULL, 'subtotal_invoice...' => NULL, 'subtotal_refunde...' => NULL, 'tax_amount' => 253.02, 'tax_canceled' => NULL, 'tax_invoiced' => NULL, 'tax_refunded' => NULL, 'total_canceled' => NULL, 'total_invoiced' => NULL, 'total_offline_re...' => NULL, 'total_online_ref...' => NULL, 'total_paid' => NULL, 'total_qty_ordere...' => 1, 'total_refunded' => NULL, 'can_ship_partial...' => NULL, 'can_ship_partial...' => NULL, 'customer_is_gues...' => 0, 'customer_note_no...' => 1, 'billing_address_...' => 1634, 'customer_group_i...' => 1, 'edit_increment' => NULL, 'email_sent' => 1, 'forced_shipment_...' => NULL, 'payment_auth_exp...' => NULL, 'quote_address_id' => NULL, 'quote_id' => 1225, 'shipping_address...' => 1635, 'adjustment_negat...' => NULL, 'adjustment_posit...' => NULL, 'base_adjustment_...' => NULL, 'base_adjustment_...' => NULL, 'base_shipping_di...' => 0, 'base_subtotal_in...' => 1584.68, 'base_total_due' => 1584.68, 'payment_authoriz...' => NULL, 'shipping_discoun...' => 0, 'subtotal_incl_ta...' => 1584.68, 'total_due' => 1584.68, 'weight' => 0.245, 'customer_dob' => NULL, 'increment_id' => 6100000804, 'applied_rule_ids' => NULL, 'base_currency_co...' => 'RON', 'customer_email' => 'et200@pintea.ro', 'customer_firstna...' => 'pt200', 'customer_lastnam...' => 'nt200', 'customer_middlen...' => NULL, 'customer_prefix' => NULL, 'customer_suffix' => NULL, 'customer_taxvat' => NULL, 'discount_descrip...' => NULL, 'ext_customer_id' => NULL, 'ext_order_id' => NULL, 'global_currency_...' => 'RON', 'hold_before_stat...' => NULL, 'hold_before_stat...' => NULL, 'order_currency_c...' => 'RON', 'original_increme...' => NULL, 'relation_child_i...' => NULL, 'relation_child_r...' => NULL, 'relation_parent_...' => NULL, 'relation_parent_...' => NULL, 'remote_ip' => '192.168.56.1', 'shipping_method' => 'FANCourier_Stand...', 'store_currency_c...' => 'RON', 'store_name' => 'Main Website\nMai...', 'x_forwarded_for' => NULL, 'customer_note' => NULL, 'total_item_count' => 1, 'customer_gender' => NULL, 'hidden_tax_amoun...' => 0, 'base_hidden_tax_...' => 0, 'shipping_hidden_...' => 0, 'base_shipping_hi...' => 0, 'hidden_tax_invoi...' => NULL, 'base_hidden_tax_...' => NULL, 'hidden_tax_refun...' => NULL, 'base_hidden_tax_...' => NULL, 'shipping_incl_ta...' => 0, 'base_shipping_in...' => 0, 'coupon_rule_name' => NULL, 'paypal_ipn_custo...' => 0, 'gift_message_id' => NULL, 'invoice_date' => NULL, 'delivery_date' => NULL, 'iwd_backup_id' => NULL, 'iwd_om_fee_amoun...' => 0, 'iwd_om_fee_base_...' => NULL, 'iwd_om_fee_descr...' => NULL, 'awb_id' => NULL, 'mailchimp_sync_e...' => '', 'mailchimp_campai...' => NULL, 'mailchimp_abando...' => 0, 'mailchimp_landin...' => '', 'mailchimp_sync_m...' => NULL, 'origin_type' => 'online_agent', 'sameday_delivery' => 'No', 'so_order_id' => 2509974, 'order_type' => NULL, 'azero_type' => NULL, 'f64_survey_sent' => 0, 'f64_course_email...' => 0, 'f64_has_course' => 0, 'f64_course_email...' => 0, 'f64_parale_commi...' => NULL, 'f64_has_rent' => 0), '(entity_id=\'856\'...') called at [app/code/core/Mage/Core/Model/Resource/Db/Abstract.php:433]
- #4 Mage_Sales_Model_Resource_Order[Mage_Core_Model_Resource_Db_Abstract]#00000000550516fe00000000388d2b82#->save(&F64_Courses_Model_Order#00000000550516d500000000388d2b82#) called at [app/code/core/Mage/Sales/Model/Resource/Order/Abstract.php:425]
- #5 Mage_Sales_Model_Resource_Order[Mage_Sales_Model_Resource_Order_Abstract]#00000000550516fe00000000388d2b82#->save(&F64_Courses_Model_Order#00000000550516d500000000388d2b82#) called at [app/code/core/Mage/Core/Model/Abstract.php:318]
- #6 F64_Courses_Model_Order[Mage_Core_Model_Abstract]#00000000550516d500000000388d2b82#->save() called at [app/code/local/F64/Socrate/Model/Observer.php:190]
- #7 F64_Socrate_Model_Observer#00000000550516d900000000388d2b82#->orderEditInfoBefore(&F64_Courses_Model_Order#00000000550516d500000000388d2b82#) called at [app/code/local/F64/Socrate/Model/Observer.php:108]
- #8 F64_Socrate_Model_Observer#00000000550516d900000000388d2b82#->queOrderEditInfoBefore(&Varien_Event_Observer#000000005505147100000000388d2b82#) called at [app/code/core/Mage/Core/Model/App.php:1364]
- #9 Mage_Core_Model_App#000000005505142d00000000388d2b82#->_callObserverMethod(&F64_Socrate_Model_Observer#00000000550516d900000000388d2b82#, 'queOrderEditInfo...', &Varien_Event_Observer#000000005505147100000000388d2b82#) called at [app/code/core/Mage/Core/Model/App.php:1343]
- #10 Mage_Core_Model_App#000000005505142d00000000388d2b82#->dispatchEvent('iwd_ordermanager...', array('order_id' => 856)) called at [app/Mage.php:456]
- #11 Mage::dispatchEvent('iwd_ordermanager...', array('order_id' => 856)) called at [app/code/community/IWD/OrderManager/Model/Order/Info.php:314]
- #12 IWD_OrderManager_Model_Order_Info#00000000550516e800000000388d2b82#->updateOrderStatus() called at [app/code/community/IWD/OrderManager/Model/Order/Info.php:302]
- #13 IWD_OrderManager_Model_Order_Info#00000000550516e800000000388d2b82#->updateOrderData() called at [app/code/community/IWD/OrderManager/Model/Order/Info.php:169]
- #14 IWD_OrderManager_Model_Order_Info#00000000550516e800000000388d2b82#->editInfo() called at [app/code/community/IWD/OrderManager/Model/Order/Info.php:31]
- #15 IWD_OrderManager_Model_Order_Info#00000000550516e800000000388d2b82#->updateOrderInfo(array('key' => '5922df90a2cbb784...', 'isAjax' => 'true', 'form_key' => 'CxLRNUMCAxjxEG20', 'increment_id' => 6100000804, 'created_at' => '01-16-2018 23:52...', 'reserved_date' => '0000-00-00 00:00...', 'status' => 'delivery_ready', 'store_id' => 1, 'order_id' => 856)) called at [app/code/community/IWD/OrderManager/controllers/Adminhtml/Sales/OrderinfoController.php:33]
- #16 IWD_OrderManager_Adminhtml_Sales_OrderinfoController#000000005505140b00000000388d2b82#->updateInfo() called at [app/code/community/IWD/OrderManager/Controller/Abstract.php:31]
- #17 IWD_OrderManager_Adminhtml_Sales_OrderinfoController[IWD_OrderManager_Controller_Abstract]#000000005505140b00000000388d2b82#->updateInfoAction() called at [app/code/core/Mage/Core/Controller/Varien/Action.php:418]
- #18 IWD_OrderManager_Adminhtml_Sales_OrderinfoController[Mage_Core_Controller_Varien_Action]#000000005505140b00000000388d2b82#->dispatch('updateInfo') called at [app/code/core/Mage/Core/Controller/Varien/Router/Standard.php:254]
- #19 Mage_Core_Controller_Varien_Router_Admin[Mage_Core_Controller_Varien_Router_Standard]#000000005505141b00000000388d2b82#->match(&Mage_Core_Controller_Request_Http#000000005505141d00000000388d2b82#) called at [app/code/core/Mage/Core/Controller/Varien/Front.php:172]
- #20 Mage_Core_Controller_Varien_Front#000000005505143a00000000388d2b82#->dispatch() called at [app/code/core/Mage/Core/Model/App.php:365]
- #21 Mage_Core_Model_App#000000005505142d00000000388d2b82#->run(array('scope_code' => '', 'scope_type' => 'store', 'options' => array())) called at [app/Mage.php:691]
- #22 Mage::run('', 'store') called at [index.php:84]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement