[2026-05-28 10:22:08] local.INFO: Received PayPal webhook {"payload":{"id":"WH-2NL16508CF791552E-18398984U0909364M","event_version":"1.0","create_time":"2026-05-28T10:21:50.265Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for $ 50.0 USD","resource":{"amount":{"total":"50.00","currency":"USD","details":{"subtotal":"50.00"}},"payment_mode":"INSTANT_TRANSFER","exchange_rate":"1.343454752097562","create_time":"2026-05-28T10:21:45Z","custom":"158","transaction_fee":{"currency":"USD","value":"1.50"},"receivable_amount":{"currency":"AUD","value":"65.16"},"billing_agreement_id":"I-DB3NUS9GWB3T","update_time":"2026-05-28T10:21:45Z","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","protection_eligibility":"ELIGIBLE","links":[{"method":"GET","rel":"self","href":"https://api.sandbox.paypal.com/v1/payments/sale/9GW57268YG831102A"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/9GW57268YG831102A/refund"}],"id":"9GW57268YG831102A","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-2NL16508CF791552E-18398984U0909364M","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-2NL16508CF791552E-18398984U0909364M/resend","rel":"resend","method":"POST"}]}} 
[2026-05-28 10:22:09] local.ERROR: Donation not found for subscription {"subscription_id":"I-DB3NUS9GWB3T","donation_id":"158"} 
[2026-05-28 10:29:29] local.INFO: Received PayPal webhook {"payload":{"id":"WH-0SH57954PE241925Y-7HJ85852U2955202N","event_version":"1.0","create_time":"2026-05-28T10:29:12.535Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for A$ 400.0 AUD","resource":{"amount":{"total":"400.00","currency":"AUD","details":{"subtotal":"400.00"}},"payment_mode":"INSTANT_TRANSFER","create_time":"2026-05-28T10:29:08Z","custom":"605","transaction_fee":{"currency":"AUD","value":"9.90"},"billing_agreement_id":"I-P0VYJ2VD2M9A","update_time":"2026-05-28T10:29:08Z","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","protection_eligibility":"ELIGIBLE","links":[{"method":"GET","rel":"self","href":"https://api.sandbox.paypal.com/v1/payments/sale/1TL63936SU3686347"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/1TL63936SU3686347/refund"}],"id":"1TL63936SU3686347","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-0SH57954PE241925Y-7HJ85852U2955202N","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-0SH57954PE241925Y-7HJ85852U2955202N/resend","rel":"resend","method":"POST"}]}} 
[2026-05-28 10:29:31] local.ERROR: Error handling PayPal webhook {"error":"SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect decimal value: 'AUD' for column `apipixel_hasanat_be`.`transactions`.`amount` at row 1 (Connection: mysql, SQL: insert into `transactions` (`transaction_id`, `payment_gateway`, `status`, `amount`, `currency`, `payer_id`, `payer_email`, `payment_method_type`, `gateway_response`, `ip_address`, `net_amount`, `donation_id`, `updated_at`, `created_at`) values (WH-0SH57954PE241925Y-7HJ85852U2955202N, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"400.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"400.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-05-28T10:29:08Z\",\"custom\":\"605\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"9.90\"},\"billing_agreement_id\":\"I-P0VYJ2VD2M9A\",\"update_time\":\"2026-05-28T10:29:08Z\",\"protection_eligibility_type\":\"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\"protection_eligibility\":\"ELIGIBLE\",\"links\":[{\"method\":\"GET\",\"rel\":\"self\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/1TL63936SU3686347\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/1TL63936SU3686347\\/refund\"}],\"id\":\"1TL63936SU3686347\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.117, AUD, 605, 2026-05-28 10:29:31, 2026-05-28 10:29:31))"} 
[2026-05-28 10:36:10] local.INFO: Received PayPal webhook {"payload":{"id":"WH-84L67773U42024149-5TK78545AX176060J","event_version":"1.0","create_time":"2026-05-28T10:35:56.639Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for $ 50.0 USD","resource":{"amount":{"total":"50.00","currency":"USD","details":{"subtotal":"50.00"}},"payment_mode":"INSTANT_TRANSFER","exchange_rate":"1.343454752097562","create_time":"2026-05-28T10:35:31Z","custom":"156","transaction_fee":{"currency":"USD","value":"1.50"},"receivable_amount":{"currency":"AUD","value":"65.16"},"billing_agreement_id":"I-WB3MSK1D41AE","update_time":"2026-05-28T10:35:31Z","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","protection_eligibility":"ELIGIBLE","links":[{"method":"GET","rel":"self","href":"https://api.sandbox.paypal.com/v1/payments/sale/03321757YD2811523"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/03321757YD2811523/refund"}],"id":"03321757YD2811523","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-84L67773U42024149-5TK78545AX176060J","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-84L67773U42024149-5TK78545AX176060J/resend","rel":"resend","method":"POST"}]}} 
[2026-05-28 10:36:10] local.ERROR: Donation not found for subscription {"subscription_id":"I-WB3MSK1D41AE","donation_id":"156"} 
[2026-05-28 10:36:28] local.INFO: Received PayPal webhook {"payload":{"id":"WH-47X23787HV666832Y-25458196B7796835X","event_version":"1.0","create_time":"2026-05-28T10:36:11.239Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for $ 50.0 USD","resource":{"amount":{"total":"50.00","currency":"USD","details":{"subtotal":"50.00"}},"payment_mode":"INSTANT_TRANSFER","exchange_rate":"1.343454752097562","create_time":"2026-05-28T10:36:07Z","custom":"155","transaction_fee":{"currency":"USD","value":"1.50"},"receivable_amount":{"currency":"AUD","value":"65.16"},"billing_agreement_id":"I-7C9SWP99CJ3M","update_time":"2026-05-28T10:36:07Z","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","protection_eligibility":"ELIGIBLE","links":[{"method":"GET","rel":"self","href":"https://api.sandbox.paypal.com/v1/payments/sale/4T940126P32165145"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/4T940126P32165145/refund"}],"id":"4T940126P32165145","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-47X23787HV666832Y-25458196B7796835X","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-47X23787HV666832Y-25458196B7796835X/resend","rel":"resend","method":"POST"}]}} 
[2026-05-28 10:36:30] local.ERROR: Donation not found for subscription {"subscription_id":"I-7C9SWP99CJ3M","donation_id":"155"} 
[2026-05-28 11:03:17] local.INFO: Received PayPal webhook {"payload":{"id":"WH-7WW57116AU113552M-3JY17507B66977402","event_version":"1.0","create_time":"2026-05-28T11:03:02.259Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for $ 50.0 USD","resource":{"amount":{"total":"50.00","currency":"USD","details":{"subtotal":"50.00"}},"payment_mode":"INSTANT_TRANSFER","exchange_rate":"1.343454752097562","create_time":"2026-05-28T11:02:57Z","custom":"185","transaction_fee":{"currency":"USD","value":"1.50"},"receivable_amount":{"currency":"AUD","value":"65.16"},"billing_agreement_id":"I-FD7D1HANN2TA","update_time":"2026-05-28T11:02:57Z","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","protection_eligibility":"ELIGIBLE","links":[{"method":"GET","rel":"self","href":"https://api.sandbox.paypal.com/v1/payments/sale/12Y816250R4836203"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/12Y816250R4836203/refund"}],"id":"12Y816250R4836203","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-7WW57116AU113552M-3JY17507B66977402","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-7WW57116AU113552M-3JY17507B66977402/resend","rel":"resend","method":"POST"}]}} 
[2026-05-28 11:03:19] local.ERROR: Donation not found for subscription {"subscription_id":"I-FD7D1HANN2TA","donation_id":"185"} 
[2026-05-28 11:54:08] local.INFO: Received PayPal webhook {"payload":{"id":"WH-7BY085105R0088727-0L478182J4296253G","event_version":"1.0","create_time":"2026-05-28T11:53:52.023Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for A$ 200.0 AUD","resource":{"amount":{"total":"200.00","currency":"AUD","details":{"subtotal":"200.00"}},"payment_mode":"INSTANT_TRANSFER","create_time":"2026-05-28T11:53:11Z","custom":"629","transaction_fee":{"currency":"AUD","value":"5.10"},"billing_agreement_id":"I-WCJSX2BW2HWY","update_time":"2026-05-28T11:53:11Z","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","protection_eligibility":"ELIGIBLE","links":[{"method":"GET","rel":"self","href":"https://api.sandbox.paypal.com/v1/payments/sale/6H9065348H212060D"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/6H9065348H212060D/refund"}],"id":"6H9065348H212060D","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-7BY085105R0088727-0L478182J4296253G","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-7BY085105R0088727-0L478182J4296253G/resend","rel":"resend","method":"POST"}]}} 
[2026-05-28 11:54:09] local.ERROR: Error handling PayPal webhook {"error":"SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect decimal value: 'AUD' for column `apipixel_hasanat_be`.`transactions`.`amount` at row 1 (Connection: mysql, SQL: insert into `transactions` (`transaction_id`, `payment_gateway`, `status`, `amount`, `currency`, `payer_id`, `payer_email`, `payment_method_type`, `gateway_response`, `ip_address`, `net_amount`, `donation_id`, `updated_at`, `created_at`) values (WH-7BY085105R0088727-0L478182J4296253G, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"200.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"200.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-05-28T11:53:11Z\",\"custom\":\"629\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"5.10\"},\"billing_agreement_id\":\"I-WCJSX2BW2HWY\",\"update_time\":\"2026-05-28T11:53:11Z\",\"protection_eligibility_type\":\"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\"protection_eligibility\":\"ELIGIBLE\",\"links\":[{\"method\":\"GET\",\"rel\":\"self\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/6H9065348H212060D\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/6H9065348H212060D\\/refund\"}],\"id\":\"6H9065348H212060D\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.116, AUD, 629, 2026-05-28 11:54:09, 2026-05-28 11:54:09))"} 
[2026-05-28 13:13:07] local.INFO: Received PayPal webhook {"payload":{"id":"WH-01073297CN5284613-7JC32217AJ7571916","event_version":"1.0","create_time":"2026-05-28T13:12:52.306Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for A$ 12.0 AUD","resource":{"amount":{"total":"12.00","currency":"AUD","details":{"subtotal":"12.00"}},"payment_mode":"INSTANT_TRANSFER","create_time":"2026-05-28T13:12:47Z","custom":"603","transaction_fee":{"currency":"AUD","value":"0.59"},"billing_agreement_id":"I-38NA7F83PMDY","update_time":"2026-05-28T13:12:47Z","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","protection_eligibility":"ELIGIBLE","links":[{"method":"GET","rel":"self","href":"https://api.sandbox.paypal.com/v1/payments/sale/3B625953M93207452"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/3B625953M93207452/refund"}],"id":"3B625953M93207452","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-01073297CN5284613-7JC32217AJ7571916","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-01073297CN5284613-7JC32217AJ7571916/resend","rel":"resend","method":"POST"}]}} 
[2026-05-28 13:13:08] local.ERROR: Error handling PayPal webhook {"error":"SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect decimal value: 'AUD' for column `apipixel_hasanat_be`.`transactions`.`amount` at row 1 (Connection: mysql, SQL: insert into `transactions` (`transaction_id`, `payment_gateway`, `status`, `amount`, `currency`, `payer_id`, `payer_email`, `payment_method_type`, `gateway_response`, `ip_address`, `net_amount`, `donation_id`, `updated_at`, `created_at`) values (WH-01073297CN5284613-7JC32217AJ7571916, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"12.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"12.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-05-28T13:12:47Z\",\"custom\":\"603\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"0.59\"},\"billing_agreement_id\":\"I-38NA7F83PMDY\",\"update_time\":\"2026-05-28T13:12:47Z\",\"protection_eligibility_type\":\"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\"protection_eligibility\":\"ELIGIBLE\",\"links\":[{\"method\":\"GET\",\"rel\":\"self\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/3B625953M93207452\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/3B625953M93207452\\/refund\"}],\"id\":\"3B625953M93207452\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.116, AUD, 603, 2026-05-28 13:13:08, 2026-05-28 13:13:08))"} 
[2026-05-28 15:14:49] local.INFO: Received PayPal webhook {"payload":{"id":"WH-83P807406V407713V-0AD369015R366301P","event_version":"1.0","create_time":"2026-05-28T15:14:32.348Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for $ 50.0 USD","resource":{"amount":{"total":"50.00","currency":"USD","details":{"subtotal":"50.00"}},"payment_mode":"INSTANT_TRANSFER","exchange_rate":"1.343454752097562","create_time":"2026-05-28T15:14:28Z","custom":"189","transaction_fee":{"currency":"USD","value":"1.50"},"receivable_amount":{"currency":"AUD","value":"65.16"},"billing_agreement_id":"I-9XLX24MPCD35","update_time":"2026-05-28T15:14:28Z","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","protection_eligibility":"ELIGIBLE","links":[{"method":"GET","rel":"self","href":"https://api.sandbox.paypal.com/v1/payments/sale/9YS91904TV576710V"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/9YS91904TV576710V/refund"}],"id":"9YS91904TV576710V","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-83P807406V407713V-0AD369015R366301P","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-83P807406V407713V-0AD369015R366301P/resend","rel":"resend","method":"POST"}]}} 
[2026-05-28 15:14:50] local.ERROR: Donation not found for subscription {"subscription_id":"I-9XLX24MPCD35","donation_id":"189"}