Content not checking in using the Workarea

  • Updated

There are rare occasions when you cannot check in content using the Workarea. For example, one user who is not available may have left content checked out but another user cannot check it back in.

When a content item cannot be checked back in using the Workarea, use the following SQL script to return the content to "A" status.

Warning: Do not use the script for eCommerce content (products) because there are additional tables involved.

*For eCommerce refer to the following KB article:  eCommerce Content not checking in using the workarea

Before executing the script:

  1. Backup the database .
  2. Update the script with the target content_id and content_language by replacing the text TYPE_YOUR_CONTENT_ID and TYPE_YOUR_CONTENT_LANG with the actual IDs.
DECLARE @content_id bigint,@content_language INT
SET @content_id=TYPE_YOUR_CONTENT_ID --ex. 30
SET @content_language=TYPE_YOUR_CONTENT_LANG --ex. US English = 1033
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 
WAITFOR DELAY '00:00:05'
UPDATE content SET content_status='A' WHERE content_id=@content_id AND content_language=@content_language
GO