I tried to upgrade the current DNN 5.5.1 to DNN 5.6.7 using the DNN 5.6.7 upgrade software. However, there was an upgrade error "The directory '/xxx/App_GlobalResources/' is not allowed because the application is precompiled. " What can be done to resolve the error ?

After looking at everything and re-reading the threads, I found the cause of the error and was able to fix if using a piece of code from a previous version of DNN.

The cause of this error stems from the following section of code in the vw.Modules view:

Case when tm.IconFile LIKE 'fileid=%'
then (SELECT IsNull(Folder, '') + [FileName] FROM dbo.[vw_Files]
WHERE fileid = CAST(SUBSTRING(tm.IconFile, 8, 10) AS Int))
else Coalesce(tm.IconFile,'')
end as IconFile,
CASE WHEN LEFT(LOWER(TM.IconFile), 6) = 'fileid' THEN (SELECT Folder + FileName FROM dbo.Files WHERE 'fileid=' + CONVERT(varchar, dbo.Files.FileID) = TM.IconFile) ELSE TM.IconFile END AS IconFile,

When you dissect that statement, it fails when trying to do the following:

CAST(SUBSTRING(tm.IconFile, 8, 10) AS Int)

Because the substring that it's utilizing is the file location of the IconFile column, it cannot convert or cast the text string to a number. It would be different if it were trying to convert a text value which is a number. For example try the following:

since tm.IconFile represents a value in a column we can substitute it with "~/Icons/Sigma/SiteSettings_32X32_Standard.png"

SELECT SUBSTRING('~/Icons/Sigma/SiteSettings_32X32_Standard.png', 8, 10)
RETURNS: /Sigma/Sit

Now cast it as an Int.
SELECT CAST('/Sigma/Sit' as int)
RETURNS: Conversion failed when converting the varchar value '/Sigma/Sit' to data type int.

When executing the SPROC GetModuleByDefinition, it uses the vw.Modules view and joins it with other tables. The error is only encountered on specific module definition names entered into the SPROC's parameters. For Example:

DECLARE @return_value int
EXEC @return_value = [dbo].[GetModuleByDefinition]
@PortalId = 0,
@DefinitionName = N'Site Settings'
SELECT 'Return Value' = @return_value

Returns the error referenced in this thread.

Basically any module definition which has a value in the IconFile column, which cannot be converted to a numerical value e.g., "~/Icons/Sigma/SiteSettings_32X32_Standard.png", will fail.

I ended up looking at an older version of DNN I had quick access to, (6.2.9) and copied the following line out it's vw.Module view:

CASE WHEN LEFT(LOWER(TM.IconFile), 6) = 'fileid' THEN (SELECT Folder + FileName FROM dbo.Files WHERE 'fileid=' + CONVERT(varchar, dbo.Files.FileID) = TM.IconFile) ELSE TM.IconFile END AS IconFile,

That fixed the issue. Why, because it's using the actual dbo.Files.Fileid in the conversion which is a numerical representation. I haven't checked how the 7.x versions handle that statement, I'm sure there's probably a better way of doing it.

Why this issue seems to appear in certain instances of SQL Versions, I'm not sure. But it's definitely an issue in SQL 2012 Express. The only reason why I'm running it in express is for testing and module development purposes. I have yet to install it on our production and staging environments, which run the full version of SQL 2012. So I'm curious if it's an issue.

Hey Sebastian,

Sorry, my last post was actually intended to resolve the issue in this thread.

http://www.dnnsoftware.com/forums/for...

It seems to fix the 8.0 install error. Sorry that I accidentally posted it here.