Search fields get escaped

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hi,

Here’s the issue: when filling a search field with single quoted value (O’hara…) it gets escaped after clicking on the next page button or ordering a column.

After the second click, the searching lead to an empty result, because the field has become O\'hara.

Hope to see that fixed or any other solution.

Thanks to all

2

Thanks for highlighting this issue.

We’ll log this as a bug.

Regards,

Will.

3

This a known sugar bug which is still in Sugar CE. https://web.sugarcrm.com/support/issues/52725

Seems to be caused by include/database/MssqlManager.php line 257 where they call mysqli_real_escape_string on the search query.

Not sure about a fix yet.