Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Big refresh: How to upgrade from 03.03.05 to something actual ???Big refresh: How to upgrade from 03.03.05 to something actual ???
Previous
 
Next
New Post
1/6/2016 2:03 PM
 
Hello!

Today I upgrade from 3.3.5.->3.3.6->3.3.7->4.3.7
1st. I delete *.zip files from install\module folder and upgrade to 3.3.7 goes without error, forum stay in right state.
2nd. I try upgrade 3.3.7 -> 4.3.7 and get 2 errors. Can you tell me, are these errors critical ? Log:

Upgrade Status Report
00:00:00.015 - Upgrading to Version: 4.0.0 Success
00:00:00.670 - Upgrading to Version: 4.0.1 Success
00:00:00.780 - Upgrading to Version: 4.0.2 Success
00:00:00.826 - Upgrading to Version: 4.0.3 Success
00:00:00.842 - Upgrading to Version: 4.0.4 Success
00:00:01.669 - Upgrading to Version: 4.0.5 Success
00:00:01.669 - Upgrading to Version: 4.0.6 Success
00:00:01.669 - Upgrading to Version: 4.0.7 Success
00:00:01.669 - Upgrading to Version: 4.3.0 Success
00:00:01.700 - Upgrading to Version: 4.3.1 Error! (seeC:\Portal\Providers\DataProviders\SqlDataProvider\04.03.01.log for more information)
00:00:01.825 - Upgrading to Version: 4.3.2 Success
00:00:01.934 - Upgrading to Version: 4.3.3 Success
00:00:02.043 - Upgrading to Version: 4.3.4 Success
00:00:02.074 - Upgrading to Version: 4.3.5 Error! (seeC:\Portal\Providers\DataProviders\SqlDataProvider\04.03.05.log for more information)
00:00:02.215 - Upgrading to Version: 4.3.6 Success
00:00:02.277 - Upgrading to Version: 4.3.7 Success
00:00:02.511 - Performing General Upgrades
Upgrade Complete

4.3.1. :
System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Files_Folders". The conflict occurred in database "DotNetNuke", table "dbo.Folders", column 'FolderID'.
at System.Data.SqlClient.SqlConnection. (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)


/* This tries to apply a foreign key on the files/folders tables */
/*****************************************************************/

IF NOT EXISTS ( SELECT * FROM sysobjects WHERE id = object_id(N'FK_Files_Folders') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
BEGIN
ALTER TABLE dbo.Files ADD CONSTRAINT
FK_Files_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.Folders
(
FolderID
)
END

4.3.5:

System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'LastUpdated' in table 'dbo.Folders' is specified more than once.
at System.Data.SqlClient.SqlConnection. (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)


/* Add LastUpdated Column to Folders */
/*************************************/

ALTER TABLE dbo.Folders ADD
LastUpdated datetime NOT NULL CONSTRAINT DF_Folders_LastUpdated DEFAULT getUtcDate()
 
New Post
1/6/2016 5:17 PM
 
you may ignore the second error, it tries to re-apply a previously added column again.
for the first error, please execute
DELETE FROM Files WHERE FolderID NOT IN (SELECT FolderID FROM Folders).
Afterwards you may simply run
IF NOT EXISTS ( SELECT * FROM sysobjects WHERE id = object_id(N'FK_Files_Folders') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
BEGIN
ALTER TABLE dbo.Files ADD CONSTRAINT
FK_Files_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.Folders
(
FolderID
)
END

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
1/7/2016 4:46 AM
 

Thank you!

After applaying scripts site works OK .

1) Does your script make the same, that scripts in this post?

http://staging301.dnnsoftware.com/community-blog/cid/135317/preparing-for-an-upgrade

2) I try upgrade 4.4.1 -> 4.6.2 and get strange log. It look like all is OK, but one error message after log:

-------------------------------------------------------------------------------------------

Current Assembly Version: 04.06.02

Current Database Version: 04.04.01

Upgrade Status Report

00:00:00.078 - Upgrading to Version: 4.6.2

00:00:00.140 -   Executing Script: 04.05.00.SqlDataProvider Success

00:00:01.825 -   Executing Script: 04.05.01.SqlDataProvider Success

00:00:02.168 -   Executing Script: 04.05.02.SqlDataProvider Success

00:00:02.464 -   Executing Script: 04.05.03.SqlDataProvider Success

00:00:02.496 -   Executing Script: 04.05.04.SqlDataProvider Success

00:00:02.527 -   Executing Script: 04.05.05.SqlDataProvider Success

00:00:02.527 -   Executing Script: 04.06.00.SqlDataProvider Success

00:00:03.135 -   Executing Script: 04.06.01.SqlDataProvider Success

00:00:03.135 -   Executing Script: 04.06.02.SqlDataProvider Success

00:00:03.135 - Performing General Upgrades

--------------------------------------------------------------------------------

 

Server Error in '/Optolover' Application.

--------------------------------------------------------------------------------

 

Data at the root level is invalid. Line 1, position 1. 

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

 

Exception Details: System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.

 

Source Error: 

 

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

 

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

 

  <%@ Page Language="C#" Debug="true" %>

 

or:

 

2) Add the following section to the configuration file of your application:

 

