API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 17th, 2018
301
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.46 KB | None | 0 0
raw download clone embed print report
  1.  
  2. ## 2018-01-17 09:00:45
  3. ## 17923 ## QUERY
  4. 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:45', `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')
  5. BIND: array (
  6. 0 => 'new',
  7. 1 => 'pending',
  8. 2 => NULL,
  9. 3 => 'a7381d',
  10. 4 => 'FAN Courier - Standard',
  11. 5 => 0,
  12. 6 => 1,
  13. 7 => 7342,
  14. 8 => 0.0,
  15. 9 => NULL,
  16. 10 => NULL,
  17. 11 => NULL,
  18. 12 => 1584.68,
  19. 13 => 0.0,
  20. 14 => NULL,
  21. 15 => NULL,
  22. 16 => NULL,
  23. 17 => 0.0,
  24. 18 => NULL,
  25. 19 => 1331.66,
  26. 20 => NULL,
  27. 21 => NULL,
  28. 22 => NULL,
  29. 23 => 253.02,
  30. 24 => NULL,
  31. 25 => NULL,
  32. 26 => NULL,
  33. 27 => 1.0,
  34. 28 => 1.0,
  35. 29 => NULL,
  36. 30 => NULL,
  37. 31 => NULL,
  38. 32 => NULL,
  39. 33 => NULL,
  40. 34 => NULL,
  41. 35 => NULL,
  42. 36 => NULL,
  43. 37 => 0.0,
  44. 38 => NULL,
  45. 39 => NULL,
  46. 40 => NULL,
  47. 41 => 1584.68,
  48. 42 => 0.0,
  49. 43 => NULL,
  50. 44 => NULL,
  51. 45 => NULL,
  52. 46 => 0.0,
  53. 47 => NULL,
  54. 48 => 1.0,
  55. 49 => 1.0,
  56. 50 => 1331.66,
  57. 51 => NULL,
  58. 52 => NULL,
  59. 53 => NULL,
  60. 54 => 253.02,
  61. 55 => NULL,
  62. 56 => NULL,
  63. 57 => NULL,
  64. 58 => NULL,
  65. 59 => NULL,
  66. 60 => NULL,
  67. 61 => NULL,
  68. 62 => NULL,
  69. 63 => 1.0,
  70. 64 => NULL,
  71. 65 => NULL,
  72. 66 => NULL,
  73. 67 => 0,
  74. 68 => 1,
  75. 69 => 1634,
  76. 70 => 1,
  77. 71 => NULL,
  78. 72 => 1,
  79. 73 => NULL,
  80. 74 => NULL,
  81. 75 => NULL,
  82. 76 => 1225,
  83. 77 => 1635,
  84. 78 => NULL,
  85. 79 => NULL,
  86. 80 => NULL,
  87. 81 => NULL,
  88. 82 => 0.0,
  89. 83 => 1584.68,
  90. 84 => 1584.68,
  91. 85 => NULL,
  92. 86 => 0.0,
  93. 87 => 1584.68,
  94. 88 => 1584.68,
  95. 89 => 0.245,
  96. 90 => NULL,
  97. 91 => '6100000804',
  98. 92 => NULL,
  99. 93 => 'RON',
  100. 94 => 'et200@pintea.ro',
  101. 95 => 'pt200',
  102. 96 => 'nt200',
  103. 97 => NULL,
  104. 98 => NULL,
  105. 99 => NULL,
  106. 100 => NULL,
  107. 101 => NULL,
  108. 102 => NULL,
  109. 103 => NULL,
  110. 104 => 'RON',
  111. 105 => NULL,
  112. 106 => NULL,
  113. 107 => 'RON',
  114. 108 => NULL,
  115. 109 => NULL,
  116. 110 => NULL,
  117. 111 => NULL,
  118. 112 => NULL,
  119. 113 => '192.168.56.1',
  120. 114 => 'FANCourier_Standard',
  121. 115 => 'RON',
  122. 116 => 'Main Website
  123. Main Website Store
  124. Default Store View',
  125. 117 => NULL,
  126. 118 => NULL,
  127. 119 => 1,
  128. 120 => NULL,
  129. 121 => 0.0,
  130. 122 => 0.0,
  131. 123 => 0.0,
  132. 124 => 0.0,
  133. 125 => NULL,
  134. 126 => NULL,
  135. 127 => NULL,
  136. 128 => NULL,
  137. 129 => 0.0,
  138. 130 => 0.0,
  139. 131 => NULL,
  140. 132 => 0,
  141. 133 => NULL,
  142. 134 => NULL,
  143. 135 => NULL,
  144. 136 => NULL,
  145. 137 => 0.0,
  146. 138 => NULL,
  147. 139 => NULL,
  148. 140 => NULL,
  149. 141 => '',
  150. 142 => NULL,
  151. 143 => 0,
  152. 144 => '',
  153. 145 => NULL,
  154. 146 => 'online_agent',
  155. 147 => 'No',
  156. 148 => NULL,
  157. 149 => NULL,
  158. 150 => NULL,
  159. 151 => 0,
  160. 152 => 0,
  161. 153 => 0,
  162. 154 => 0,
  163. 155 => NULL,
  164. 156 => 0,
  165. )
  166. AFF: 1
  167. TIME: 0.0011
  168. TRACE: #1 Magento_Db_Adapter_Pdo_Mysql[Varien_Db_Adapter_Pdo_Mysql]#000000005505141200000000388d2b82#->_debugStat(2, 'UPDATE `mg_sales...', array('new', 'pending', NULL, 'a7381d', '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', NULL, NULL, NULL, 0, 0, 0, 0, NULL, 0), &Varien_Db_Statement_Pdo_Mysql#00000000550516cb00000000388d2b82#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:509]
  169. #2 Magento_Db_Adapter_Pdo_Mysql[Varien_Db_Adapter_Pdo_Mysql]#000000005505141200000000388d2b82#->query('UPDATE `mg_sales...', array('new', 'pending', NULL, 'a7381d', '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', NULL, NULL, NULL, 0, 0, 0, 0, NULL, 0)) called at [lib/Zend/Db/Adapter/Abstract.php:635]
  170. #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' => 'a7381d', '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' => NULL, '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]
  171. #4 Mage_Sales_Model_Resource_Order[Mage_Core_Model_Resource_Db_Abstract]#00000000550516fe00000000388d2b82#->save(&IWD_OrderManager_Model_Order_Info#00000000550516e800000000388d2b82#) called at [app/code/core/Mage/Sales/Model/Resource/Order/Abstract.php:425]
  172. #5 Mage_Sales_Model_Resource_Order[Mage_Sales_Model_Resource_Order_Abstract]#00000000550516fe00000000388d2b82#->save(&IWD_OrderManager_Model_Order_Info#00000000550516e800000000388d2b82#) called at [app/code/core/Mage/Core/Model/Abstract.php:318]
  173. #6 IWD_OrderManager_Model_Order_Info[Mage_Core_Model_Abstract]#00000000550516e800000000388d2b82#->save() called at [app/code/community/IWD/OrderManager/Model/Order/Info.php:460]
  174. #7 IWD_OrderManager_Model_Order_Info#00000000550516e800000000388d2b82#->updateOrderDate() called at [app/code/community/IWD/OrderManager/Model/Order/Info.php:308]
  175. #8 IWD_OrderManager_Model_Order_Info#00000000550516e800000000388d2b82#->updateOrderData() called at [app/code/community/IWD/OrderManager/Model/Order/Info.php:169]
  176. #9 IWD_OrderManager_Model_Order_Info#00000000550516e800000000388d2b82#->editInfo() called at [app/code/community/IWD/OrderManager/Model/Order/Info.php:31]
  177. #10 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]
  178. #11 IWD_OrderManager_Adminhtml_Sales_OrderinfoController#000000005505140b00000000388d2b82#->updateInfo() called at [app/code/community/IWD/OrderManager/Controller/Abstract.php:31]
  179. #12 IWD_OrderManager_Adminhtml_Sales_OrderinfoController[IWD_OrderManager_Controller_Abstract]#000000005505140b00000000388d2b82#->updateInfoAction() called at [app/code/core/Mage/Core/Controller/Varien/Action.php:418]
  180. #13 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]
  181. #14 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]
  182. #15 Mage_Core_Controller_Varien_Front#000000005505143a00000000388d2b82#->dispatch() called at [app/code/core/Mage/Core/Model/App.php:365]
  183. #16 Mage_Core_Model_App#000000005505142d00000000388d2b82#->run(array('scope_code' => '', 'scope_type' => 'store', 'options' => array())) called at [app/Mage.php:691]
  184. #17 Mage::run('', 'store') called at [index.php:84]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!