Bug 105682
| Summary: | update from ImageAsset to ReusableImageAsset for article images missed live images which no longer had live articles pointing to them | ||
|---|---|---|---|
| Product: | [Retired] Red Hat Enterprise CMS | Reporter: | Scott Seago <sseago> |
| Component: | content types | Assignee: | Archit Shah <archit.shah> |
| Status: | CLOSED NOTABUG | QA Contact: | Jon Orris <jorris> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | nightly | ||
| 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-03-09 15:42:07 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: | 100952 | ||
added to 6.0.1 upgrade (change 38906) |
Description of problem: update from ImageAsset to ReusableImageAsset for article images missed live images which no longer had an article pointing to it. Version-Release number of selected component (if applicable): 5.2,6.0,rickshaw How reproducible: problem occurs if legacy data had live article images with no current live articles pointing to them Fixed for 5.2 (as upgrade script) on london branch at 36382. For 6.0+, since cms_version_map has gone away, the proper upgrade script would be this, instead: update acs_objects set object_type='com.arsdigita.cms.ReusableImageAsset' where object_id in (select i.item_id from cms_items i, acs_objects o where i.master_id=o.object_id and o.object_type='com.arsdigita.cms.ReusableImageAsset' ) and object_type='com.arsdigita.cms.ImageAsset';