[2026-09-26 12:52:39] local.INFO: Received PayPal webhook {"payload":{"id":"WH-1GD61280EY018362Y-0G9100684M081802N","event_version":"1.0","create_time":"2026-09-26T12:52:23.781Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for A$ 400.0 AUD","resource":{"id":"4C698343VJ8399421","state":"completed","amount":{"total":"400.00","currency":"AUD","details":{"subtotal":"400.00"}},"payment_mode":"INSTANT_TRANSFER","protection_eligibility":"ELIGIBLE","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","transaction_fee":{"value":"9.90","currency":"AUD"},"invoice_number":"","custom":"605","billing_agreement_id":"I-P0VYJ2VD2M9A","create_time":"2026-09-26T12:52:19Z","update_time":"2026-09-26T12:52:19Z","links":[{"href":"https://api.sandbox.paypal.com/v1/payments/sale/4C698343VJ8399421","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/payments/sale/4C698343VJ8399421/refund","rel":"refund","method":"POST"}]},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-1GD61280EY018362Y-0G9100684M081802N","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-1GD61280EY018362Y-0G9100684M081802N/resend","rel":"resend","method":"POST"}]}} 
[2026-09-26 12:52:39] 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-1GD61280EY018362Y-0G9100684M081802N, paypal, completed, AUD, AUD, ?, ?, card, {\"id\":\"4C698343VJ8399421\",\"state\":\"completed\",\"amount\":{\"total\":\"400.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"400.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"protection_eligibility\":\"ELIGIBLE\",\"protection_eligibility_type\":\"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\"transaction_fee\":{\"value\":\"9.90\",\"currency\":\"AUD\"},\"invoice_number\":\"\",\"custom\":\"605\",\"billing_agreement_id\":\"I-P0VYJ2VD2M9A\",\"create_time\":\"2026-09-26T12:52:19Z\",\"update_time\":\"2026-09-26T12:52:19Z\",\"links\":[{\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/4C698343VJ8399421\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/4C698343VJ8399421\\/refund\",\"rel\":\"refund\",\"method\":\"POST\"}]}, 173.0.80.117, AUD, 605, 2026-09-26 12:52:39, 2026-09-26 12:52:39))"} 
[2026-09-26 12:59:57] local.INFO: Received PayPal webhook {"payload":{"id":"WH-6YE22800MU200801T-20K97753G49162819","event_version":"1.0","create_time":"2026-09-26T12:59:43.289Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for A$ 12.0 AUD","resource":{"id":"30Y32997ST875264H","state":"completed","amount":{"total":"12.00","currency":"AUD","details":{"subtotal":"12.00"}},"payment_mode":"INSTANT_TRANSFER","protection_eligibility":"ELIGIBLE","protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE","transaction_fee":{"value":"0.59","currency":"AUD"},"invoice_number":"","custom":"603","billing_agreement_id":"I-38NA7F83PMDY","create_time":"2026-09-26T12:59:38Z","update_time":"2026-09-26T12:59:38Z","links":[{"href":"https://api.sandbox.paypal.com/v1/payments/sale/30Y32997ST875264H","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/payments/sale/30Y32997ST875264H/refund","rel":"refund","method":"POST"}]},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-6YE22800MU200801T-20K97753G49162819","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-6YE22800MU200801T-20K97753G49162819/resend","rel":"resend","method":"POST"}]}} 
[2026-09-26 12:59: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-6YE22800MU200801T-20K97753G49162819, paypal, completed, AUD, AUD, ?, ?, card, {\"id\":\"30Y32997ST875264H\",\"state\":\"completed\",\"amount\":{\"total\":\"12.00\",\"currency\":\"AUD\",\"details\":{\"subtotal\":\"12.00\"}},\"payment_mode\":\"INSTANT_TRANSFER\",\"protection_eligibility\":\"ELIGIBLE\",\"protection_eligibility_type\":\"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\"transaction_fee\":{\"value\":\"0.59\",\"currency\":\"AUD\"},\"invoice_number\":\"\",\"custom\":\"603\",\"billing_agreement_id\":\"I-38NA7F83PMDY\",\"create_time\":\"2026-09-26T12:59:38Z\",\"update_time\":\"2026-09-26T12:59:38Z\",\"links\":[{\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/30Y32997ST875264H\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/30Y32997ST875264H\\/refund\",\"rel\":\"refund\",\"method\":\"POST\"}]}, 173.0.80.116, AUD, 603, 2026-09-26 12:59:59, 2026-09-26 12:59:59))"} 
[2026-09-26 13:01:48] local.INFO: Received PayPal webhook {"payload":{"id":"WH-8FC93008N4828183K-8K261220FM615631F","event_version":"1.0","create_time":"2026-09-26T13:01:32.454Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for A$ 200.0 AUD","resource":{"id":"3SG29371PC890890G","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-26T13:00:58Z","update_time":"2026-09-26T13:00:58Z","links":[{"href":"https://api.sandbox.paypal.com/v1/payments/sale/3SG29371PC890890G","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/payments/sale/3SG29371PC890890G/refund","rel":"refund","method":"POST"}]},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-8FC93008N4828183K-8K261220FM615631F","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-8FC93008N4828183K-8K261220FM615631F/resend","rel":"resend","method":"POST"}]}} 
[2026-09-26 13:01: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-8FC93008N4828183K-8K261220FM615631F, paypal, completed, AUD, AUD, ?, ?, card, {\"id\":\"3SG29371PC890890G\",\"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-26T13:00:58Z\",\"update_time\":\"2026-09-26T13:00:58Z\",\"links\":[{\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/3SG29371PC890890G\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\\/\\/api.sandbox.paypal.com\\/v1\\/payments\\/sale\\/3SG29371PC890890G\\/refund\",\"rel\":\"refund\",\"method\":\"POST\"}]}, 173.0.80.117, AUD, 629, 2026-09-26 13:01:50, 2026-09-26 13:01:50))"} 
[2026-09-26 13:41:17] local.INFO: Received PayPal webhook {"payload":{"id":"WH-5HM17187G0646134X-0R988676NF2310422","event_version":"1.0","create_time":"2026-09-26T13:41:09.325Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for $ 50.0 USD","resource":{"id":"82X602635N1861058","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-26T13:41:04Z","update_time":"2026-09-26T13:41:04Z","links":[{"href":"https://api.sandbox.paypal.com/v1/payments/sale/82X602635N1861058","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/payments/sale/82X602635N1861058/refund","rel":"refund","method":"POST"}]},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-5HM17187G0646134X-0R988676NF2310422","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-5HM17187G0646134X-0R988676NF2310422/resend","rel":"resend","method":"POST"}]}} 
[2026-09-26 13:41:19] local.ERROR: Donation not found for subscription {"subscription_id":"I-9XLX24MPCD35","donation_id":"189"} 
[2026-09-26 14:42:57] local.INFO: Received PayPal webhook {"payload":{"id":"WH-0DY51996NS4107501-0EX80308A6571381D","event_version":"1.0","create_time":"2026-09-26T14:42:43.457Z","resource_type":"sale","event_type":"PAYMENT.SALE.COMPLETED","summary":"Payment completed for $ 50.0 USD","resource":{"id":"1XE35814YF055192V","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-26T14:42:39Z","update_time":"2026-09-26T14:42:39Z","links":[{"href":"https://api.sandbox.paypal.com/v1/payments/sale/1XE35814YF055192V","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/payments/sale/1XE35814YF055192V/refund","rel":"refund","method":"POST"}]},"links":[{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-0DY51996NS4107501-0EX80308A6571381D","rel":"self","method":"GET"},{"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-0DY51996NS4107501-0EX80308A6571381D/resend","rel":"resend","method":"POST"}]}} 
[2026-09-26 14:42:58] local.ERROR: Donation not found for subscription {"subscription_id":"I-FD7D1HANN2TA","donation_id":"185"}