Sitefinity ASP.NET CMS - Content Management System

Support

KB Article

Home >  Support >  Knowledge Base >  KB Article
Cannot use a leading ... to exit above the top directory - ID#1035
Rating: Not rated
Last Modified: 7/9/2008
Related categories: Workarounds;

Article information

Article relates to

 Sitefinity 3.2 and later

Created by

 Vladimir Vasilev

Last modified by

 Rebecca

Problem
This issue is specific to Firefox only and affects images and links inserted in RadEditor:
the URLs are pointing above the application root and start with ../ .

Solution
Run the following script on your SQL Serever 2005 database. Note that you must replace string_to_be_found and replacement_string with the real values.
It is extremely important to BACK UP your database before executing the script:

UPDATE   sf_CmsControlProperty        
SET      Value = REPLACE(Value, 'string_to_be_found', 'replacement_string')        
WHERE    Name = 'Content' AND (Value LIKE '%string_to_be_found%')      
   
UPDATE   sf_CmsTextContent        
SET      Content = REPLACE(Content, 'string_to_be_found', 'replacement_string')        
WHERE    (Content LIKE '%string_to_be_found%')     
    
UPDATE sf_VrsTxtData           
SET    DataImpl = REPLACE(DataImpl, 'string_to_be_found', 'replacement_string')           
WHERE  KeyValue = 'Content' AND (DataImpl LIKE '%string_to_be_found%')   

You must cast ntext to varchar(8000) or nvarchar(4000) in order to use REPLACE function in SQL Server 2000. For example:

UPDATE sf_VrsTxtData         
SET DataImpl = REPLACE(CAST(DataImpl AS VARCHAR(8000)), 'string_to_be_found', 'replacement_string')         
WHERE (DataImpl LIKE '%string_to_be_found%') 

 

Article Comments

There are no comments yet.
Please Sign In to rate this article or to add it to your favorites.

Copyright 2002 - 2008 © Telerik. All rights reserved | Sitefinity is a registered trademark of Telerik Corp.

a product by telerik