Test Post - SQL Error Reported

News and other information will be placed here for you.
Post Reply
User avatar
Fred
Moderator
Posts: 15431
Joined: Tue Jan 15, 2008 2:31 pm
Location: Home sweet home!
Contact:

Test Post - SQL Error Reported

Post by Fred »

Testing testing 1 2 3
DIYEFI.org - where Open Source means Open Source, and Free means Freedom
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
User avatar
Fred
Moderator
Posts: 15431
Joined: Tue Jan 15, 2008 2:31 pm
Location: Home sweet home!
Contact:

Re: Test Post - SQL Error Reported

Post by Fred »

Hello world
DIYEFI.org - where Open Source means Open Source, and Free means Freedom
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
Andreas
LQFP112 - Up with the play
Posts: 102
Joined: Mon Sep 09, 2013 11:11 pm

Re: Test Post - SQL Error Reported

Post by Andreas »

test
Andreas
LQFP112 - Up with the play
Posts: 102
Joined: Mon Sep 09, 2013 11:11 pm

Re: Test Post - SQL Error Reported

Post by Andreas »

That worked...weird
User avatar
ToxicGumbo
LQFP144 - On Top Of The Game
Posts: 474
Joined: Tue Jan 03, 2012 8:37 pm
Location: Manhattan, KS. USA

Re: Test Post - SQL Error Reported

Post by ToxicGumbo »

SHOW DATABASES;
\dt;
SELECT * FROM freeems;
User avatar
Fred
Moderator
Posts: 15431
Joined: Tue Jan 15, 2008 2:31 pm
Location: Home sweet home!
Contact:

Re: Test Post - SQL Error Reported

Post by Fred »

The answer lies here:

(11:19:19) andreas: SQL ERROR [ mysqli ] Incorrect string value: '\xF0\x9F\x98\xAC I...' for column 'post_text' at row 1 [1366]
<SNIP>
(11:24:03) andreas: I took out the smileys, and then it posted. <SNIP>

Found it:

U+1F62C \xF0\x9F\x98\xAC GRIMACING FACE

And got the same error! :-D So removed the actual character. Go to this page and search for the code to see the face responsible for this thread: https://apps.timwhitlock.info/emoji/tables/unicode
DIYEFI.org - where Open Source means Open Source, and Free means Freedom
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
User avatar
Fred
Moderator
Posts: 15431
Joined: Tue Jan 15, 2008 2:31 pm
Location: Home sweet home!
Contact:

Re: Test Post - SQL Error Reported

Post by Fred »

To fix this I'd need to update the MySQL instance to use the utf8_mb4 character set instead of plain utf8. I will look into doing that at some point, but not anytime soon.
DIYEFI.org - where Open Source means Open Source, and Free means Freedom
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
Post Reply