Restore an accidentally deleted image in BBIS

By: Chris Whisenhunt

Posted on: February 9, 2017

Ever had an image accidentally deleted in BBIS? Read on to find out how to restore it!

Images in BBIS are handled via an image handler and are stored in the database. Before restoring the database give this a try.

declare @IMAGEID int = 3558;
declare @IMAGEKEY nvarchar(50) = 'Image_' + cast(@IMAGEID as nvarchar(10)) + '_0',
@CURRENTDATE datetime = getdate();

update SITEIMAGES set DELETED = 0, INTRASHBIN = 0 where ID = @IMAGEID;
exec spAddUpdate_CacheItem @IMAGEKEY, @CURRENTDATE, 0;

🙂 Happy coding!

* this has only been tested in BBIS 6.64.166.0 (CRM 4)

Leave a Reply

Privacy Policy | Sitemap | © 2011 Blackbaud, Inc. All Rights Reserved

Digital Ocean