Bug 788005 - apostrophe( ' ) causes software where when used in testplan
Summary: apostrophe( ' ) causes software where when used in testplan
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Hardware Certification Program
Classification: Retired
Component: Hardware Catalog
Version: 6.1
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Pengfei Xue
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks: 789025
TreeView+ depends on / blocked
 
Reported: 2012-02-07 08:19 UTC by Meizhen Qi
Modified: 2012-03-31 01:56 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-03-31 01:56:58 UTC


Attachments (Terms of Use)

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


Note You need to log in before you can comment on or make changes to this bug.