Xtremax - Web Design

If you have worked on a DNN project, one of the problems are that the images entered using the HtmlModule is hardcoded with the location of the context path.  This essentially means that any changes in the context path of the web application will result in a tonne load of missing images.

Well, I did remember that MySQL had some simple string replace function to address the problem… and after some surfing on the net… wola… The solution to changing all the image path:

update dbo.dnn_HtmlText set DesktopHtml = REPLACE(Cast(DesktopHtml as NVARCHAR(4000)), ‘/aapaf/Portals/0/banners/side’ ,’/aapaf2/Portals/0/banners/side’);

Yes… I know this is not rocket science… just wanted to blog it down here to remind myself during the migration process… and hopefully.. who knows?  It might just help some frustrated soul in the future…