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 ...

Please Help About DNN Installiation !!! Please...

11/19/2006 6:04 PM

Caner

Joined: 11/2/2006

Posts: 6

Please Help About DNN Installiation !!! Please... Modified By cathal connolly on 11/19/2006 7:05:52 PM

DotNetNuke, this error message is display; I am waiting your helps...

Installing DotNetNuke

Version: 04.03.05

Installation Status Report

00:00:00.300 - Installing Version: 3.1.0
00:00:00.300 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.630 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeC:\DotNetNuke\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:04.726 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeC:\DotNetNuke\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:07.460 - Installing MemberRole Provider:
00:00:07.460 - Executing InstallCommon.sql
00:00:09.243 - Executing InstallMembership.sql
00:00:10.374 - Executing InstallProfile.sql
00:00:10.935 - Executing InstallRoles.sql
Error!
00:00:12.818 - Upgrading to Version: 3.1.1 Error! (seeC:\DotNetNuke\Providers\DataProviders\SqlDataProvider\03.01.01.log for more information)
00:00:15.392 - Upgrading to Version: 3.2.0 Success
00:00:15.672 - Upgrading to Version: 3.2.1 Error! (seeC:\DotNetNuke\Providers\DataProviders\SqlDataProvider\03.02.01.log for more information)
00:00:15.782 - Upgrading to Version: 3.2.2 Success
00:00:15.832 - Upgrading to Version: 3.2.3 Success
00:00:18.516 - Upgrading to Version: 3.2.4 Success
00:00:18.626 - Upgrading to Version: 3.2.5 Success
00:00:18.937 - Upgrading to Version: 3.2.6 Success
00:00:19.267 - Upgrading to Version: 3.2.7 Success
00:00:19.317 - Upgrading to Version: 3.3.0 Success
00:00:19.447 - Upgrading to Version: 3.3.1 Success
00:00:19.538 - Upgrading to Version: 3.3.2 Success
00:00:19.648 - Upgrading to Version: 3.3.3 Success
00:00:19.908 - Upgrading to Version: 4.0.0 Success
00:00:20.529 - Upgrading to Version: 4.0.1 Error! (seeC:\DotNetNuke\Providers\DataProviders\SqlDataProvider\04.00.01.log for more information)
00:00:20.669 - Upgrading to Version: 4.0.2 Success
00:00:20.719 - Upgrading to Version: 4.0.3 Success
00:00:20.789 - Upgrading to Version: 4.0.4 Success
00:00:22.161 - Upgrading to Version: 4.0.5 Success
00:00:22.211 - Upgrading to Version: 4.0.6 Success
00:00:22.241 - Upgrading to Version: 4.0.7 Success
00:00:22.272 - Upgrading to Version: 4.3.0 Success
00:00:22.602 - Upgrading to Version: 4.3.1 Success
00:00:22.742 - Upgrading to Version: 4.3.2 Success
00:00:22.973 - Upgrading to Version: 4.3.3 Success
00:00:23.173 - Upgrading to Version: 4.3.4 Success
00:00:23.213 - Upgrading to Version: 4.3.5 Error! (seeC:\DotNetNuke\Providers\DataProviders\SqlDataProvider\04.03.05.log for more information)
00:00:23.623 - Performing General Upgrades
00:00:24.485 - Loading Host Settings:
00:00:24.775 - Configuring SuperUser:

Server Error in '/DotNetNuke' Application.

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

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:

[InvalidOperationException: The stored procedure 'dbo.GetModuleSetting' doesn't exist.]
***post edited by moderator ***

11/19/2006 7:02 PM

cathal connolly

www.cathal.co.uk
Joined: 4/9/2003

Posts: 9676

Re: Please Help About DNN Installiation !!! Please...

please look into the logfiles as the error suggests (e.g. seeC:\DotNetNuke\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log )and post the a sample of the errors here, the issues likely to be permissions related, or perhaps a collation one.

Cathal

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US

11/20/2006 8:03 AM

Caner

Joined: 11/2/2006

Posts: 6

Re: Please Help About DNN Installiation !!! Please... Modified By cathal connolly on 11/20/2006 1:58:07 PM

Also this file is "DotNetNuke.Schema.log". I dont understand whats the problem;

System.Data.SqlClient.SqlException: Must declare the scalar variable "@moduleid".
   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)

