Upgrade database to utf8mb4 #103

Open
opened 2026-01-06 08:38:14 +00:00 by ken_fallon · 0 comments
Owner

Extended characters like 😁 are causing a problem in comments but also in show notes.

[06-Jan-2026 08:31:40 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Incorrect string value: '\xF0\x9F\x98\x81\x0D\x0A' for column hpr_hpr.comments.comment_text at row 1 in /home/hpr/public_html/cms/comment_process.php:126

Extended characters like 😁 are causing a problem in comments but also in show notes. [06-Jan-2026 08:31:40 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Incorrect string value: '\xF0\x9F\x98\x81\x0D\x0A' for column `hpr_hpr`.`comments`.`comment_text` at row 1 in /home/hpr/public_html/cms/comment_process.php:126 - https://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors - https://www.w3tutorials.net/blog/incorrect-string-value-when-trying-to-insert-utf-8-into-mysql-via-jdbc/
ken_fallon self-assigned this 2026-01-06 08:38:22 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: HPR/hpr_hub#103