May 24 2021 11:25 -- IPN PROCESSING INITIATED.
*** Originating IP: 173.0.81.65 notify.paypal.com
*** Browser/User Agent: PayPal IPN (
https://www.paypal.com/ipn )
May 24 2021 11:25 -- Breakpoint: 0 - Initializing debugging.
May 24 2021 11:25 -- Breakpoint: Flag Status:
isECtransaction = 1
isDPtransaction = 0
May 24 2021 11:25 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => <snipped>
[address_country] => Japan
[address_country_code] => JP
[address_name] => <snipped>
[address_state] => Tokyo
[address_status] => confirmed
[address_street] => <snipped>
[address_zip] => <snipped>
[auth_amount] => <snipped>
[auth_exp] => 19:46:42 Jun 19, 2021 PDT
[auth_id] => 1****************
[auth_status] => Completed
[business] => <snipped>
[charset] => windows-1252
[custom] => EC-**-**********
[discount] => 0
[first_name] => <snipped>
[insurance_amount] => 0
[invoice] => **-**********-[ProteaWinesJapan]
[ipn_track_id] => <snipped>
[item_name1] => <snipped>
[item_name2] => <snipped>
[item_name3] => <snipped>
[item_name4] => <snipped>
[item_name5] => <snipped>
[item_number1] => <snipped>
[item_number2] => <snipped>
[item_number3] => <snipped>
[item_number4] => <snipped>
[item_number5] => <snipped>
[last_name] => <snipped>
[mc_currency] => JPY
[mc_fee] => <snipped>
[mc_gross] => <snipped>
[mc_gross_1] => <snipped>
[mc_gross_2] => <snipped>
[mc_gross_3] => <snipped>
[mc_gross_4] => <snipped>
[mc_gross_5] => <snipped>
[mc_handling] => 0
[mc_handling1] => 0
[mc_handling2] => 0
[mc_handling3] => 0
[mc_handling4] => 0
[mc_handling5] => 0
[mc_shipping] => 0
[mc_shipping1] => 0
[mc_shipping2] => 0
[mc_shipping3] => 0
[mc_shipping4] => 0
[mc_shipping5] => 0
[memo] => Thank you for your order.
[notify_version] => 3.9
[num_cart_items] => 5
[option_name1_1] =>
[option_name2_1] =>
[option_name3_1] =>
[option_name4_1] =>
[option_name5_1] =>
[option_selection1_1] =>
[option_selection2_1] =>
[option_selection3_1] =>
[option_selection4_1] =>
[option_selection5_1] =>
[parent_txn_id] => 1****************
[payer_email] => <snipped>
[payer_id] => <snipped>
[payer_status] => unverified
[payment_date] => 21:52:54 May 21, 2021 PDT
[payment_fee] =>
[payment_gross] =>
[payment_status] => Completed
[payment_type] => instant
[protection_eligibility] => Eligible
[quantity1] => 1
[quantity2] => 1
[quantity3] => 1
[quantity4] => 1
[quantity5] => 1
[receiver_email] => <snipped>
[receiver_id] => <snipped>
[remaining_settle] => 0
[residence_country] => JP
[shipping_discount] => 0
[shipping_method] => Default
[tax] => <snipped>
[tax1] => 0
[tax2] => 0
[tax3] => 0
[tax4] => 0
[tax5] => 0
[transaction_entity] => payment
[transaction_subject] =>
[txn_id] => 5****************
[txn_type] => cart
[verify_sign] => A6P0mz
)
May 24 2021 11:25 -- IPN INFO - POST VARS to be sent back (unsorted) for validation (using CURL):
To: ipnpb.paypal.com:443
Array
(
[cmd] => _notify-validate
[option_selection3_1] =>
[invoice] => **-**********-[ProteaWinesJapan]
[first_name] => <snipped>
[discount] => 0
[mc_shipping] => 0
[mc_currency] => JPY
[payer_status] => unverified
[shipping_discount] => 0
[payment_fee] =>
[option_name4_1] =>
[address_status] => confirmed
[payment_gross] =>
[address_zip] => <snipped>
[address_country_code] => JP
[mc_handling] => 0
[num_cart_items] => 5
[txn_type] => cart
[verify_sign] => <snipped>
[payer_id] => <snipped>
[option_selection2_1] =>
[charset] => windows-1252
[auth_id] => 1****************
[transaction_entity] => payment
[tax1] => 0
[receiver_id] => <snipped>
[tax2] => 0
[tax3] => 0
[tax4] => 0
[tax5] => 0
[mc_handling1] => 0
[mc_handling2] => 0
[option_name3_1] =>
[mc_handling3] => 0
[mc_handling4] => 0
[mc_handling5] => 0
[tax] => 7100
[item_name1] => <snipped>
[item_name2] => <snipped>
[item_name3] => <snipped>
[item_name4] => <snipped>
[payment_type] => instant
[item_name5] => <snipped>
[option_selection5_1] =>
[address_street] => <snipped>
[mc_shipping1] => 0
[mc_shipping2] => 0
[mc_shipping3] => 0
[txn_id] => 5****************
[mc_shipping4] => 0
[mc_shipping5] => 0
[mc_gross_1] => <snipped>
[quantity1] => 1
[mc_gross_2] => <snipped>
[quantity2] => 1
[item_number1] => <snipped>
[protection_eligibility] => Eligible
[mc_gross_3] => <snipped>
[quantity3] => 1
[item_number2] => <snipped>
[mc_gross_4] => <snipped>
[quantity4] => 1
[item_number3] => <snipped>
[custom] => EC-**-**********
[mc_gross_5] => <snipped>
[quantity5] => 1
[item_number4] => <snipped>
[option_selection1_1] =>
[item_number5] => <snipped>
[business] => <snipped>
[residence_country] => JP
[last_name] => <snipped>
[address_state] => <snipped>
[payer_email] => <snipped>
[option_name2_1] =>
[auth_exp] => 19:46:42 Jun 19, 2021 PDT
[address_city] => <snipped>
[option_selection4_1] =>
[payment_status] => Completed
[payment_date] => 21:52:54 May 21, 2021 PDT
[parent_txn_id] => 1****************
[transaction_subject] =>
[receiver_email] => <snipped>
[mc_fee] => 2852
[notify_version] => 3.9
[remaining_settle] => 0
[option_name5_1] =>
[shipping_method] => Default
[auth_status] => Completed
[address_country] => Japan
[mc_gross] => <snipped>
[insurance_amount] => 0
[address_name] => <snipped>
[option_name1_1] =>
[memo] => Thank you for your order.
[auth_amount] => <snipped>
[ipn_track_id] => <snipped>
)
May 24 2021 11:25 -- CURL OPTS: Array
(
[10002] =>
https://ipnpb.paypal.com/cgi-bin/webscr
[47] => 1
[10015] => cmd=_notify-validate&option_selection3_1=&invoice=49-1621651601-%5BProteaWinesJapan%5D&first_name=<snipped>&discount=0&mc_shipping=0&mc_currency =JPY&payer_status=unverified&shipping_discount=0&payment_fee=&option_name4_1=&ad dress_status=confirmed&payment_gross=&address_zip=<snipped>&address_country_code =JP&mc_handling=0&num_cart_items=5&txn_type=cart&verify_sign=<snipped>&payer_id= <snipped>&option_selection2_1=&charset=windows-1252&auth_id=1****************&transaction_entity=payment&tax1=0&receiver_id=<sn ipped>=0&tax3=0&tax4=0&tax5=0&mc_handling1=0&mc_handling2=0&option_name3_1=&mc_h andling3=0&mc_handling4=0&mc_handling5=0&tax=<snipped>&item_name1=<snipped>&item _name2=<snipped>&item_name3=<snipped>&item_name4=<snipped>&payment_type=instant& item_name5=<snipped>&option_selection5_1=&address_street=<snipped>&mc_shipping1= 0&mc_shipping2=0&mc_shipping3=0&txn_id=5****************&mc_shipping4=0&mc_shipp ing5=0&mc_gross_1=<snipped>&quantity1=1&mc_gross_2=<snipped>&quantity2=1&item_nu mber1=<snipped>&protection_eligibility=Eligible&mc_gross_3=<snipped>&quantity3=1 &item_number2=<snipped>&mc_gross_4=<snipped>&quantity4=1&item_number3=<snipped>& custom=EC-**-**********&mc_gross_5=<snipped>&quantity5=1&item_number4=<snipped>&option_select ion1_1=&item_number5=<snipped>&business=<snipped>&residence_country=JP&last_name =<snipped>&address_state=<snipped>&payer_email=<snipped>&option_name2_1=&auth_ex p=19%3A46%3A42+Jun+19%2C+2021+PDT&address_city=<snipped>&option_selection4_1=&pa yment_status=Completed&payment_date=21%3A52%3A54+May+21%2C+2021+PDT&parent_txn_i d=1****************&transaction_subject=&receiver_email=<snipped>&mc_fee=<snippe d>¬ify_version=3.9&remaining_settle=0&option_name5_1=&shipping_method=Default &auth_status=Completed&address_country=Japan&mc_gross=<snipped>&insurance_amount =0&address_name=<snipped>&option_name1_1=&memo=Thank+you+for+your+order.&auth_am ount=<snipped>&ipn_track_id=<snipped>
[13] => 45
[78] => 30
[41] =>
[42] =>
[52] =>
[19913] => 1
[75] => 1
[74] => 1
[84] => 2
[10018] => Zen Cart(R) - IPN Postback
)
May 24 2021 11:25 -- CURL response: VERIFIED
May 24 2021 11:25 -- IPN INFO (cl) - Confirmation/Validation response VERIFIED
May 24 2021 11:25 -- Breakpoint: 1 - Collected data from PayPal notification
May 24 2021 11:25 -- Breakpoint: 2 - Validated transaction components
May 24 2021 11:25 -- Breakpoint: 3 - Communication method verified
May 24 2021 11:25 -- IPN NOTICE :: This transaction HAS a parent record. Thus this is an update of some sort.
May 24 2021 11:25 -- Breakpoint: 4 - Details: txn_type=parent ordersID = 125 IPN_id=**
Relevant data from POST:
txn_type = parent
parent_txn_id = 1****************
txn_id = 5****************
May 24 2021 11:25 -- Breakpoint: 5 - Transaction type (txn_type) = cleared-authorization [parentLookup=parent]
May 24 2021 11:25 -- IPN NOTICE :: Storing order/update details for order #125 txn_id: 5**************** PP IPN ID: **
[24-May-2021 11:25:16 Asia/Tokyo] Request URI: /shop/ipn_main_handler.php, IP address: 173.0.81.65
#1 trigger_error() called at [/<snipped>/shop/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/<snipped>/shop/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/<snipped>/shop/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/<snipped>/shop/includes/functions/functions_general.php:952]
#5 zen_db_perform() called at [/<snipped>/shop/ipn_main_handler.php:439]
--> PHP Fatal error: 1366:Incorrect integer value: '' for column `zencartshop`.`paypal_payment_status_history`.`paypal_ipn_id` at row 1 :: INSERT INTO paypal_payment_status_history (paypal_ipn_id, txn_id, parent_txn_id, payment_status, pending_reason, date_added) VALUES ('', '5****************', '1****************', 'Completed', '', now()) ==> (as called by) /<snipped>/shop/includes/functions/functions_general.php on line 952 <== in /<snipped>/shop/includes/classes/db/mysql/query_factory.php on line 171.
