It is currently 28 Mar 2024, 23:57

All times are UTC [ DST ]




 Page 1 of 1 [ 6 posts ] 
Author Message
 Post subject: General SQL Error
PostPosted: 25 Mar 2016, 13:00 
Genuinely interested
Genuinely interested
User avatar

Joined: 11 Mar 2016, 12:31
Posts: 37
Location: Croatia
Has thanked: 0 time
Been thanked: 0 time
I get this very often when trying to leave a comment..... Now i got it even to send a message. Admin, i cant even reply to your respond, thats why im trying to alert you here.

The error is:


General Error
SQL ERROR [ mysqli ]

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

Thank you for any help.
Offline
 Profile  
 
 Post subject: Re: Error
PostPosted: 25 Mar 2016, 18:34 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
This is binary code in some format.... what kind of message are you trying to post?

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Error
PostPosted: 25 Mar 2016, 19:18 
Genuinely interested
Genuinely interested
User avatar

Joined: 11 Mar 2016, 12:31
Posts: 37
Location: Croatia
Has thanked: 0 time
Been thanked: 0 time
I get this alert when i try to leave a comment on one of my thread, no matter which desktop/IP or my phone im using.
Also, im unable to reply on your message in my inbox, the same thing.
Offline
 Profile  
 
 Post subject: Re: Error
PostPosted: 28 Mar 2016, 06:31 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
monetri wrote:
I get this alert when i try to leave a comment on one of my thread, no matter which desktop/IP or my phone im using.
Also, im unable to reply on your message in my inbox, the same thing.


These pages:

https://www.phpbb.com/community/viewtopic.php?p=12818556
http://stackoverflow.com/questions/10957238/incorrect-string-value-when-trying-to-insert-utf-8-into-mysql-via-jdbc

Would tend to say that you are trying to push characters not allowed in the database (some Cyrillic, Arabic, etc.).

Are you using any specific language encoding on your browser?
Could you force it to "English UTF-8"?

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Error
PostPosted: 28 Mar 2016, 06:34 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
In your message, '\xF0\x9F\x98\x84' refers to a 4-byte emoji:

http://apps.timwhitlock.info/emoji/tables/unicode

This version of phpBB only handles characters up to 3 bytes, 4 will get rejected.

\xF0\x9F\x98\x84    SMILING FACE WITH OPEN MOUTH AND SMILING EYES


Let me guess.... you're using a Mac and an iPhone/iPad?

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Error
PostPosted: 28 Mar 2016, 12:44 
Genuinely interested
Genuinely interested
User avatar

Joined: 11 Mar 2016, 12:31
Posts: 37
Location: Croatia
Has thanked: 0 time
Been thanked: 0 time
admin wrote:
In your message, '\xF0\x9F\x98\x84' refers to a 4-byte emoji:

http://apps.timwhitlock.info/emoji/tables/unicode

This version of phpBB only handles characters up to 3 bytes, 4 will get rejected.

\xF0\x9F\x98\x84    SMILING FACE WITH OPEN MOUTH AND SMILING EYES


Let me guess.... you're using a Mac and an iPhone/iPad?

Julien
No, not at all, actually my desktop and phone are both Windows and i did not even try to include emoji :(
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 6 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: