I have some simple questions related to the upgrade of DotNetNuke from 04.04.00 to 04.05.01 as an non experienced DotNetNuke admin.
1) There are many articles on the web proposing that an “<add key =”InstallationDate” value=?” /> should be added to the web.config file. In the case that the web.config file does not include this value, how do one determine at correct date? In the catalog Providers\DataProviders\SqlDataProvider there are some version.log files. Can one determine installation date based on the date of the first version.log (in my case 03.01.01.log) file, or just any date just to prevent encryption keys to be overwritten? Can this be confirmed?
2) There is upgrade problems related to “04.05.01.SqlDataProvider Error!”. These problems seems to be related to SQL routines 04.05.01.SqlDataProvider (..\Providers\DataProviders\SqlDataProvider), that in my case are missing ObjectQualifier has been used in the web.config file. Apparently this problem can be fixed (see below). Thise will make may website function in may test environment. Can this be confirmed?
BEFORE:
/* correct any File folderpaths which do not match the value in the Folders table */
update {objectQualifier}Files
set Folder = FolderPath
from {objectQualifier}Folders
where {objectQualifier}Files.FolderID = {objectQualifier}Folders.FolderID
and Folder <> FolderPath
GO
AFTHER:
/* correct any File folderpaths which do not match the value in the Folders table */
update {databaseOwner}{objectQualifier}Files
set Folder = FolderPath
from {databaseOwner}{objectQualifier}Folders
where {databaseOwner}{objectQualifier}Files.FolderID = {databaseOwner}{objectQualifier}Folders.FolderID
and Folder <> FolderPath
GO
3) When the abow fix has been entered the “04.05.01.SqlDataProvider Error!” will still appear in may case. The fix as I understand this is therefore to delete double records in the files xxx_Files and xxx_Folder, and this can be done by deleting all record with <Null> in the portal ID column. Can this be confirmed?