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...Upgrade from 5.1.4 to 5.5.1 failure...Upgrade from 5.1.4 to 5.5.1 failure...
Previous
 
Next
New Post
11/19/2010 12:16 AM
 
I re-ran upgrade and found the following:
System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
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)



/* Fix incorrect culture codes assigned pre-5.5 */
/************************************************/

UPDATE dbo.Tabs
SET CultureCode = NULL
 
New Post
11/19/2010 12:34 AM
 
BTW, just learned that atleast the first issue I had with the Tabs, was caused by the DNN360Menu. I have instructions on how to fix this, thanks to the forums (see below). Still looking for resolution on other issues.

Upgrade of CISS Menu:

DISABLE
TRIGGER DNN360Menu_Update on Tabs;
DISABLE
TRIGGER DNN360Menu_delete on Tabs;
DISABLE
TRIGGER DNN360Menu_Insert on Tabs;


After the upgrade;

ENABLE
TRIGGER DNN360Menu_Update on Tabs;
ENABLE
TRIGGER DNN360Menu_delete on Tabs;
ENABLE
TRIGGER DNN360Menu_Insert on Tabs;
 
New Post
11/22/2010 8:19 AM
 
Hello again everyone,

As of last friday, I attempted to do another upgrade. I tried from 5.1.4 to 5.6.0. This failed as well. I did find that we had the site running in ASP.NET 2, but upon switching it to ASP.NET 4, the site would not load. We received many errors related to the web.config. Upon cleaning up all the errors, basic usability of the DNN site changed.

The lines we ended up having to remove from our web.config are:






We then cleared out the files of the "App_Browsers" folder. This allowed our site to load, but then we had a series of weird issues such as the Login page not working, or image links would show borders which originally did not.

Any thoughts on this? I feel that until we can get our current site to load in ASP.NET 4, researching the other issues is not worth the time.

Thanks.
 
New Post
11/22/2010 2:29 PM
 
ASP.Net 2.0 is fine, as long as .Net 3.5SP1 is installed. you shouldn't touch your web.config for the upgrade at all. you may clear old files before the new files are unzipped, but the core is usually taking care of orphaned files. Please make sure, you grant full file system permissions for all files and subfolders to the windows account used by ASP.Net (as specified in IIS App Pool).

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
11/22/2010 2:43 PM
 
Hi, yeah... we dont have .net 3.5 SP1 installed. Which is being resolved now.

As for my web.config, I removed the telerik entry I had in there for another module which is no longer used.

We also proivided full permissions to the App Pool, with no success.

We still have a configuration file that has 3-4 failures during updates. I did find a module that causes a failed upgrade as well, so that is being worked on as well.

Thanks for the reply! :)

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Upgrade from 5.1.4 to 5.5.1 failure...Upgrade from 5.1.4 to 5.5.1 failure...


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