Sitefinity Reset Project Name
sitefinity | .NET, CMS, Sitefinity | 2022-10-20
sitefinity | .NET, CMS, Sitefinity | 2022-10-20
Replace "name" with SitefinityWebApp
Error: Invalid root node configured for pages.
1/ Change the name in App_Data/Sitefinity/Configuration folder in file ProjectConfig.config to the new desired project name. Sample: In this example, it is "SitefinityWebApp"
2/ Ensure there is no duplicate ProjectConfig.config in the database by checking with this query:
select * from sf_xml_config_items
where path = 'ProjectConfig.config'
If there is another copy of ProjectConfig.config in [sf_xml_config_items] and the property projectName is there, make sure to apply the change also there.
3/ After this check what is the actual project name (the one that must be changed) saved in the database by using this query:
select app_name from sf_schema_vrsns
The result of the query will show what is the current project name that must be changed. Note, the name will be followed by ' / '. The project name follows the naming convention "any name" there is a slash at the end.
4/ Use an automated script to change the value of the app_name in all tables, for example, this script:
SET NOCOUNT ON
DECLARE @stringToFind VARCHAR(100)
DECLARE @stringToReplace VARCHAR(100)
DECLARE @schema sysname
DECLARE @table sysname
DECLARE @count INT
DECLARE @sqlCommand VARCHAR(8000)
DECLARE @where VARCHAR(8000)
DECLARE @columnName sysname
DECLARE @object_id INT
SET @stringToFind = 'cwp-sf-base'
SET @stringToReplace = 'SitefinityWebApp'
DECLARE TAB_CURSOR CURSOR FOR
SELECT B.NAME AS SCHEMANAME,
A.NAME AS TABLENAME,
A.OBJECT_ID
FROM sys.objects A
INNER JOIN sys.schemas B
ON A.SCHEMA_ID = B.SCHEMA_ID
WHERE TYPE = 'U'
ORDER BY 1
OPEN TAB_CURSOR
FETCH NEXT FROM TAB_CURSOR
INTO @schema,
@table,
@object_id
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE COL_CURSOR CURSOR FOR
SELECT A.NAME
FROM sys.columns A
INNER JOIN sys.types B
ON A.SYSTEM_TYPE_ID = B.SYSTEM_TYPE_ID
WHERE OBJECT_ID = @object_id
AND IS_COMPUTED = 0
AND B.NAME IN ('char','nchar','nvarchar','varchar','text','ntext')
OPEN COL_CURSOR
FETCH NEXT FROM COL_CURSOR
INTO @columnName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @sqlCommand = 'UPDATE ' + @schema + '.' + @table + ' SET [' + @columnName
+ '] = REPLACE(convert(nvarchar(max),[' + @columnName + ']),'''
+ @stringToFind + ''',''' + @stringToReplace + ''')'
SET @where = ' WHERE [' + @columnName + '] LIKE ''%' + @stringToFind + '%'''
EXEC( @sqlCommand + @where)
SET @count = @@ROWCOUNT
IF @count > 0
BEGIN
PRINT @sqlCommand + @where
PRINT 'Updated: ' + CONVERT(VARCHAR(10),@count)
PRINT '----------------------------------------------------'
END
FETCH NEXT FROM COL_CURSOR
INTO @columnName
END
CLOSE COL_CURSOR
DEALLOCATE COL_CURSOR
FETCH NEXT FROM TAB_CURSOR
INTO @schema,
@table,
@object_id
END
CLOSE TAB_CURSOR
DEALLOCATE TAB_CURSOR
5/ Restart the site in order to apply the changed.
6/ Test if all modules in the site open up and work properly. Changing the project name impacts the ability for a Sitefinity module to work.
7/ Open all modules in Sitefinity backend (all backend screens) and if no errors are shown the process is completed.