[2026-07-28 10:17:46] local.INFO: Received PayPal webhook {"payload":{"id":"WH-2EA82056UR943115H-3YE03500E75712540","event_version":"1.0","create_time":"2026-07-28T10:17:38.939Z","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-07-28T10:17:34Z","custom":"605","transaction_fee":{"currency":"AUD","value":"9.90"},"billing_agreement_id":"I-P0VYJ2VD2M9A","update_time":"2026-07-28T10:17:34Z","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/8X308892A9845102T"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/8X308892A9845102T/refund"}],"id":"8X308892A9845102T","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-2EA82056UR943115H-3YE03500E75712540","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-2EA82056UR943115H-3YE03500E75712540/resend","rel":"resend","method":"POST"}]}} 
[2026-07-28 10:17:47] 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-2EA82056UR943115H-3YE03500E75712540, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"400.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"400.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-07-28T10:17:34Z\",\"custom\":\"605\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"9.90\"},\"billing_agreement_id\":\"I-P0VYJ2VD2M9A\",\"update_time\":\"2026-07-28T10:17:34Z\",\"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\\/8X308892A9845102T\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/8X308892A9845102T\\/refund\"}],\"id\":\"8X308892A9845102T\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.117, AUD, 605, 2026-07-28 10:17:47, 2026-07-28 10:17:47))"} 
[2026-07-28 11:51:07] local.INFO: Received PayPal webhook {"payload":{"id":"WH-9H451249D01362831-5ET10361FL113111K","event_version":"1.0","create_time":"2026-07-28T11:50:58.604Z","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.41060002772","create_time":"2026-07-28T11:50:54Z","custom":"156","transaction_fee":{"currency":"USD","value":"1.50"},"receivable_amount":{"currency":"AUD","value":"68.41"},"billing_agreement_id":"I-WB3MSK1D41AE","update_time":"2026-07-28T11:50:54Z","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/9PV58224GX978100T"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/9PV58224GX978100T/refund"}],"id":"9PV58224GX978100T","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-9H451249D01362831-5ET10361FL113111K","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-9H451249D01362831-5ET10361FL113111K/resend","rel":"resend","method":"POST"}]}} 
[2026-07-28 11:51:08] local.ERROR: Donation not found for subscription {"subscription_id":"I-WB3MSK1D41AE","donation_id":"156"}