PM's

Page 1 of 1 [ 12 posts ]

AngelL
Deinonychus

Joined: 13 Jul 2021
Gender: Male
Posts: 349
Location: Seattle, WA

06 Aug 2021, 4:16 pm

I have gotten this message more times than I can count (not really, it's now 44 attempts) as I try to send a PM:

General Error
SQL ERROR [ mysqli ]

Incorrect string value: '\xF0\x9F\x98\x8A\x0A\x0A...' for column 'message_text' at row 1 [1366]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Can anyone explain what is happening?

Mountain Goat
Veteran
Veteran

Joined: 13 May 2019
Gender: Male
Posts: 14,807
Location: .

06 Aug 2021, 4:19 pm

It looks like an error message to me.

I can't say I knw why it happens though.

Does the same thing happen if other people PM you?

_________________
https://everything2.com/user/Zifendorf/writeups/shutdow

Fnord
Veteran
Veteran

Joined: 6 May 2008
Gender: Male
Posts: 60,939
Location:

06 Aug 2021, 4:21 pm

Are you trying to use an emoji character? Something in your environment may not be set up to correctly process Unicode text. The byte sequence "F0 9F 98 9C" is the UTF8 encoding of the Unicode character for a face with stuck-out tongue and winking eye (e.g., it is an emoji character).

When I tried to use that emoji in this post, I got the same error. Removing it solved the problem.

AngelL
Deinonychus

Joined: 13 Jul 2021
Gender: Male
Posts: 349
Location: Seattle, WA

06 Aug 2021, 4:29 pm

Fnord wrote:

I'll bet that's it - thank you!

Fnord
Veteran
Veteran

Joined: 6 May 2008
Gender: Male
Posts: 60,939
Location:

06 Aug 2021, 4:29 pm

Mountain Goat wrote:

It looks like an error message to me...

What was your first clue?

Fnord
Veteran
Veteran

Joined: 6 May 2008
Gender: Male
Posts: 60,939
Location:

06 Aug 2021, 4:30 pm

AngelL wrote:

Fnord wrote:

Are you trying to use an emoji character? Something in your environment may not be set up to correctly process Unicode text. The byte sequence "F0 9F 98 9C" is the UTF8 encoding of the Unicode character for a face with stuck-out tongue and winking eye (e.g., it is an emoji character). When I tried to use that emoji in this post, I got the same error. Removing it solved the problem.

I'll bet that's it - thank you!

Shucks, ma'am ... 'twern't nuthin' ... jus' tryin' tuh be helpful.

AngelL
Deinonychus

Joined: 13 Jul 2021
Gender: Male
Posts: 349
Location: Seattle, WA

06 Aug 2021, 4:32 pm

Fnord wrote:

AngelL wrote:

Fnord wrote:

Are you trying to use an emoji character? Something in your environment may not be set up to correctly process Unicode text. The byte sequence "F0 9F 98 9C" is the UTF8 encoding of the Unicode character for a face with stuck-out tongue and winking eye (e.g., it is an emoji character). When I tried to use that emoji in this post, I got the same error. Removing it solved the problem.

I'll bet that's it - thank you!

Shucks, ma'am ... 'twern't nuthin' ... jus' tryin' tuh be helpful.

And you were! Very! I suspected you were correct, but now I'm returning after removing them and hitting 'send' and it went without a hitch. Yay! Thanks again!

Fnord
Veteran
Veteran

Joined: 6 May 2008
Gender: Male
Posts: 60,939
Location:

06 Aug 2021, 4:35 pm

AngelL wrote:

Fnord wrote:

AngelL wrote:

Fnord wrote:

Are you trying to use an emoji character? Something in your environment may not be set up to correctly process Unicode text. The byte sequence "F0 9F 98 9C" is the UTF8 encoding of the Unicode character for a face with stuck-out tongue and winking eye (e.g., it is an emoji character). When I tried to use that emoji in this post, I got the same error. Removing it solved the problem.

I'll bet that's it - thank you!

Shucks, ma'am ... 'twern't nuthin' ... jus' tryin' tuh be helpful.

And you were! Very! I suspected you were correct, but now I'm returning after removing them and hitting 'send' and it went without a hitch. Yay! Thanks again!

Aww ... gee...

:oops:

Mountain Goat
Veteran
Veteran

Joined: 13 May 2019
Gender: Male
Posts: 14,807
Location: .

06 Aug 2021, 4:36 pm

Fnord wrote:

Mountain Goat wrote:

It looks like an error message to me...

What was your first clue?

Uhmmm. This:

"General Error
SQL ERROR [ mysqli ]"

_________________
https://everything2.com/user/Zifendorf/writeups/shutdow

Fnord
Veteran
Veteran

Joined: 6 May 2008
Gender: Male
Posts: 60,939
Location:

06 Aug 2021, 4:42 pm

Mountain Goat wrote:

Fnord wrote:

Mountain Goat wrote:

It looks like an error message to me...

What was your first clue?

Uhmmm. This:

"General Error
SQL ERROR [ mysqli ]"

Hmm ... it looks like you have replied to my post.

With a reply!

Imagine that...

Edna3362
Veteran
Veteran

Joined: 29 Oct 2011
Gender: Female
Posts: 12,836
Location: ᜆᜄᜎᜓᜄ᜔

06 Aug 2021, 5:01 pm

Mountain Goat wrote:

It looks like an error message to me.

I can't say I knw why it happens though.

Does the same thing happen if other people PM you?

Yes and it's not limited to PMs.

It happens if you do this:

In preview, it works.

Why it happens?
Well... it's like this website can read the "code" from the emoji keyboard, but it translates into error because it's not in raw like text and not "compatible".

... I can't explain it well. :lol:

It'll likely not a right description for it.

_________________

Gained Number Post Count (1).
Lose Time (ⁿ).

^{Lose more time here - Updates at least once a week.}

Mountain Goat
Veteran
Veteran

Joined: 13 May 2019
Gender: Male
Posts: 14,807
Location: .

06 Aug 2021, 5:35 pm

It is confusing.

_________________
https://everything2.com/user/Zifendorf/writeups/shutdow

Page 1 of 1 [ 12 posts ]

Jump to:

PM's Post Reply New Topic

PM's