Emoji causing MySQL Errors

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
benwhittaker25
Registered User
Posts: 8
Joined: Tue Aug 05, 2014 6:14 pm

Emoji causing MySQL Errors

Post by benwhittaker25 »

Every time someone posts a emoji from iPhone iPad the board games and MySQL error

Is there a fix for this ?
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70177
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Emoji causing MySQL Errors

Post by KevC »

What does the error say?
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
benwhittaker25
Registered User
Posts: 8
Joined: Tue Aug 05, 2014 6:14 pm

Re: Emoji causing MySQL Errors

Post by benwhittaker25 »

Image
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70177
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Emoji causing MySQL Errors

Post by KevC »

-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
benwhittaker25
Registered User
Posts: 8
Joined: Tue Aug 05, 2014 6:14 pm

Re: Emoji causing MySQL Errors

Post by benwhittaker25 »

KevC wrote:Try following this
Doesn’t have a default value errors
This did not help thanks tho, does anybody else have any ideas ?
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70177
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Emoji causing MySQL Errors

Post by KevC »

Please fill out the Support Request Template and post it back here to enable us to assist you better.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
benwhittaker25
Registered User
Posts: 8
Joined: Tue Aug 05, 2014 6:14 pm

Re: Emoji causing MySQL Errors

Post by benwhittaker25 »

Support Request Template
What version of phpBB are you using? phpBB 3.0.12
What is your board's URL? http://claniquit.com/forum/index.php
Who do you host your board with? https://www.siteground.com
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? Yes
What MODs do you have installed? Mchat https://www.phpbb.com/customise/db/mod/ ... ew_version
Latest topic titles https://www.phpbb.com/customise/db/mod/ ... ic_title_2
What styles do you currently have installed? SE Gamer Dark
What language(s) is your board currently using? English
Which database type/version are you using? mysql - 5.0.96
What is your level of experience? New to phpBB but not PHP
What username can be used to view this issue? test
What password can be used to view this issue? qwerty
When did your problem begin? As soon as i installed phpbb
Please describe your problem. When a emoji is posted inside a new topic using a ios device the forum gives a error and creates a ghost topic
Generated by SRT Generator
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70177
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Emoji causing MySQL Errors

Post by KevC »

benwhittaker25 wrote:
KevC wrote:Try following this
Doesn’t have a default value errors
This did not help thanks tho, does anybody else have any ideas ?
You ran all of the resulting SQL queries on the database and they went through ok?
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
benwhittaker25
Registered User
Posts: 8
Joined: Tue Aug 05, 2014 6:14 pm

Re: Emoji causing MySQL Errors

Post by benwhittaker25 »

KevC wrote:
benwhittaker25 wrote:
KevC wrote:Try following this
Doesn’t have a default value errors
This did not help thanks tho, does anybody else have any ideas ?
You ran all of the resulting SQL queries on the database and they went through ok?
It said " MySQL returned an empty result set (i.e. zero rows).
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10406
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: Emoji causing MySQL Errors

Post by Noxwizard »

That is a limitation of MySQL. You're trying to post a 4 byte character and MySQL didn't add 4 byte UTF-8 support until 5.5.3.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
benwhittaker25
Registered User
Posts: 8
Joined: Tue Aug 05, 2014 6:14 pm

Re: Emoji causing MySQL Errors

Post by benwhittaker25 »

Noxwizard wrote:That is a limitation of MySQL. You're trying to post a 4 byte character and MySQL didn't add 4 byte UTF-8 support until 5.5.3.
So if my web host updates MySQL the problem should be fixed ?
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10406
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: Emoji causing MySQL Errors

Post by Noxwizard »

It's not quite that simple due to how they added support for it. They created a new collation called utf8mb4, so you would have to convert all of the tables to that (we default to utf8_bin).
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
benwhittaker25
Registered User
Posts: 8
Joined: Tue Aug 05, 2014 6:14 pm

Re: Emoji causing MySQL Errors

Post by benwhittaker25 »

Noxwizard wrote:It's not quite that simple due to how they added support for it. They created a new collation called utf8mb4, so you would have to convert all of the tables to that (we default to utf8_bin).
I already transferred all of my collation to UTF8mb4 and there is no difference
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10406
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: Emoji causing MySQL Errors

Post by Noxwizard »

All of your columns' collations were updated as well? Additionally, /includes/db/mysqli.php needs to be updated (~line 74) to utf8mb4.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
benwhittaker25
Registered User
Posts: 8
Joined: Tue Aug 05, 2014 6:14 pm

Re: Emoji causing MySQL Errors

Post by benwhittaker25 »

Noxwizard wrote:All of your columns' collations were updated as well? Additionally, /includes/db/mysqli.php needs to be updated (~line 74) to utf8mb4.
I just updated the files and the individual collations and its fixed thank you
Locked

Return to “[3.0.x] Support Forum”