CREATE procedure dbo.GetModuleSetting

@ModuleId int,
@SettingName nvarchar(50)

select
'SettingValue' = case when Files.FileName is null then ModuleSettings.SettingValue else Files.Folder + Files.FileName end

from ModuleSettings
left outer join Files on ModuleSettings.SettingValue = 'fileid=' +
convert(varchar,Files.FileID)
where SettingName = @SettingName and moduleid=@moduleid

System.Data.SqlClient.SqlException: Must declare the scalar variable "@portalid".
   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)

CREATE procedure dbo.GetBanner

@BannerId int,
@VendorId int,
@PortalID int

select Banners.BannerId,
       Banners.VendorId,
       'ImageFile' = case when Files.FileName is null then Banners.ImageFile else Files.Folder + Files.FileName end,
       Banners.BannerName,
       Banners.Impressions,
       Banners.CPM,
       Banners.Views,
       Banners.ClickThroughs,
       Banners.StartDate,
       Banners.EndDate,
       'CreatedByUser' = Users.FirstName + ' ' + Users.LastName,
       Banners.CreatedDate,
       Banners.BannerTypeId,
       Banners.Description,
       Banners.GroupName,
       Banners.Criteria,
       Banners.URL,
       Banners.Width,
       Banners.Height
FROM   Banners
INNER JOIN Vendors ON Banners.VendorId = Vendors.VendorId
LEFT OUTER JOIN Users ON Banners.CreatedByUser = Users.UserID
left outer join Files on Banners.ImageFile = 'FileId=' + convert(varchar,Files.FileID)
where Banners.BannerId = @BannerId
and   Banners.vendorId = @VendorId
AND (Vendors.PortalId = @PortalID or (Vendors.PortalId is null and @portalid is null))

***post shortened by moderator***

11/20/2006 2:00 PM

cathal connolly

www.cathal.co.uk
Joined: 4/9/2003

Posts: 9676

Re: Please Help About DNN Installiation !!! Please...

It's a case sensitivity issue - at present the dotnetnuke scripts do not support case-sensitive databases (thats why the parameter @ModuleID doesn't match @moduleID). I recommend you create a database with a case-insentive collation e.g. Latin1_General_CI_AS

Cathal

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US

11/21/2006 1:29 PM

Caner

Joined: 11/2/2006

Posts: 6

Re: Please Help About DNN Installiation !!! Please...

Hi everybody, I also createted a database with a case-intensive collation (Latin1_General_CI_AS) but still I have a same problem, Is there any different idea?

Page 1 of 2

Home

Getting Started

Installing DNN ...

Please Help About DNN Installiation !!! Please...

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Hi Eveybody, Again I have a problem with DNN. I installed the .NET 2005, SQL Server 2005 and
ASP 2.0. But when I clicked the http://localhost/DotNetNuke, this error message is display; I am waiting your helps...

Installing DotNetNuke

Version: 04.03.05

Installation Status Report

Server Error in '/DotNetNuke' Application.

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

DNN Corp. (DotNetNuke)

New Community Website

Hi Eveybody, Again I have a problem with DNN. I installed the .NET 2005, SQL Server 2005 and ASP 2.0. But when I clicked the http://localhost/DotNetNuke, this error message is display; I am waiting your helps...

Installing DotNetNuke

Version: 04.03.05

Installation Status Report

Server Error in '/DotNetNuke' Application.

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

DNN Corp. (DotNetNuke)

Hi Eveybody, Again I have a problem with DNN. I installed the .NET 2005, SQL Server 2005 and
ASP 2.0. But when I clicked the http://localhost/DotNetNuke, this error message is display; I am waiting your helps...