The upgrade went well except for two scripts. I included the log below. Is there a way to validate the schema? I also noticed the slashes in my original installation went the other way. The new web.config looked a little different (slashes other way). I also included the donnetnuke section of the webconfig maybe someone can see an error.
4.00.4
System.Data.SqlClient.SqlException: Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
Incorrect syntax near 'LastUpdated'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Transfer Profile */
/*********************/
If (SELECT quser.fn_GetVersion(3,2,3)) = 0
BEGIN
--Create Temp Table
CREATE TABLE quser.FlatProfile (
[UserID] [int] ,
[PortalID] [int],
[Username] [nvarchar] (256) NULL ,
[FirstName] [nvarchar] (256) NULL ,
[LastName] [nvarchar] (256) NULL ,
[Street] [nvarchar] (256) NULL ,
[Unit] [nvarchar] (128) NULL ,
[City] [nvarchar] (256) NULL ,
[Country] [nvarchar] (256) NULL ,
[Region] [nvarchar] (256) NULL ,
[PostalCode] [nvarchar] (128) NULL ,
[Telephone] [nvarchar] (128) NULL ,
[Cell] [nvarchar] (128) NULL ,
[Fax] [nvarchar] (128) NULL ,
[Website] [nvarchar] (256) NULL ,
[IM] [nvarchar] (256) NULL,
[PreferredLocale] [nvarchar] (128) NULL ,
[TimeZone] [nvarchar] (256) NULL,
[LastUpdatedDate] [datetime]
)
--Extract from Profile Blob to Temp Table
INSERT INTO quser.FlatProfile
SELECT
quser.users.userid,
quser.userportals.portalid,
quser.users.username,
quser.users.firstname,
quser.users.lastname,
quser.GetProfileElement('Street',PropertyNames,PropertyValuesString) Street,
quser.GetProfileElement('Unit',PropertyNames,PropertyValuesString) Unit,
quser.GetProfileElement('City',PropertyNames,PropertyValuesString) City,
quser.GetProfileElement('Country',PropertyNames,PropertyValuesString) Country,
quser.GetProfileElement('Region',PropertyNames,PropertyValuesString) Region,
quser.GetProfileElement('PostalCode',PropertyNames,PropertyValuesString) PostalCode,
quser.GetProfileElement('Telephone',PropertyNames,PropertyValuesString) Telephone,
quser.GetProfileElement('Cell',PropertyNames,PropertyValuesString) Cell,
quser.GetProfileElement('Fax',PropertyNames,PropertyValuesString) Fax,
quser.GetProfileElement('Website',PropertyNames,PropertyValuesString) Website,
quser.GetProfileElement('IM',PropertyNames,PropertyValuesString) IM,
quser.GetProfileElement('PreferredLocale',PropertyNames,PropertyValuesString) PreferredLocale,
quser.GetProfileElement('TimeZone',PropertyNames,PropertyValuesString) TimeZone,
aspnet_profile.LastUpdatedDate
FROM quser.Users
inner join quser.userportals on quser.users.userid = quser.userportals.userid
inner join aspnet_users on quser.users.username = aspnet_users.username
inner join aspnet_profile on aspnet_profile.userid = aspnet_users.userid
where quser.userportals.portalid = PortalID
--Move to UserProfile Table
EXECUTE quser.TransferUsersFromFlatProfile N'FirstName'
EXECUTE quser.TransferUsersFromFlatProfile N'LastName'
EXECUTE quser.TransferUsersFromFlatProfile N'Unit'
EXECUTE quser.TransferUsersFromFlatProfile N'Street'
EXECUTE quser.TransferUsersFromFlatProfile N'City'
EXECUTE quser.TransferUsersFromFlatProfile N'Region'
EXECUTE quser.TransferUsersFromFlatProfile N'PostalCode'
EXECUTE quser.TransferUsersFromFlatProfile N'Country'
EXECUTE quser.TransferUsersFromFlatProfile N'Telephone'
EXECUTE quser.TransferUsersFromFlatProfile N'Fax'
EXECUTE quser.TransferUsersFromFlatProfile N'Cell'
EXECUTE quser.TransferUsersFromFlatProfile N'Website'
EXECUTE quser.TransferUsersFromFlatProfile N'IM'
EXECUTE quser.TransferUsersFromFlatProfile N'TimeZone'
EXECUTE quser.TransferUsersFromFlatProfile N'PreferredLocale'
--Drop temp objects
DROP TABLE quser.FlatProfile
DROP PROCEDURE quser.TransferUsersFromFlatProfile
END
4.04.00
Error: HelpURL
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Web.config (dotnetnuke section)
<dotnetnuke>
<htmlEditor defaultProvider="Ftb3HtmlEditorProvider">
<providers>
<clear/>
<add name="FckHtmlEditorProvider"
type="DotNetNuke.HtmlEditor.FckHtmlEditorProvider.FckHtmlEditorProvider, DotNetNuke.FckHtmlEditorProvider"
providerPath="~/Providers/HtmlEditorProviders/Fck/"
CustomConfigurationPath="~/Providers/HtmlEditorProviders/Fck/custom/FCKConfig.js"
EnhancedSecurityDefault="false"
SecureConfigurationPath="~/Providers/HtmlEditorProviders/Fck/custom/FCKConfigSecure.js"
ImageGalleryPath="~/Providers/HtmlEditorProviders/Fck/fckimagegallery.aspx"
ImageUploadPath="~/Providers/HtmlEditorProviders/Fck/fckimagegallery.aspx"
ImageAllowedFileTypes="gif,png,bmp,jpg"
FlashGalleryPath="~/Providers/HtmlEditorProviders/Fck/fckimagegallery.aspx"
FlashUploadPath="~/Providers/HtmlEditorProviders/Fck/fckimagegallery.aspx"
FlashAllowedFileTypes="fla,swf"
LinksGalleryPath="~/Providers/HtmlEditorProviders/Fck/fcklinkgallery.aspx"
DynamicStylesGeneratorPath="~/Providers/HtmlEditorProviders/Fck/FCKStyles.aspx"
DynamicStylesCaseSensitive="true"
DynamicStylesGeneratorFilter="controlpanel|filemanager|mainmenu|wizard"
StaticStylesFile="~/Providers/HtmlEditorProviders/Fck/FCKeditor/fckstyles.xml"
StylesDefaultMode="Static"
DynamicCSSGeneratorPath="~/Providers/HtmlEditorProviders/Fck/FCKCSS.aspx"
StaticCSSFile="~/Providers/HtmlEditorProviders/Fck/FCKeditor/editor/css/fck_editorarea.css"
CSSDefaultMode="static"
spellCheck="ieSpell"
AvailableToolbarSkins="Office2003,Silver"
DefaultToolbarSkin="Office2003"
AvailableToolBarSets="DNNDefault,Default,NoGallery,Basic"
DefaultToolbarSet="DNNDefault"
DefaultImageGallerySkin="Default"
DefaultFlashGallerySkin="Default"
DefaultLinksGallerySkin="Default"
FCKDebugMode="false"
UseFCKSource="false"
OptionsOpenMode="ShowModalDialog"
CustomOptionsDialog="Admin" />
</providers>
</htmlEditor>
<navigationControl
defaultProvider="SolpartMenuNavigationProvider">
<providers>
<clear/>
<add
name="SolpartMenuNavigationProvider"
type="DotNetNuke.NavigationControl.SolpartMenuNavigationProvider, DotNetNuke.SolpartMenuNavigationProvider"
providerPath="~\Providers\NavigationProviders\SolpartMenuNavigationProvider\"/>
<add
name="DNNMenuNavigationProvider"
type="DotNetNuke.NavigationControl.DNNMenuNavigationProvider, DotNetNuke.DNNMenuNavigationProvider"
providerPath="~\Providers\NavigationProviders\DNNMenuNavigationProvider\"/>
<add
name="DNNTreeNavigationProvider"
type="DotNetNuke.NavigationControl.DNNTreeNavigationProvider, DotNetNuke.DNNTreeNavigationProvider"
providerPath="~\Providers\NavigationProviders\DNNTreeNavigationProvider\"/>
<add
name="DNNDropDownNavigationProvider"
type="DotNetNuke.NavigationControl.DNNDropDownNavigationProvider, DotNetNuke.DNNDropDownNavigationProvider"
providerPath="~\Providers\NavigationProviders\DNNDropDownNavigationProvider\"/>
<add
name="ASP2MenuNavigationProvider"
type="DotNetNuke.NavigationControl.ASP2MenuNavigationProvider, DotNetNuke.ASP2MenuNavigationProvider"
providerPath="~\Providers\NavigationProviders\ASP2MenuNavigationProvider\"/>
</providers>
</navigationControl>
<searchIndex
defaultProvider="ModuleIndexProvider">
<providers>
<clear/>
<add
name="ModuleIndexProvider"
type="DotNetNuke.Services.Search.ModuleIndexer, DotNetNuke.Search.Index"
providerPath="~\Providers\SearchProviders\ModuleIndexer\"/>
</providers>
</searchIndex>
<searchDataStore
defaultProvider="SearchDataStoreProvider">
<providers>
<clear/>
<add
name="SearchDataStoreProvider"
type="DotNetNuke.Services.Search.SearchDataStore, DotNetNuke.Search.DataStore"
providerPath="~\Providers\SearchProviders\SearchDataStore\"/>
</providers>
</searchDataStore>
<data defaultProvider="SqlDataProvider">
<providers>
<clear/>
<add
name="SqlDataProvider"
type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
connectionStringName="SiteSqlServer"
upgradeConnectionString=""
providerPath="~\Providers\DataProviders\SqlDataProvider\"
objectQualifier=""
databaseOwner="quser"/>
</providers>
</data>
<logging defaultProvider="DBLoggingProvider">
<providers>
<clear/>
<add
name="XMLLoggingProvider"
type="DotNetNuke.Services.Log.EventLog.XMLLoggingProvider, DotNetNuke.XMLLoggingProvider"
configfilename="LogConfig.xml.resources"
providerPath="~\Providers\LoggingProviders\XMLLoggingProvider\"/>
<add
name="DBLoggingProvider"
type="DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider, DotNetNuke.Provider.DBLoggingProvider"
providerPath="~\Providers\LoggingProviders\Provider.DBLoggingProvider\"/>
</providers>
</logging>
<scheduling defaultProvider="DNNScheduler">
<providers>
<clear/>
<add
name="DNNScheduler"
type="DotNetNuke.Services.Scheduling.DNNScheduling.DNNScheduler, DotNetNuke.DNNScheduler"
providerPath="~\Providers\SchedulingProviders\DNNScheduler\"
debug="false"
maxThreads="1"/>
</providers>
</scheduling>
<friendlyUrl
defaultProvider="DNNFriendlyUrl">
<providers>
<clear/>
<add
name="DNNFriendlyUrl"
type="DotNetNuke.Services.Url.FriendlyUrl.DNNFriendlyUrlProvider, DotNetNuke.HttpModules.UrlRewrite"
includePageName="true"
regexMatch="[^a-zA-Z0-9 _-]" />
</providers>
</friendlyUrl>
<caching
defaultProvider="FileBasedCachingProvider">
<providers>
<clear/>
<add
name="FileBasedCachingProvider"
type="DotNetNuke.Services.Cache.FileBasedCachingProvider.FBCachingProvider, DotNetNuke.Caching.FileBasedCachingProvider"
providerPath="~\Providers\CachingProviders\FileBasedCachingProvider\"/>
<add
name="BroadcastPollingCachingProvider"
type="DotNetNuke.Services.Cache.BroadcastPollingCachingProvider.BPCachingProvider, DotNetNuke.Caching.BroadcastPollingCachingProvider"
providerPath="~\Providers\CachingProviders\BroadcastPollingCachingProvider\"/>
</providers>
</caching>
<authentication
defaultProvider="ADSIAuthenticationProvider">
<providers>
<clear />
<add name="ADSIAuthenticationProvider"
type="DotNetNuke.Security.Authentication.ADSIProvider, DotNetNuke.Authentication.ADSIProvider"
providerPath="~\Providers\AuthenticationProviders\ADSIProvider\" />
</providers>
</authentication>
<members defaultProvider="AspNetMembershipProvider">
<providers>
<clear/>
<add name="AspNetMembershipProvider"
type="DotNetNuke.Security.Membership.AspNetMembershipProvider, DotNetNuke.Provider.AspNetProvider"
providerPath="~\Providers\MembershipProviders\AspNetMembershipProvider\"/>
</providers>
</members>
<roles defaultProvider="DNNRoleProvider">
<providers>
<clear/>
<add name="DNNRoleProvider"
type="DotNetNuke.Security.Membership.DNNRoleProvider, DotNetNuke.Provider.DNNProvider"
providerPath="~\Providers\MembershipProviders\DNNMembershipProvider\"/>
</providers>
</roles>
<profiles defaultProvider="DNNProfileProvider">
<providers>
<clear/>
<add name="DNNProfileProvider"
type="DotNetNuke.Security.Profile.DNNProfileProvider, DotNetNuke.Provider.DNNProvider"
providerPath="~\Providers\MembershipProviders\DNNMembershipProvider\"/>
</providers>
</profiles>
</dotnetnuke>