211541 - Gives error on query if my product name contain apostrophe ( ' )string

Status: RESOLVED WORKSFORME

(Bugzilla :: Query/Bug List, defect)

Description

[Naveen Joshi]

User-Agent:       Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Build Identifier: 

My one of the Product Name is "XYZ'c" which is having apostrophe string. 
Whenever I am going to make any query across the product it given the error.

Even when I am running the command  ./whineatnews.pl and ./collectstats.pl then 
it give the same error for report to globle.pl at line no. 271.

Reproducible: Always

Steps to Reproduce:
1.create new product named " XYZ's bug"
2.run the command "./whineatnews.pl and ./collectstats.pl or make the query on  
database from the query page 
3.

Actual Results:  
It gives error to get query. and indicating to modify globle.pl at line no. 271.

Expected Results:  
query output.

Comment 1

[Dave Miller [:justdave]]

I'm 95% positive this was fixed a LONG time ago....

what version of Bugzilla are you using?

Comment 2

[Naveen Joshi]

I have just upgraded 2.16.3 version from 2.12 version with RH 8.0. Could you 
please provide the link for solutions. 

Comment 3

[Dave Miller [:justdave]]

OK, so you're still having this problem in 2.16.3?

Comment 4

[Naveen Joshi]

Yes, I have this problem in version 2.16.3 

Comment 5

[Dave Miller [:justdave]]

Are you sure you don't have local code changes on your install?  I can't
reproduce this.  All of the related bugs I can find were fixed in Bugzilla 2.12
or earlier.

Comment 6

[Joel Peshkin]

Tried it on 2.17.6 with no problem.
--> WORKSFORME unless we get new information to the contrary