Bug 1040330

Summary: Software error happened when adding hardware components if the spec was created by xmlrpc client
Product: [Retired] Red Hat Hardware Certification Program Reporter: Huan Zhang <hzhang>
Component: Hardware CatalogAssignee: Tony Fu <tfu>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: high    
Version: 5.3CC: hwcert-catalog, junwang, tfu, 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: 2014-01-09 07:00:53 UTC Type: Bug
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: 1040296    
Attachments:
Description Flags
create spec using xmlrpc client none

Description Huan Zhang 2013-12-11 08:22:50 UTC
Created attachment 835180 [details]
create spec using xmlrpc client

Created a spec using the attached script got following error when adding hardware components:

Software error:

DBD::mysql::db do 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 'WHERE bug_id = 989479' at line 1 [for Statement "UPDATE cert_records SET policy_guide_id =  WHERE bug_id = 989479"] at hwcert.pl line 556
	main::CertifySystem('Bugzilla::CGI=HASH(0x189c3940)', 989479, 0) called at /var/www/html/hwcert/process.cgi line 3099

Comment 1 Tony Fu 2013-12-11 11:15:08 UTC
worked out a patch to fix this issue.

Comment 2 Wei Shen 2013-12-12 08:30:21 UTC
https://code.engineering.redhat.com/gerrit/#/c/17324/ a new fix committed

Comment 3 Tony Fu 2013-12-20 06:15:29 UTC
verified on partner.