Knowledge Base — Ektron Resources

  • Security Checklist

    Follow these steps to maximize security in your Ektron CMS400.Net Web site.

    Best Practices for Securing Ektron CMS400.Net

  • Change Ecommerce content status via database

    When you need to change the status of ecommerce content in the workarea, there are many tables that need to be updated.  This process  may need to be run in cases where a content item is displaying an error in the workarea, or the status is not in a recognized state.  The following script will resolve the issue on that one content item by updating the status information.

    Before you make an changes to the database, please make a back up!


    declare @content_id bigint;
    declare @content_language int;
    set @content_language = 1033
    set @content_id = 3387 --Need to change this to the content that is having the problem
    delete from approval_status_tbl where content_id=@content_id and content_language=@content_language
    delete from approval_tbl where content_id=@content_id and content_language=@content_language
    delete from save_meta_tbl where save_id in (select save_id from save_tbl where content_id=@content_id and content_language=@content_language )
    delete from save_tbl where content_id=@content_id and content_language=@content_language
    delete from edit_meta_tbl where content_id=@content_id and content_language=@content_language
    delete from content_edit where content_id=@content_id and content_language=@content_language
    update content set content_status='A' where content_id=@content_id and content_language=@content_language
    update catalog_entry_tbl set entry_status='A' where entry_id=@content_id and entry_status_language=@content_language

    UPDATE catalog_entry_version_tbl
    SET history_id = (select top 1 history_id from content_history WHERE content_id =@content_id and content_status = 'A' order by history_id desc)
    where entry_id = @content_id and audit_id =(select top 1 audit_id from catalog_entry_version_tbl where entry_id = @content_id order by audit_id desc)

    UPDATE cms_audit_tbl
    set status = 'A'
    where audit_id = (select top 1 a.audit_id from cms_audit_tbl a INNER JOIN catalog_entry_version_tbl e ON a.audit_id = e.audit_id WHERE e.entry_id = @content_id AND a.status = 'O' order by created desc)

    update entry_price_version_tbl
    set priceid = (select priceid from entry_price_tbl where entryid = @content_id)
    where entryauditid = (select top 1 audit_id from catalog_entry_version_tbl where entry_id = @content_id order by audit_id desc)

  • Change content status via database

    When you need to change the content status via the database, you need to change more then just the content_status column in the content table. This process may need to be run in cases where a content item is displaying an error in the workarea, or the status is not in a recognized state. The following script will fix the issue by updating the content item's status as well as associated tables.

Don’t see what you’re looking for? Check out our forums. We have a large community of passionate, helpful developers.

What Do You Think of our New Design?

    

Have more to say? We’d love to hear it!