craftcms / webhooks

Plugin for integrating Craft with Zapier and IFTTT.
https://plugins.craftcms.com/webhooks
MIT License
84 stars 12 forks source link

SQL Error when response body contains unsupported characters #89

Open HhebertGhost opened 8 months ago

HhebertGhost commented 8 months ago

Description

We are getting errors when the webhook fires and receives a response body containing emojis, specifically : [273218] Sending webhook “ISR cache bust Entries” (attempt: 2, pid: 249507) - Error (time: 3.632s): SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x93\x8D O...' for column 'responseBody' at row 1

Steps to reproduce

  1. create webhook that requests a page with emojis in the body
  2. trigger webhook

Additional info