<configuration>

   <system.web>

       <compilation debug="true"/>

   </system.web>

</configuration>

 

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

 

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.  

 

Stack Trace: 

 

 

[XmlException: Data at the root level is invalid. Line 1, position 1.]

   System.Xml.XmlTextReaderImpl.Throw(Exception e) +95

   System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() +5086762

   System.Xml.XmlTextReaderImpl.ParseDocumentContent() +298

   System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) +165

   System.Xml.XmlDocument.Load(XmlReader reader) +134

   System.Xml.XmlDocument.Load(String filename) +95

   DotNetNuke.Modules.Admin.ResourceInstaller.ResourceInstaller.InstallPortal(String strFile, Boolean writeFeedback, Int32 indent) +269

   DotNetNuke.Modules.Admin.ResourceInstaller.ResourceInstaller.Install(Boolean writeFeedback, Int32 indent, String type) +890

   DotNetNuke.Services.Install.Install.UpgradeApplication() +1130

   DotNetNuke.Services.Install.Install.Page_Load(Object sender, EventArgs e) +320

   System.Web.UI.Control. (EventArgs e) +132

   System.Web.UI.Control.LoadRecursive() +66

   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

--------------------------------------------------------------------------

Site works now on 4.6.2 , but when I try upgrade some module  finished with the same message.

Is it critical error? 

 
New Post
1/7/2016 12:36 PM
 
1) No, Erik is focusing on different issues in his thread.
2) enable Debug as described and try to get more details. You might need to compare your web.config with release.config, which comes with the DNN upgrade package (when upgrading from a version less than 4.6.0, you have to merge web.config updates manually. Use a text comparison tool. Do NOT modify machine key or encryption key!!

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
1/8/2016 2:20 PM
 

Sebastian, thank you!

I try upgrade 4.4.1->4.5.5.   All was OK.

Then I try again upgrade to 4.9.5 and get same error.

I enable Debug in web.config, and try upgrade 4.5.5->4.9.5 and get error with more informative log.

Can you give me some advise in this case:

Upgrading DotNetNuke

Current Assembly Version: 04.09.05

Current Database Version: 04.05.05



Upgrade Status Report

00:00:00.015 - Upgrading to Version: 4.9.5
00:00:02.184 -   Executing Script: 04.06.00.SqlDataProvider Success
00:00:04.602 -   Executing Script: 04.06.01.SqlDataProvider Success
00:00:04.602 -   Executing Script: 04.06.02.SqlDataProvider Success
00:00:04.602 -   Executing Script: 04.07.00.SqlDataProvider Success
00:00:05.132 -   Executing Script: 04.08.00.SqlDataProvider Success
00:00:05.210 -   Executing Script: 04.08.01.SqlDataProvider Success
00:00:05.304 -   Executing Script: 04.08.02.SqlDataProvider Success
00:00:05.319 -   Executing Script: 04.08.03.SqlDataProvider Success
00:00:05.319 -   Executing Script: 04.08.04.SqlDataProvider Success
00:00:05.319 -   Executing Script: 04.09.00.SqlDataProvider Success
00:00:05.366 -   Executing Script: 04.09.01.SqlDataProvider Success
00:00:05.506 -   Executing Script: 04.09.02.SqlDataProvider Success
00:00:05.943 -   Executing Script: 04.09.03.SqlDataProvider Success
00:00:05.959 -   Executing Script: 04.09.04.SqlDataProvider Success
00:00:05.974 -   Executing Script: 04.09.05.SqlDataProvider Success
00:00:05.974 - Performing General Upgrades


 


Server Error in '/MyWeb' Application.

Data at the root level is invalid. Line 1, position 1.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.

Source Error:

Line 174:
Line 175:                        'Install Resources
Line 176:                        ResourceInstaller.Install(True, 0)
Line 177:
Line 178:                        Response.Write("<h2>Upgrade Complete</h2>")


Source File: C:\Portal\install\Install.aspx.vb    Line: 176

Stack Trace:

[XmlException: Data at the root level is invalid. Line 1, position 1.]
   System.Xml.XmlTextReaderImpl.Throw(Exception e) +95
   System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() +5086762
   System.Xml.XmlTextReaderImpl.ParseDocumentContent() +298
   System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) +165
   System.Xml.XmlDocument.Load(XmlReader reader) +134
   System.Xml.XmlDocument.Load(String filename) +95
   DotNetNuke.Modules.Admin.ResourceInstaller.ResourceInstaller.InstallPortal(String strFile, Boolean writeFeedback, Int32 indent) +269
   DotNetNuke.Modules.Admin.ResourceInstaller.ResourceInstaller.Install(Boolean writeFeedback, Int32 indent, String type) +890
   DotNetNuke.Services.Install.Install.UpgradeApplication() in C:\Portal\install\Install.aspx.vb:176
   DotNetNuke.Services.Install.Install.Page_Load(Object sender, EventArgs e) in C:\Portal\install\Install.aspx.vb:348
   System.Web.UI.Control. (EventArgs e) +132
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428


 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Big refresh: How to upgrade from 03.03.05 to something actual ???Big refresh: How to upgrade from 03.03.05 to something actual ???


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out