HPR/hpr_hub
8
0
Fork 3
Code Issues 48 Pull Requests Packages Projects Releases Wiki Activity

Upgrade database to utf8mb4 #103

New Issue
Open
opened 2026-01-06 08:38:14 +00:00 by ken_fallon · 0 comments
ken_fallon commented 2026-01-06 08:38:14 +00:00
Owner
Copy Link

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.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Feature Request
Used when requesting a new Feature.
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
archer72 davmo jknapp ken_fallon norrist paulj rho_n sgoti
No Assignees ken_fallon
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: HPR/hpr_hub#103
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?