Skip to content

SQL Error when response body contains unsupported characters #89

@HhebertGhost

Description

@HhebertGhost

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

  • Craft version: 4.5.11.1
  • PHP version: 8.2.1
  • Database driver & version: MySQL 5.7.42
  • Plugins & versions: Webhooks 3.0.5

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions