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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...error upgrade from 4.0.3 to 4.3.3error upgrade from 4.0.3 to 4.3.3
Previous
 
Next
New Post
7/20/2006 5:37 PM
 

I ran into problem when upgrading v. 4.0.3 to 4.3.3.

I copy the new upgrade file to the server, setup web.config using release.config

when I open the IE browser, it gives me warning 'dnn_users' not found.  so I go to the script change it to 'Users', there is users table there.  So it's run update successful.  Now I cannot login.  It's give me login failure.  Any got same experience? Please help!

 
New Post
7/20/2006 5:57 PM
 

Upgrading DotNetNuke

Current Assembly Version: 04.03.03

Current Database Version: 04.00.03

00:00:00.109 - Executing Script: c:\inetpub\wwwroot\dnn\Providers\DataProviders\SqlDataProvider\Upgrade.SqlDataProvider

Warning:

Invalid object name 'dnn_Users'.

Invalid object name 'dnn_Users'.

Click Here To Proceed With The Upgrade.



Upgrading DotNetNuke

Current Assembly Version: 04.03.03

Current Database Version: 04.00.03

00:00:00.015 - Executing Script: c:\inetpub\wwwroot\dnn\Providers\DataProviders\SqlDataProvider\Upgrade.SqlDataProvider


Upgrade Status Report

00:00:00.515 - Upgrading to Version: 4.0.4
00:00:09.093 - Upgrading to Version: 4.0.5
00:00:09.109 - Upgrading to Version: 4.0.6
00:00:09.140 - Upgrading to Version: 4.0.7
00:00:09.156 - Upgrading to Version: 4.3.0
00:00:09.265 - Upgrading to Version: 4.3.1
00:00:09.328 - Upgrading to Version: 4.3.2
00:00:09.484 - Upgrading to Version: 4.3.3
00:00:09.781 - Performing General Upgrades

 


Server Error in '/dnn' Application.

The stored procedure 'dbo.dnn_GetTabByName' doesn't exist.

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.InvalidOperationException: The stored procedure 'dbo.dnn_GetTabByName' doesn't exist.

Source Error:

Line 209:                        Response.Write("<h2>Upgrade Status Report</h2>")
Line 210:                        Response.Flush()
Line 211:                        Upgrade.UpgradeDNN(strProviderPath, strDatabaseVersion.Replace(".", ""))
Line 212:
Line 213:                        'Install Resources

Source File: c:\inetpub\wwwroot\dnn\Install\Install.aspx.vb    Line: 211

Stack Trace:

[InvalidOperationException: The stored procedure 'dbo.dnn_GetTabByName' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters() +878792
   System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
   DotNetNuke.Data.SqlDataProvider.GetTabByName(String TabName, Int32 PortalId) +120
   DotNetNuke.Entities.Tabs.TabController.GetTabByName(String TabName, Int32 PortalId, Int32 ParentId) +24
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication() +63
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeDNN(String strProviderPath, String strDatabaseVersion) +1260
   DotNetNuke.Framework.Install.UpgradeApplication() in c:\inetpub\wwwroot\dnn\Install\Install.aspx.vb:211
   DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\dnn\Install\Install.aspx.vb:384
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
 
New Post
7/20/2006 7:09 PM
 

Astroman,

be careful when editing web.config. Ensure you keep your encryption keys, sql connection and object qualifier.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
7/20/2006 7:21 PM
 

Correction,

It seems, like there is a bug in \Providers\DataProviders\SqlDataProvider\Upgrade.SqlDataProvider file:

search for "DNN_User" and replace with "{objectqualifier}User".


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
7/20/2006 7:30 PM
 
It's update successfully but I get another issue.  I cannot login at all.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...error upgrade from 4.0.3 to 4.3.3error upgrade from 4.0.3 to 4.3.3


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