[2026-07-26 11:33:49] local.INFO: Received PayPal webhook {"payload":{"id":"WH-7GA22460N8527683S-9HD51410WR727533Y","event_version":"1.0","create_time":"2026-07-26T11:33:30.491Z","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-26T11:33:25Z","custom":"185","transaction_fee":{"currency":"USD","value":"1.50"},"receivable_amount":{"currency":"AUD","value":"68.41"},"billing_agreement_id":"I-FD7D1HANN2TA","update_time":"2026-07-26T11:33:25Z","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/7F9268244B317284X"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/7F9268244B317284X/refund"}],"id":"7F9268244B317284X","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-7GA22460N8527683S-9HD51410WR727533Y","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-7GA22460N8527683S-9HD51410WR727533Y/resend","rel":"resend","method":"POST"}]}} 
[2026-07-26 11:33:51] local.ERROR: Donation not found for subscription {"subscription_id":"I-FD7D1HANN2TA","donation_id":"185"} 
[2026-07-26 11:47:28] local.INFO: Received PayPal webhook {"payload":{"id":"WH-7W860184VH489893V-77R1937926345023J","event_version":"1.0","create_time":"2026-07-26T11:47:14.782Z","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-07-26T11:47:10Z","custom":"629","transaction_fee":{"currency":"AUD","value":"5.10"},"billing_agreement_id":"I-WCJSX2BW2HWY","update_time":"2026-07-26T11:47:10Z","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/7YM01736A3675035D"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/7YM01736A3675035D/refund"}],"id":"7YM01736A3675035D","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-7W860184VH489893V-77R1937926345023J","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-7W860184VH489893V-77R1937926345023J/resend","rel":"resend","method":"POST"}]}} 
[2026-07-26 11:47:30] 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-7W860184VH489893V-77R1937926345023J, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"200.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"200.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-07-26T11:47:10Z\",\"custom\":\"629\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"5.10\"},\"billing_agreement_id\":\"I-WCJSX2BW2HWY\",\"update_time\":\"2026-07-26T11:47:10Z\",\"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\\/7YM01736A3675035D\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/7YM01736A3675035D\\/refund\"}],\"id\":\"7YM01736A3675035D\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.117, AUD, 629, 2026-07-26 11:47:30, 2026-07-26 11:47:30))"} 
[2026-07-26 11:47:31] local.INFO: Received PayPal webhook {"payload":{"id":"WH-4UA31297MK3990529-2H948779U8394140R","event_version":"1.0","create_time":"2026-07-26T11:47:13.320Z","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-07-26T11:46:18Z","custom":"603","transaction_fee":{"currency":"AUD","value":"0.59"},"billing_agreement_id":"I-38NA7F83PMDY","update_time":"2026-07-26T11:46:18Z","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/8EF39680P8702610E"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/8EF39680P8702610E/refund"}],"id":"8EF39680P8702610E","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-4UA31297MK3990529-2H948779U8394140R","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-4UA31297MK3990529-2H948779U8394140R/resend","rel":"resend","method":"POST"}]}} 
[2026-07-26 11:47:32] 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-4UA31297MK3990529-2H948779U8394140R, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"12.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"12.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-07-26T11:46:18Z\",\"custom\":\"603\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"0.59\"},\"billing_agreement_id\":\"I-38NA7F83PMDY\",\"update_time\":\"2026-07-26T11:46:18Z\",\"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\\/8EF39680P8702610E\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/8EF39680P8702610E\\/refund\"}],\"id\":\"8EF39680P8702610E\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.116, AUD, 603, 2026-07-26 11:47:32, 2026-07-26 11:47:32))"} 
[2026-07-26 12:15:48] local.INFO: Received PayPal webhook {"payload":{"id":"WH-74J680756M497480B-9TV22919XS366332E","event_version":"1.0","create_time":"2026-07-26T12:15:39.917Z","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-26T12:15:32Z","custom":"605","transaction_fee":{"currency":"AUD","value":"9.90"},"billing_agreement_id":"I-P0VYJ2VD2M9A","update_time":"2026-07-26T12:15:32Z","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/688534251J8286331"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/688534251J8286331/refund"}],"id":"688534251J8286331","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-74J680756M497480B-9TV22919XS366332E","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-74J680756M497480B-9TV22919XS366332E/resend","rel":"resend","method":"POST"}]}} 
[2026-07-26 12:15:50] 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-74J680756M497480B-9TV22919XS366332E, paypal, completed, AUD, AUD, ?, ?, card, {\"amount\":{\"total\":\"400.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"400.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"create_time\":\"2026-07-26T12:15:32Z\",\"custom\":\"605\",\"transaction_fee\":{\"currency\":\"AUD\",\"value\":\"9.90\"},\"billing_agreement_id\":\"I-P0VYJ2VD2M9A\",\"update_time\":\"2026-07-26T12:15:32Z\",\"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\\/688534251J8286331\"},{\"method\":\"POST\",\"rel\":\"refund\",\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/688534251J8286331\\/refund\"}],\"id\":\"688534251J8286331\",\"state\":\"completed\",\"invoice_number\":\"\"}, 173.0.80.117, AUD, 605, 2026-07-26 12:15:50, 2026-07-26 12:15:50))"} 
[2026-07-26 13:44:25] local.INFO: Received PayPal webhook {"payload":{"id":"WH-8BC81818VJ845930F-365162300Y110054S","event_version":"1.0","create_time":"2026-07-26T13:44:16.998Z","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-26T13:44:13Z","custom":"189","transaction_fee":{"currency":"USD","value":"1.50"},"receivable_amount":{"currency":"AUD","value":"68.41"},"billing_agreement_id":"I-9XLX24MPCD35","update_time":"2026-07-26T13:44:13Z","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/2BH74975JS163204U"},{"method":"POST","rel":"refund","href":"https://api.sandbox.paypal.com/v1/payments/sale/2BH74975JS163204U/refund"}],"id":"2BH74975JS163204U","state":"completed","invoice_number":""},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-8BC81818VJ845930F-365162300Y110054S","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-8BC81818VJ845930F-365162300Y110054S/resend","rel":"resend","method":"POST"}]}} 
[2026-07-26 13:44:26] local.ERROR: Donation not found for subscription {"subscription_id":"I-9XLX24MPCD35","donation_id":"189"}