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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions