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 ... Software error: 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): 4.2 How reproducible: 100% Steps to Reproduce: 1. Open the Advanced Search page 2. Select any Product and Component, such as Product : Red Hat Enterprise Linux 5 Component: kernel-xen 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) Actual results: Software error Expected results: No Software error Additional info:
Created attachment 587939 [details] 20120531-bugzilla-query-error.txt
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. -- simon
Upstream rejected our changes because it caused an unintended side effect. We will fix our code to match the change upstream too. -- simon
The upstream change was approved for Bugzilla 4.2, so we will inherit it with the next release. -- simon