Bug 788005

Summary: apostrophe( ' ) causes software where when used in testplan
Product: [Retired] Red Hat Hardware Certification Program Reporter: Meizhen Qi <mqi>
Component: Hardware CatalogAssignee: Pengfei Xue <pxue>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.1CC: hwcert-catalog, pxue, rlandry, wshen
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-03-31 01:56:58 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 789025    

Description Meizhen Qi 2012-02-07 08:19:59 UTC
Description of problem:

If I use apostrophe when I create testplan, the catalog will show software error, eg: 

The testplan is: 
CORE: 2xIntel(R) Xeon(R) eight-cores CPU E5-2690 with HT(32 logical cores)(E5 series haven't been released by intel)

The catalog will show the following error so that I can't create this testplan. 
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 't been released by intel)','CORE','0', '0', '1', '1', 'not_provided' )' at line 3 [for Statement "INSERT INTO testplan_desc ( cert_id, description, name, 
			bits32, bits64, required_32bits, required_64bits, location ) 
			VALUES (11440, '2x Intel(R) Xeon(R) eight-cores CPU E5-2690/E5-2670/E5-2650/E5-2650L with HT(32 logical cores)(cpu E5 series haven't been released by intel)','CORE','0', '0', '1', '1', 'not_provided' )"] at hwcert.pl line 1903
	main::AddNewTestplanItem('CORE: 2x Intel(R) Xeon(R) eight-cores CPU E5-2690/E5-2670/E5-...', 11440, 310462, 'enable') called at /var/www/html/hwcert/process.cgi line 2706

For help, please send mail to the webmaster (bugzilla-owner), giving this error message and the time and date of the error.

Comment 3 Pengfei Xue 2012-03-23 02:44:32 UTC
verified on partner site