NATION

PASSWORD

[Q] General Error Message when on Fourms

Bug reports, general help, ideas for improvements, and questions about how things are meant to work.
User avatar
North American Imperial State
Diplomat
 
Posts: 501
Founded: Jan 05, 2020
Left-wing Utopia

[Q] General Error Message when on Fourms

Postby North American Imperial State » Mon Sep 14, 2020 3:40 pm

I have been getting this message alot when I try to post on the Fourms, I have sent an email to the address shown at the bottom.
Am not the most tech savvy guy so any advice/ help is needed.

General Error
SQL ERROR [ mysqli ]

Incorrect string value: '\xF0\x9F\x98\xAC' for column 'post_text' at row 1 [1366]

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

Please notify the board administrator or webmaster: no-reply@nationstates.net
i sometimes post on the forums, sometimes i don't, you will never know

User avatar
Sanghyeok
Negotiator
 
Posts: 5035
Founded: Dec 29, 2016
Ex-Nation

Postby Sanghyeok » Mon Sep 14, 2020 3:42 pm

It may be because you inserted a strange character. I know I tried to enter my motto before, and the flower caused the error.
どんな時も、赤旗の眩しさを覚えていた
Magical socialist paradise headed by an immortal, tea-loving and sometimes childish Chairwoman who happens to be the younger Ōmiya sister

Mini custard puddings
And fresh poured Darjeeling
Strawberry parfait so sweet and appealing,
Little soft plushies and baths in hot springs
These are a few of my favourite things

User avatar
North American Imperial State
Diplomat
 
Posts: 501
Founded: Jan 05, 2020
Left-wing Utopia

Postby North American Imperial State » Mon Sep 14, 2020 3:45 pm

Sanghyeok wrote:It may be because you inserted a strange character. I know I tried to enter my motto before, and the flower caused the error.

Ohh right, am going to see what strange character is causing it

Thank you for your help
i sometimes post on the forums, sometimes i don't, you will never know

User avatar
Sanghyeok
Negotiator
 
Posts: 5035
Founded: Dec 29, 2016
Ex-Nation

Postby Sanghyeok » Mon Sep 14, 2020 3:46 pm

I just tried it.

SQL ERROR [ mysqli ]

Incorrect string value: '\xF0\x9F\x8C\xB8' for column 'post_text' at row 1 [1366]

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


Is the error from trying to insert a flower character.
どんな時も、赤旗の眩しさを覚えていた
Magical socialist paradise headed by an immortal, tea-loving and sometimes childish Chairwoman who happens to be the younger Ōmiya sister

Mini custard puddings
And fresh poured Darjeeling
Strawberry parfait so sweet and appealing,
Little soft plushies and baths in hot springs
These are a few of my favourite things

User avatar
North American Imperial State
Diplomat
 
Posts: 501
Founded: Jan 05, 2020
Left-wing Utopia

Postby North American Imperial State » Mon Sep 14, 2020 3:50 pm

Sanghyeok wrote:I just tried it.

SQL ERROR [ mysqli ]

Incorrect string value: '\xF0\x9F\x8C\xB8' for column 'post_text' at row 1 [1366]

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


Is the error from trying to insert a flower character.

It seems to happen with random emojis that I use.
I have never had any problems with them until the last 12 hours or so.
i sometimes post on the forums, sometimes i don't, you will never know

User avatar
Sanghyeok
Negotiator
 
Posts: 5035
Founded: Dec 29, 2016
Ex-Nation

Postby Sanghyeok » Mon Sep 14, 2020 3:51 pm

North American Imperial State wrote:
Sanghyeok wrote:I just tried it.



Is the error from trying to insert a flower character.

It seems to happen with random emojis that I use.
I have never had any problems with them until the last 12 hours or so.


I have had this problem with the flower emoji since I first tried to use it.
どんな時も、赤旗の眩しさを覚えていた
Magical socialist paradise headed by an immortal, tea-loving and sometimes childish Chairwoman who happens to be the younger Ōmiya sister

Mini custard puddings
And fresh poured Darjeeling
Strawberry parfait so sweet and appealing,
Little soft plushies and baths in hot springs
These are a few of my favourite things

User avatar
North American Imperial State
Diplomat
 
