View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0023549 | mantisbt | db mysql | public | 2017-10-26 06:29 | 2018-03-31 19:58 |
Reporter | c_schmitz | Assigned To | atrol | ||
Priority | normal | Severity | crash | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 2.7.0 | ||||
Target Version | 2.13.0 | Fixed in Version | 2.13.0 | ||
Summary | 0023549: Entering Emojis in comments with a user mention crashes with an error | ||||
Description | When entering an emoji in a comment field along with a mention of a username Mantis crashes with error message APPLICATION ERROR 0000401 Database query failed. Error received from database was 0001366: Incorrect string value: '\xF0\x9F\x98\xB1' for column 'body' at row 1 for the query: INSERT INTO mantis_email_table | ||||
Steps To Reproduce | Added a comment to a existing bug like: "hey @someuser , that is so bad <some_emoji>" After posting the above crash message appears. | ||||
Tags | No tags attached. | ||||
Related to 0021101 |
|
I am too old to understand the importance of this emoji stuff https://www.mantisbt.org/forums/viewtopic.php?f=2&t=24787 |
|
c_schmitz, I was not able to reproduce your problem with a fresh install of 2.7.0 Please provide detailed step-by-step instructions to reproduce the issue; the following additional information may also be useful:
|
|
@atrol Let me try here: � |
|
Setting again to |
|
I am wondering that your config_inc.php does not contain any setting for $g_db_type Can you confirm that column |
|
c_schmitz, You did not provide feedback; I am therefore resolving this issue as "no change required". Feel free to reopen the issue at a later time and provide the requested information. |
|
config_defaults is unmodified and the factory one.
I can confirm that. |
|
I am still not able to reproduce the issue using the given information. Did you check for errors or warnings in Web server, PHP or Database log ? |
|
c_schmitz, You did not provide new feedback; I am therefore resolving this issue as "no change required". Feel free to reopen the issue at a later time and provide the requested information. |
|
Did some more tests today. Interestingly when I add $g_display_errors = array( to config_inc.php the error is gone. Pretty weird, heh? |
|
OK, I think I have an understanding of the issue. There has been a patch to mitigate this problem here at https://github.com/mantisbt/mantisbt/pull/797/files Fix: Insert the line
after the line
in bugnote_add.php I am not sure if this is the correct way to fix it but for me it did the trick. |
|
Thanks @c_schmitz that makes sense now.
Seems you are still talking about version 2.7.0. @dregad I am not complete sure, but I think the issue happens when trying to store the note in email queue. |
|
Just updated. You are right - I cannot reproduce this using the latest version so matter seems to be resolved now. |
|
I wouldn't have expected this, as we still try to store 4-byte UTF-8 to 3-byte UTF-8 in MySQL. But it was weird that I was not able to reproduce before, it was weird that you have not been able to reproduce when changing $g_display_errors and now it's weird that it's fixed for you. We might talk about something like writing 1 Byte too much on stack, so depending on the call stack it will crash or not. |
|
I agree. So it still would be great if you can sanitize the call accordingly for next version. |
|
Again weird, as I was able to reproduce. This PR should finally fix it: https://github.com/mantisbt/mantisbt/pull/1313 |
|