Red Hat Bugzilla – Bug 826829
Software error when doing anywords or allwords search that starts or ends with a space
Last modified: 2014-10-12 18:48:33 EDT
Description of problem:
Found this error when query bugs with space in front of the string in the comment of the detailed bug information.
Please stand by ...
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Open the Advanced Search page
2. Select any Product and Component, such as
Product : Red Hat Enterprise Linux 5
3. Input a string into the Comment Input box with a space in front of, like " vcpu" (without quotes), like below:
Detailed Bug Information
Comment: contains all of the strings " vcpu"(without quotes)
No Software error
Created attachment 587939 [details]
Reason for hotfix: This one is going upstream, but I want to provide a patch for them too.
Filed upstream at https://bugzilla.mozilla.org/show_bug.cgi?id=760075
Will be in our 4.2.1-2 release regardless.
Upstream rejected our changes because it caused an unintended side effect. We will fix our code to match the change upstream too.
The upstream change was approved for Bugzilla 4.2, so we will inherit it with the next release.