Posts: 501
Founded: Jan 05, 2020
Left-wing Utopia

Postby North American Imperial State » Mon Sep 14, 2020 3:53 pm

Sanghyeok wrote:
North American Imperial State wrote:It seems to happen with random emojis that I use.
I have never had any problems with them until the last 12 hours or so.


I have had this problem with the flower emoji since I first tried to use it.

Mm very strange.
i sometimes post on the forums, sometimes i don't, you will never know

User avatar
Gandoor
Postmaster-General
 
Posts: 10232
Founded: Sep 23, 2008
Civil Rights Lovefest

Postby Gandoor » Mon Sep 14, 2020 3:54 pm

North American Imperial State wrote:
Sanghyeok wrote:
I have had this problem with the flower emoji since I first tried to use it.

Mm very strange.

It isn't strange, emoji just aren't supported on the forums.

That's all it is.
OOC - Call me Viola
IC Flag|Gandoor Wiki|Q&A|National Currency Database
Reminder that true left-wing politics are incompatible with imperialism, authoritarianism, totalitarianism, and dictatorship in all forms.
Flag is currently a Cinderace.
I'm transfeminine non-binary (but I don't mind or care if you refer to me as a woman).
She/They
27 years old
OOC Info
Twitter: @Sailor_Viola
Steam: Princess Viola
Mastodon: @princessviola@retro.pizza
TGs are welcome

User avatar
North American Imperial State
Diplomat
 
Posts: 501
Founded: Jan 05, 2020
Left-wing Utopia

Postby North American Imperial State » Mon Sep 14, 2020 3:57 pm

Gandoor wrote:
North American Imperial State wrote:Mm very strange.

It isn't strange, emoji just aren't supported on the forums.

That's all it is.

Considering I have never had a problem with using them, I will wait for the Admins/Mods to respond.
i sometimes post on the forums, sometimes i don't, you will never know

User avatar
Gandoor
Postmaster-General
 
Posts: 10232
Founded: Sep 23, 2008
Civil Rights Lovefest

Postby Gandoor » Mon Sep 14, 2020 4:03 pm

North American Imperial State wrote:
Gandoor wrote:It isn't strange, emoji just aren't supported on the forums.

That's all it is.

Considering I have never had a problem with using them, I will wait for the Admins/Mods to respond.

Bruh, the error you got is literally because you used the grimace face emoji.

'Incorrect string value: '\xF0\x9F\x98\xAC' for column 'post_text' at row 1 [1366]'

\xF0\x9F\x98\xAC is literally the UTF-8 encoding for the grimace face emoji and if you just did a basic search on these forums you would literally find multiple threads of people getting night-identical errors because emoji are not supported on the forums.

You don't need an admin to tell you what people who have been here for years know.
Last edited by Gandoor on Mon Sep 14, 2020 4:04 pm, edited 1 time in total.
OOC - Call me Viola
IC Flag|Gandoor Wiki|Q&A|National Currency Database
Reminder that true left-wing politics are incompatible with imperialism, authoritarianism, totalitarianism, and dictatorship in all forms.
Flag is currently a Cinderace.
I'm transfeminine non-binary (but I don't mind or care if you refer to me as a woman).
She/They
27 years old
OOC Info
Twitter: @Sailor_Viola
Steam: Princess Viola
Mastodon: @princessviola@retro.pizza
TGs are welcome

User avatar
North American Imperial State
Diplomat
 
Posts: 501
Founded: Jan 05, 2020
Left-wing Utopia

Postby North American Imperial State » Mon Sep 14, 2020 4:27 pm

Gandoor wrote:
North American Imperial State wrote:Considering I have never had a problem with using them, I will wait for the Admins/Mods to respond.

Bruh, the error you got is literally because you used the grimace face emoji.

'Incorrect string value: '\xF0\x9F\x98\xAC' for column 'post_text' at row 1 [1366]'

\xF0\x9F\x98\xAC is literally the UTF-8 encoding for the grimace face emoji and if you just did a basic search on these forums you would literally find multiple threads of people getting night-identical errors because emoji are not supported on the forums.

You don't need an admin to tell you what people who have been here for years know.

