search

SUPLA / supla-cloud

https://www.supla.org
GNU General Public License v2.0
70 stars 46 forks source link

Make your notification queue error-proof #865

Closed przemyslawzygmunt closed 4 weeks ago

przemyslawzygmunt commented 2 months ago

In Statement.php line 130:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF
0\x9F\x87\xB6\xF0\x9F...' for column supla.supla_email_notifications.b ody at row 1

supla:cyclic:send-server-messages [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--]

In DoctrineSender.php line 52:

An exception occurred while executing a query: SQLSTATE[22007]: Invalid dat
etime format: 1366 Incorrect string value: '\xF0\x9F\x87\xB6\xF0\x9F...' fo
r column supla.supla_email_notifications.body at row 1

In ExceptionConverter.php line 117:

An exception occurred while executing a query: SQLSTATE[22007]: Invalid dat
etime format: 1366 Incorrect string value: '\xF0\x9F\x87\xB6\xF0\x9F...' fo
r column supla.supla_email_notifications.body at row 1

In Exception.php line 28:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF
0\x9F\x87\xB6\xF0\x9F...' for column supla.supla_email_notifications.b ody at row 1

In Statement.php line 130:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF
0\x9F\x87\xB6\xF0\x9F...' for column supla.supla_email_notifications.b ody at row 1

supla:cyclic:send-server-messages [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--]

fracz commented 1 month ago

@przemyslawzygmunt chodzi o złe kodowanie w bazie mb3, które pojawia się nie wiem skąd. Nie wiem co z tym zrobić.