Bug 117492

Summary: sql/oracle-se/upgrade/5.2.1-6.0.0/auto-upgrade.sql uncomplete for publish_to_fs_files
Product: [Retired] Red Hat Enterprise CMS Reporter: durnez <vdurnez>
Component: otherAssignee: ccm-bugs-list
Status: CLOSED WONTFIX QA Contact: Jon Orris <jorris>
Severity: high Docs Contact:
Priority: medium    
Version: 6.0   
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2006-09-05 17:24:31 UTC Type: ---
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: 108447    

Description durnez 2004-03-04 16:57:42 UTC
Description of problem:

publish_to_fs_files is not altered completely : 
item_type column can be null 
and com.ad.cms.publishToFile.PublishToFile does not accept that in
method :
File getFile() {
DestinationStub dest = PublishToFile.getDestination(getItemType());
File f = new File(dest.getFile(),[...]

extra queries should be added to 
sql/oracle-se/upgrade/5.2.1-6.0.0/auto-upgrade.sql :

update publish_to_fs_files set item_type=(select object_type from
acs_objects where object_id=draft_id);
alter table publish_to_fs_files modify (item_type not null);

Comment 1 Jon Orris 2006-09-05 17:24:31 UTC
Closing old tickets