Thank you for your help
i sometimes post on the forums, sometimes i don't, you will never know

User avatar
[violet]
Executive Director
 
Posts: 16205
Founded: Antiquity

Postby [violet] » Tue Sep 15, 2020 4:31 pm

Confirming as above: some emoji aren't supported.

User avatar
Sanghyeok
Negotiator
 
Posts: 5035
Founded: Dec 29, 2016
Ex-Nation

Postby Sanghyeok » Tue Sep 15, 2020 4:46 pm

[violet] wrote:Confirming as above: some emoji aren't supported.


Thank you for the information.
どんな時も、赤旗の眩しさを覚えていた
Magical socialist paradise headed by an immortal, tea-loving and sometimes childish Chairwoman who happens to be the younger Ōmiya sister

Mini custard puddings
And fresh poured Darjeeling
Strawberry parfait so sweet and appealing,
Little soft plushies and baths in hot springs
These are a few of my favourite things

User avatar
Mathuvan Union
Negotiator
 
Posts: 5158
Founded: Feb 20, 2020
Ex-Nation

Postby Mathuvan Union » Tue Sep 15, 2020 5:18 pm

[violet] wrote:Confirming as above: some emoji aren't supported.

I’ve discovered virtually every emoji that is used/was created by Apple doesn’t work
Behind the free market lies the iron fist of the state - the one thing I learned from The Blaatschapen, excluding how to say sheep in dutch.
Update: apparently it’s bleating sheep.

User avatar
Merni
Ambassador
 
Posts: 1800
Founded: May 03, 2016
Democratic Socialists

Postby Merni » Wed Sep 16, 2020 2:05 am

Mathuvan Union wrote:
[violet] wrote:Confirming as above: some emoji aren't supported.

I’ve discovered virtually every emoji that is used/was created by Apple doesn’t work

I don't think Apple creates emoji, they just use the emoji that Unicode has. Unicode itself has emoji in various different blocks, though, and it could be that some of them are not supported. (I could be wrong about this)
2024: the year of democracy. Vote!
The Labyrinth | Donate your free time, help make free ebooks | Admins: Please let us block WACC TGs!
RIP Residency 3.5.16-18.11.21, killed by simplistic calculation
Political Compass: Economic -9.5 (Left) / Social -3.85 (Liberal)
Wrote issue 1523, GA resolutions 532 and 659
meth
When the people are being beaten with a stick, they are not much happier if it is called 'the People’s Stick.' — Mikhail Bakunin (to Karl Marx)
You're supposed to be employing the arts of diplomacy, not the ruddy great thumping sledgehammers of diplomacy. — Ardchoille
The West won the world not by the superiority of its ideas or values or religion [...] but rather by its superiority in applying organised violence. — Samuel P. Huntington (even he said that!)

User avatar
Mathuvan Union
Negotiator
 
Posts: 5158
Founded: Feb 20, 2020
Ex-Nation

Postby Mathuvan Union » Wed Sep 16, 2020 6:45 am

Merni wrote:
Mathuvan Union wrote:I’ve discovered virtually every emoji that is used/was created by Apple doesn’t work

I don't think Apple creates emoji, they just use the emoji that Unicode has. Unicode itself has emoji in various different blocks, though, and it could be that some of them are not supported. (I could be wrong about this)

they created the images, but that's irrelevant.
it's really annoying with autocorrect adding emojis though
Behind the free market lies the iron fist of the state - the one thing I learned from The Blaatschapen, excluding how to say sheep in dutch.
Update: apparently it’s bleating sheep.

User avatar
North American Imperial State
Diplomat
 
Posts: 501
Founded: Jan 05, 2020
Left-wing Utopia

Postby North American Imperial State » Wed Sep 16, 2020 7:54 am

[violet] wrote:Confirming as above: some emoji aren't supported.

Thank you for your reply
i sometimes post on the forums, sometimes i don't, you will never know


Advertisement

Remove ads

Return to Technical

Who is online

Users browsing this forum: 9003, Amjadwashere, Cafe Hell, Fauzjhia, Improper Classifications, Republics of the Solar Union, Second Scratch Empire, The Plough Islands, The Whimslands, WonGya, Wopruthien, Zintai

Advertisement

Remove ads