[2026-09-27 10:44:28] local.INFO: Received PayPal webhook {"payload":{"id":"WH-07U003279M388723E-6Y046716N07910941","event_version":"1.0","create_time":"2026-09-27T10:44:19.767Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for $ 50.0 USD","resource":{"id":"72N912735F475672Y","state":"completed","amount":{"total":"50.00","currency":"USD","details":{"subtotal":"50.00"}},"payment_mode":"INSTANT_TRANSFER","protection_eligibility":"ELIGIBLE","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","transaction_fee":{"value":"1.50","currency":"USD"},"receivable_amount":{"value":"65.37","currency":"AUD"},"exchange_rate":"1.3478117958825","invoice_number":"","custom":"185","billing_agreement_id":"I-FD7D1HANN2TA","create_time":"2026-09-27T10:44:09Z","update_time":"2026-09-27T10:44:09Z","links":[{"href":"https://api.sandbox.paypal.com/v1/payments/sale/72N912735F475672Y","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/payments/sale/72N912735F475672Y/refund","rel":"refund","method":"POST"}]},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-07U003279M388723E-6Y046716N07910941","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-07U003279M388723E-6Y046716N07910941/resend","rel":"resend","method":"POST"}]}} 
[2026-09-27 10:44:29] local.ERROR: Donation not found for subscription {"subscription_id":"I-FD7D1HANN2TA","donation_id":"185"} 
[2026-09-27 11:20:58] local.INFO: Received PayPal webhook {"payload":{"id":"WH-0UE39002YL458353D-5KX953246D910520F","event_version":"1.0","create_time":"2026-09-27T11:20:44.122Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for A$ 200.0 AUD","resource":{"id":"0D6909271P292044P","state":"completed","amount":{"total":"200.00","currency":"AUD","details":{"subtotal":"200.00"}},"payment_mode":"INSTANT_TRANSFER","protection_eligibility":"ELIGIBLE","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","transaction_fee":{"value":"5.10","currency":"AUD"},"invoice_number":"","custom":"629","billing_agreement_id":"I-WCJSX2BW2HWY","create_time":"2026-09-27T11:20:39Z","update_time":"2026-09-27T11:20:39Z","links":[{"href":"https://api.sandbox.paypal.com/v1/payments/sale/0D6909271P292044P","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/payments/sale/0D6909271P292044P/refund","rel":"refund","method":"POST"}]},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-0UE39002YL458353D-5KX953246D910520F","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-0UE39002YL458353D-5KX953246D910520F/resend","rel":"resend","method":"POST"}]}} 
[2026-09-27 11:20:59] 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-0UE39002YL458353D-5KX953246D910520F, paypal, completed, AUD, AUD, ?, ?, card, {\"id\":\"0D6909271P292044P\",\"state\":\"completed\",\"amount\":{\"total\":\"200.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"200.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"protection_eligibility\":\"ELIGIBLE\",\"protection_eligibility_type\":\"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\"transaction_fee\":{\"value\":\"5.10\",\"currency\":\"AUD\"},\"invoice_number\":\"\",\"custom\":\"629\",\"billing_agreement_id\":\"I-WCJSX2BW2HWY\",\"create_time\":\"2026-09-27T11:20:39Z\",\"update_time\":\"2026-09-27T11:20:39Z\",\"links\":[{\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/0D6909271P292044P\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/0D6909271P292044P\\/refund\",\"rel\":\"refund\",\"method\":\"POST\"}]}, 173.0.80.116, AUD, 629, 2026-09-27 11:20:59, 2026-09-27 11:20:59))"} 
[2026-09-27 12:42:20] local.INFO: Received PayPal webhook {"payload":{"id":"WH-717437372K714064U-6AA06961WG751672E","event_version":"1.0","create_time":"2026-09-27T12:42:06.549Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for $ 50.0 USD","resource":{"id":"4K0512012A022543S","state":"completed","amount":{"total":"50.00","currency":"USD","details":{"subtotal":"50.00"}},"payment_mode":"INSTANT_TRANSFER","protection_eligibility":"ELIGIBLE","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","transaction_fee":{"value":"1.50","currency":"USD"},"receivable_amount":{"value":"65.37","currency":"AUD"},"exchange_rate":"1.3478117958825","invoice_number":"","custom":"189","billing_agreement_id":"I-9XLX24MPCD35","create_time":"2026-09-27T12:42:02Z","update_time":"2026-09-27T12:42:02Z","links":[{"href":"https://api.sandbox.paypal.com/v1/payments/sale/4K0512012A022543S","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/payments/sale/4K0512012A022543S/refund","rel":"refund","method":"POST"}]},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-717437372K714064U-6AA06961WG751672E","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-717437372K714064U-6AA06961WG751672E/resend","rel":"resend","method":"POST"}]}} 
[2026-09-27 12:42:21] local.ERROR: Donation not found for subscription {"subscription_id":"I-9XLX24MPCD35","donation_id":"189"}