Error: the query error when there's a non ASCII character

[syofyanzuhad]

Pulse Version

1.2

Laravel Version

10.3

PHP Version

8.3

Livewire Version

3.6

Database Driver & Version

MySQL 8.0.35

Description

the key column on pulse_entries table doesn't support non-ASCII characters, it will make the pulse:work command always stop and we cannot do anything

 Illuminate\\Database\\QueryException \n\n  SQLSTATE[HY000]: General error: 1366 Incorrect string value: \'\\xBF\'\'\\xF0\\x9F\\x92...\' for column \'key\' at row 1 (Connection: monitoring, SQL: insert into `pulse_entries` (`key`, `timestamp`, `type`, `value`) values (

Steps To Reproduce

I run a pulse with redis and the job suddenly stop with the error:

 Illuminate\\Database\\QueryException \n\n  SQLSTATE[HY000]: General error: 1366 Incorrect string value: \'\\xBF\'\'\\xF0\\x9F\\x92...\' for column \'key\' at row 1 (Connection: monitoring, SQL: insert into `pulse_entries` (`key`, `timestamp`, `type`, `value`) values (

[crynobone]

Hey there, thanks for reporting this issue.

We'll need more info and/or code to debug this further. Can you please create a repository with the command below, commit the code that reproduces the issue as one separate commit on the main/master branch and share the repository here?

Please make sure that you have the latest version of the Laravel installer in order to run this command. Please also make sure you have both Git & the GitHub CLI tool properly set up.

laravel new bug-report --github="--public"

Do not amend and create a separate commit with your custom changes. After you've posted the repository, we'll try to reproduce the issue.

Thanks!