Bug 1040330 - Software error happened when adding hardware components if the spec was created by xmlrpc client
Summary: Software error happened when adding hardware components if the spec was creat...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Hardware Certification Program
Classification: Retired
Component: Hardware Catalog
Version: 5.3
Hardware: Unspecified
OS: Unspecified
high
unspecified
Target Milestone: ---
: ---
Assignee: Tony Fu
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks: 1040296
TreeView+ depends on / blocked
 
Reported: 2013-12-11 08:22 UTC by Huan Zhang
Modified: 2014-06-18 07:17 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-01-09 07:00:53 UTC

Attachments (Terms of Use)
create spec using xmlrpc client (987 bytes, application/x-perl)
2013-12-11 08:22 UTC, Huan Zhang 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

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.
Note You need to log in before you can comment on or make changes to this bug.