Bug 92376

Summary: cms_items has null type_id values for live content items
Product: [Retired] Red Hat Enterprise CMS Reporter: Bryan Che <bche>
Component: otherAssignee: ccm-bugs-list
Status: CLOSED WONTFIX 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: 2005-09-29 14:39:45 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Description Bryan Che 2003-06-05 16:21:53 UTC
I published cms articles using my data population code.  However, these query
returns results look suspicious to me:

SQL> select count(*) from cms_items where version='live' and type_id is not null;

  COUNT(*)
----------
         0

SQL> select distinct type_id from cms_items where version <> 'live';

   TYPE_ID
----------
        56
       111