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

Home All Forums

Home

Getting Started

Installing DNN ...

Error installing DNN 3.2.2

4/26/2006 4:09 PM

Karen Oertner

Joined: 4/26/2006

Posts: 1

Error installing DNN 3.2.2 Modified By Karen Oertner on 5/1/2006 10:08:08 AM

I keep getting the following error while trying to install DNN. I have tried installing 4.0.3 and still get the same error. Can anyone please help me with this?

Installation Status Report

00:00:00.030 - Installing Version: 3.1.0
00:00:00.030 - Installing Script: DotNetNuke.SetUp.SqlDataProvider
00:00:00.090 - Installing Script: DotNetNuke.Schema.SqlDataProvider
00:00:01.221 - Installing Script: DotNetNuke.Data.SqlDataProvider
00:00:03.464 - Installing MemberRole Provider:
00:00:03.464 - Executing InstallCommon.sql
00:00:03.815 - Executing InstallMembership.sql
00:00:04.206 - Executing InstallProfile.sql
00:00:04.296 - Executing InstallRoles.sql
00:00:04.616 - Upgrading to Version: 3.1.1
00:00:05.417 - Upgrading to Version: 3.2.0
00:00:05.447 - Upgrading to Version: 3.2.1
00:00:05.467 - Upgrading to Version: 3.2.2
00:00:05.477 - Performing General Upgrades

Server Error in '/DotNetNuke' Application.

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

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: The stored procedure 'dbo.GetTabByName' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters()
   System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues)
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter)
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName)
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
   DotNetNuke.Data.SqlDataProvider.GetTabByName(String TabName, Int32 PortalId) +128
   DotNetNuke.Entities.Tabs.TabController.GetTabByName(String TabName, Int32 PortalId, Int32 ParentId) +23
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication() +65
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeDNN(String strProviderPath, String strDatabaseVersion) +1333
   DotNetNuke.Services.Upgrade.Upgrade.InstallDNN(String strProviderPath) +1053
   DotNetNuke.Framework.Install.InstallApplication() +1336
   DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) +265
   System.Web.UI.Control.OnLoad(EventArgs e)
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Page.ProcessRequestMain()

5/10/2006 12:41 PM

James Attfield

Joined: 5/9/2006

Posts: 1

Re: Error installing DNN 3.2.2 Modified By James Attfield on 5/11/2006 9:04:21 AM

Hi,

I had this error and the solution was to change the collating sequence of my SQL Server 2005 DotNetNuke database to a case-INsensitive one. It appears that using a case-sensitive (CS) collating sequence causes the installer to fail to create all of the stored procedures.

I don't see this in the install notes anywhere (perhaps it should be). I learned this from somewhere else so I pass on my good fortune, HTH.

Jim

Page 1 of 1