[2026-05-29 10:37:36] local.INFO: Received PayPal webhook {"payload":{"id":"WH-45569669N9079453V-9W867261GP328525G","event_version":"1.0","create_time":"2026-05-29T10:37:27.576Z","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-29T10:37:23Z","custom":"605","transaction_fee":{"currency":"AUD","value":"9.90"},"billing_agreement_id":"I-P0VYJ2VD2M9A","update_time":"2026-05-29T10:37:23Z","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/9NB26271GB4356507"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/9NB26271GB4356507/refund"}],"id":"9NB26271GB4356507","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-45569669N9079453V-9W867261GP328525G","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-45569669N9079453V-9W867261GP328525G/resend","rel":"resend","method":"POST"}]}} 
[2026-05-29 10:37:37] 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-45569669N9079453V-9W867261GP328525G, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"400.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"400.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-05-29T10:37:23Z\",\"custom\":\"605\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"9.90\"},\"billing_agreement_id\":\"I-P0VYJ2VD2M9A\",\"update_time\":\"2026-05-29T10:37:23Z\",\"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\\/9NB26271GB4356507\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/9NB26271GB4356507\\/refund\"}],\"id\":\"9NB26271GB4356507\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.116, AUD, 605, 2026-05-29 10:37:37, 2026-05-29 10:37:37))"} 
[2026-05-29 11:47:36] local.INFO: Received PayPal webhook {"payload":{"id":"WH-5UR24635SA855033N-10L064188V6224709","event_version":"1.0","create_time":"2026-05-29T11:47:27.797Z","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-29T11:47:24Z","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-29T11:47:24Z","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/34G64820GP5481430"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/34G64820GP5481430/refund"}],"id":"34G64820GP5481430","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-5UR24635SA855033N-10L064188V6224709","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-5UR24635SA855033N-10L064188V6224709/resend","rel":"resend","method":"POST"}]}} 
[2026-05-29 11:47:37] local.ERROR: Donation not found for subscription {"subscription_id":"I-9XLX24MPCD35","donation_id":"189"} 
[2026-05-29 12:48:51] local.INFO: Received PayPal webhook {"payload":{"id":"WH-46888392089322632-34036070LB3173243","event_version":"1.0","create_time":"2026-05-29T12:48:44.130Z","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-29T12:48:40Z","custom":"603","transaction_fee":{"currency":"AUD","value":"0.59"},"billing_agreement_id":"I-38NA7F83PMDY","update_time":"2026-05-29T12:48:40Z","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/0PS49612J9063234M"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/0PS49612J9063234M/refund"}],"id":"0PS49612J9063234M","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-46888392089322632-34036070LB3173243","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-46888392089322632-34036070LB3173243/resend","rel":"resend","method":"POST"}]}} 
[2026-05-29 12:48:52] 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-46888392089322632-34036070LB3173243, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"12.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"12.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-05-29T12:48:40Z\",\"custom\":\"603\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"0.59\"},\"billing_agreement_id\":\"I-38NA7F83PMDY\",\"update_time\":\"2026-05-29T12:48:40Z\",\"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\\/0PS49612J9063234M\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/0PS49612J9063234M\\/refund\"}],\"id\":\"0PS49612J9063234M\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.117, AUD, 603, 2026-05-29 12:48:52, 2026-05-29 12:48:52))"} 
[2026-05-29 13:45:59] local.INFO: Received PayPal webhook {"payload":{"id":"WH-0GD312749V1325221-9JH45944MP6759308","event_version":"1.0","create_time":"2026-05-29T13:45:48.277Z","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-29T13:45:43Z","custom":"629","transaction_fee":{"currency":"AUD","value":"5.10"},"billing_agreement_id":"I-WCJSX2BW2HWY","update_time":"2026-05-29T13:45:43Z","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/86U55227SV1292911"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/86U55227SV1292911/refund"}],"id":"86U55227SV1292911","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-0GD312749V1325221-9JH45944MP6759308","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-0GD312749V1325221-9JH45944MP6759308/resend","rel":"resend","method":"POST"}]}} 
[2026-05-29 13:46:00] 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-0GD312749V1325221-9JH45944MP6759308, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"200.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"200.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-05-29T13:45:43Z\",\"custom\":\"629\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"5.10\"},\"billing_agreement_id\":\"I-WCJSX2BW2HWY\",\"update_time\":\"2026-05-29T13:45:43Z\",\"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\\/86U55227SV1292911\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/86U55227SV1292911\\/refund\"}],\"id\":\"86U55227SV1292911\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.117, AUD, 629, 2026-05-29 13:46:00, 2026-05-29 13:46:00))"} 
[2026-05-29 15:05:39] local.INFO: Received PayPal webhook {"payload":{"id":"WH-80N4615596549215R-5M342018E0297180D","event_version":"1.0","create_time":"2026-05-29T15:05:26.135Z","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-29T15:05:21Z","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-29T15:05:21Z","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/8H920913875216044"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/8H920913875216044/refund"}],"id":"8H920913875216044","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-80N4615596549215R-5M342018E0297180D","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-80N4615596549215R-5M342018E0297180D/resend","rel":"resend","method":"POST"}]}} 
[2026-05-29 15:05:40] local.ERROR: Donation not found for subscription {"subscription_id":"I-FD7D1HANN2TA","donation_id":"185"}