Bug 1024160

Summary:	Software error happened when opening a cert on partner-hwcert.redhat.com
Product:	[Retired] Red Hat Hardware Certification Program	Reporter:	Huan Zhang <hzhang>
Component:	Hardware Catalog	Assignee:	hwcert-catalog
Status:	CLOSED CURRENTRELEASE	QA Contact:
Severity:	urgent	Docs Contact:
Priority:	unspecified
Version:	5.1	CC:	hwcert-catalog, junwang, rlandry, tfu
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:	2013-10-29 05:24:49 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:
Embargoed:
Bug Depends On:
Bug Blocks:	1024158

Description Huan Zhang 2013-10-29 02:59:50 UTC

When opening an old/new cert, a software error was thrown and said:

"""
Software error:

DBD::mysql::st execute failed: Unknown column 'component_id' in 'field list' [for Statement "SELECT id, name, description, component_id, location, bits32, bits64, 
	    required_32bits, required_64bits, leverage, result_32bits, result_64bits, selected_by_32bits, selected_by_64bits, confirmed_by_32bits, confirmed_by_64bits, leverage_comp_32bits, leverage_comp_64bits FROM testplan_desc 
		WHERE cert_id = 11605 ORDER BY component_id, description, name, id"] at Bugzilla/Bug.pm line 594
	Bugzilla::Bug::initBug('Bugzilla::Bug=HASH(0x1d5b4a20)', 945409, 309230) called at Bugzilla/Bug.pm line 107
	Bugzilla::Bug::new('Bugzilla::Bug', 945409, 309230) called at /var/www/html/hwcert/show.cgi line 90
For help, please send mail to the webmaster (bugzilla-owner), giving this error message and the time and date of the error.
"""

How to reproduce:
Hardware Catalog Home -> search for 3com -> open a cert

Comment 1 Huan Zhang 2013-10-29 05:24:49 UTC

tfu has fixed this, thanks for his efforts.

This is verified this on partner.