[2026-08-19 07:21:10] [ENTORNO_DETECTADO] {"APP_ENV":"DEV","DB_NAME":"patruus_DEV_ERP_PLN","BASE_PATH":"\/home\/patruus\/public_html\/erptestvps\/scriptcase","__DIR__":"\/home\/patruus\/public_html\/erptestvps\/webhooks\/pabbly\/Subscripction_Cancel"}
[2026-08-19 07:21:10] [RAW_PAYLOAD] {"event_type":"subscription_cancel","event_source":"user","data":{"customer":{"company_name":"pabbly test patruus","phone":"","tax_id":"1","billing_address":{"street1":"","city":"","state":"Aguascalientes","state_code":"AGU","zip_code":"","country":"MX"},"shipping_address":{"street1":"","city":"","state":"","state_code":"","zip_code":"","country":""},"portal_status":true,"createdAt":"2026-08-19T13:17:41.502Z","updatedAt":"2026-08-19T13:17:41.559Z","id":"6a85acf539a23edcba4168c4","first_name":"pabbly","last_name":"test","email_id":"pabblytest@yopmail.com"},"plan":{"plan_type":"flat_fee","min_quantity":1,"max_quantity":1000000,"plan_active":"true","redirect_url":"https://www.patruus.com/","specific_keep_live":false,"currency_code":"MXN","currency_symbol":"MXN$","gateways_array":[],"payment_gateway":"all","failed_payment_gateway_array":[],"trial_type":"day","trial_amount":0,"custom_payment_term":0,"failed_payment_gateway":"","funnel":[],"funnel_count":"","is_metered":false,"setup_fee_type":"","createdAt":"2024-09-26T19:21:52.103Z","updatedAt":"2026-01-26T16:04:32.823Z","id":"66f5b450027e5a1c737f9f05","product_id":"66f4610f357fab6725a6d375","user_id":"66a6f7a450585134b8242058","plan_name":"Sistema de Facturación Plan Anual","plan_code":"sistema-de-facturacion-plan-anual","price":2069,"billing_period":"y","billing_period_num":"1","billing_cycle":"lifetime","billing_cycle_num":"","trial_period":0,"setup_fee":0,"plan_description":"<p>This is the test plan description.</p><p><br></p><ul><li>20 Timbres Mensuales Incluidos</li><li>Almacenamiento de facturas emitidas</li><li>Envío de email a clientes con XML y PDF</li><li>Catálogo de Clientes</li><li>Catálogo de Artículos o Productos</li><li>Copia de Facturas</li><li>Complementos de Pago</li><li>Reportes de Cuentas por Cobrar</li><li>Tablero con Indicadores Principales</li><li>Disponibilidad 24/7</li></ul>"},"setup_fee":0,"currency_code":"MXN","currency_symbol":"MXN$","payment_method":"6a85acf539a23edcba4168c8","taxable":true,"taxrule_id":"66f4644cc0a758672d85c214","tax_apply":{"id":"66f4644cc0a758672d85c214","country":"MX","taxes":{"iva-16":16},"record_tax_id":true,"is_required_taxid":true,"validate_tax_in":false,"reverse_charge":false,"state":"all","tax_id":"1","exempt_tax":[]},"gateway_type":"test","payment_terms":"","gateway_id":"66f460f6357fab6725a6d369","gateway_name":"Test Gateway","custom_fields":[],"custom":{"embed":"https://www-patruus-com.filesusr.com/html/6144c1_7f5bc3f86103500b39fb7daf4c3cbfa1.html"},"funnel":[],"requested_ip":"64.43.65.184","user_agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36","billing_processing":false,"cron_process":"done","cancel_reason":"Other: test webhooks","cancel_source":"merchant","cancelled_by_email":"jorge@gutierrezcaceres.com","createdAt":"2026-08-19T13:17:41.520Z","updatedAt":"2026-08-19T13:21:10.360Z","id":"6a85acf539a23edcba4168c6","customer_id":"6a85acf539a23edcba4168c4","product_id":"66f4610f357fab6725a6d375","plan_id":"66f5b450027e5a1c737f9f05","amount":2069,"user_id":"66a6f7a450585134b8242058","email_id":"pabblytest@yopmail.com","gateway_email":"","name":"pabbly test","status":"cancelled","quantity":1,"starts_at":"2026-08-19T13:17:41.414Z","activation_date":"2026-08-19T13:17:42.424Z","expiry_date":"2126-08-19T13:17:41.414Z","trial_days":0,"trial_expiry_date":"","next_billing_date":"2027-08-19T13:17:42.424Z","last_billing_date":"2026-08-19T13:17:42.424Z","canceled_date":"2026-08-19T13:21:10.101Z","cancel_requested_date":"2026-08-19T13:21:10.101Z"},"create_time":"2026-08-19T13:21:10.1010+00:00"}
[2026-08-19 07:21:10] [EVENTO_RECIBIDO] {"event_type":"subscription_cancel"}
[2026-08-19 07:21:10] [DATOS_EXTRAIDOS] {"subscription_id":"6a85acf539a23edcba4168c6","email":"pabblytest@yopmail.com"}
[2026-08-19 07:21:10] [CONEXION_BD] {"status":"OK","entorno":"DEV","db":"patruus_DEV_ERP_PLN"}
[2026-08-19 07:21:10] [PASO1_PLAN_ENCONTRADO] {"CTA_PLN_ID":59,"CTA_PLN_ESTADO":"ACTIVO","CTA_PLN_CUENTA":"23"}
[2026-08-19 07:21:10] [PASO2_PLAN_CANCELADO] {"CTA_PLN_ID":59,"rows":1}
[2026-08-19 07:21:10] [PASO3_ERROR_BD] SQLSTATE[42000]: Syntax error or access violation: 1142 DELETE command denied to user 'patruus_pabbly_DEV_ERP_PLN'@'localhost' for table `patruus_DEV_ERP_PLN`.`PATRUUS_PLN_users_groups`
[2026-08-19 07:21:10] [EXITO] {"subscription_id":"6a85acf539a23edcba4168c6","email":"pabblytest@yopmail.com","CTA_PLN_ID":59,"entorno":"DEV"}
[2026-08-19 10:21:13] [ENTORNO_DETECTADO] {"APP_ENV":"DEV","DB_NAME":"patruus_DEV_ERP_PLN","BASE_PATH":"\/home\/patruus\/public_html\/erptestvps\/scriptcase","__DIR__":"\/home\/patruus\/public_html\/erptestvps\/webhooks\/pabbly\/Subscripction_Cancel"}
[2026-08-19 10:21:13] [METODO_NO_PERMITIDO] {"method":"GET"}