Page 1 of 1

Single User Having SQL Errors

Posted: Mon Mar 04, 2013 1:36 am
by TopHouse
I'm stumped with this and am convinced it's something at the guys end and not my site as no-one at all is having problems except him.

He's using an ipad, so thats a foreign language to me immediately, but if he tries to post he gets errors like this :-

SQL Error [mysql4]

Incorrect string value:
'\xFO\x9F\x98\x80\xOAI...' for
column 'post_text' at row 1 [1366]

An SQL error occured while fetching this page.


So, has anyone any idea what the problem is please?

Thanks,

Dion

Re: Single User Having SQL Errors

Posted: Mon Mar 04, 2013 1:49 am
by Janet Ward

Re: Single User Having SQL Errors

Posted: Mon Mar 04, 2013 2:04 am
by TopHouse
Doesn't really help, all that shows me is people having problems with their board, this is a single user out of 4000 members who is having the issue.

Re: Single User Having SQL Errors

Posted: Mon Mar 04, 2013 3:15 am
by UnknownTBeast
I know on my board, when someone is trying to post Asian characters, they will get a similar error. Can't recall if it is the exact, but you could check with this user if they are trying to post anything 'odd'.

Re: Single User Having SQL Errors

Posted: Mon Mar 04, 2013 4:55 am
by Oyabun1
It could be that they are trying to post a character that other users are not and that is the reason only they experience it. You should try the "The Fix" in this article Doesn't have a default value errors or the MySQL Upgrader tool in the Support Toolkit and see if that resolves the error.

Re: Single User Having SQL Errors

Posted: Mon Mar 04, 2013 8:07 pm
by TopHouse
[SOLVED]

This is solved and I'm posting the solution for obvious reasons.

The guy with the issue could post quite happily from computers at work etc with no issue, so we had it down to being an issue with either his ipad or how he was using it.

The solution is......


phpbb was choking because he was trying to post ipad smilies to the forum.

Re: Single User Having SQL Errors

Posted: Mon Sep 01, 2014 12:20 pm
by tosiara
Sorry for bumping old thread, but this is still an issue with 3.0.12 and Ipad/Iphone clients
Is there any bug filed for this?

Re: Single User Having SQL Errors

Posted: Tue Oct 14, 2014 10:10 am
by updown
tosiara wrote:Sorry for bumping old thread, but this is still an issue with 3.0.12 and Ipad/Iphone clients
Is there any bug filed for this?
+1

Re: Single User Having SQL Errors

Posted: Tue Oct 14, 2014 1:10 pm
by Oyabun1
It's not a problem with 3.0.12, the issue is caused by the utf8 character set used by MySQL DBMS not supporting 4 byte characters that are outside the MBP (Basic Multilingual Plane). MySQL has added another character set, utf8mb4, but it is only available on MySQL 5.5.3+, which not many web hosts run.

Re: Single User Having SQL Errors

Posted: Tue Oct 14, 2014 6:09 pm
by updown
Oyabun1 wrote:It's not a problem with 3.0.12...
Thanks for the helpful information! Is there a possible workaround like filtering such characters within phpBB before posting to the database?

It may not be a problem with phpBB itself, but as a general problem it is also effecting phpBB-postings - which is very annoying to some iPad-users since they are not aware of the problem.