Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: Opsboss on November 22, 2019, 02:28:10 PM

Title: Database Error: Incorrect string value
Post by: Opsboss on November 22, 2019, 02:28:10 PM
We're still using 1.1.21 and in the past few days users have been receiving an error message when attempting to post: "Database Error: Incorrect string value: '\xF0\x9F\x91\x89 S...' for column 'body' at row 1 File: /home/customer/www/windageandelevation.net/public_html/Sources/Subs-Post.php
Line: 1535" Any idea what that's about and how to fix it?
Title: Re: Database Error: Incorrect string value
Post by: Arantor on November 22, 2019, 02:34:39 PM
SMF 1.1 doesn't support emoji, you need to upgrade to SMF 2.0.15.
Title: Re: Database Error: Incorrect string value
Post by: Opsboss on November 22, 2019, 02:39:04 PM
Thanks. Yeah, I know I need to upgrade. Tried once and it crashed. Apparently I need to upgrade through half a dozen 2.0.xx versions one at a time. I have an actual life and don't presently have the time or patience to do that. Anyway, appreciate the response. We'll try a temporary fix by eliminating emojis.
Title: Re: Database Error: Incorrect string value
Post by: Illori on November 22, 2019, 02:41:23 PM
once you upgrade to one version of SMF 2.0.* you can use the package manager to finish the upgrade quickly, that is if you cant upgrade directly to SMF 2.0.15.
Title: Re: Database Error: Incorrect string value
Post by: Opsboss on November 22, 2019, 02:46:20 PM
Thanks. Yes I tried upgrading directly to 2.0.15 and no joy. When I find some time I'll try upgrading to an earlier 2.0.xx version, then on to 2.0.15. But finding the time to do it is a challenge.