i have the same problem. if i try to install with auto-option i get this output:
Installation Status Report
00:00:00.015 - Installing Version: 4.4.0
00:00:00.015 - Executing Script: DotNetNuke.SetUp.SqlDataProvider
Success00:00:00.124 - Executing Script: DotNetNuke.Schema.SqlDataProvider
Error! (see DotNetNuke.Schema.log for more information)00:00:11.328 - Executing Script: DotNetNuke.Data.SqlDataProvider
Success00:00:15.109 - Installing MemberRole Provider:
00:00:15.109 - Executing Script: InstallCommon
00:00:16.843 - Executing Script: InstallMembership
00:00:18.171 - Executing Script: InstallProfile
00:00:18.828 - Executing Script: InstallRoles
00:00:19.765 - Upgrading to Version: 4.5.5
00:00:20.499 - Executing Script: 04.04.01.SqlDataProvider
Error! (see 04.04.01.log for more information)00:00:20.765 - Executing Script: 04.05.00.SqlDataProvider
Error! (see 04.05.00.log for more information)00:00:23.296 - Executing Script: 04.05.01.SqlDataProvider
Success00:00:23.593 - Executing Script: 04.05.02.SqlDataProvider
Success00:00:24.749 - Executing Script: 04.05.03.SqlDataProvider
Success00:00:25.015 - Executing Script: 04.05.04.SqlDataProvider
Success00:00:25.171 - Executing Script: 04.05.05.SqlDataProvider
Success00:00:25.202 - Performing General Upgrades
and this is the first entry in the log-file:
System.Data.SqlClient.SqlException: Must declare the scalar variable "@ModuleDefID".
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.GetModuleControlByKeyAndSrc
@ModuleDefId int,
@ControlKey nvarchar(50),
@ControlSrc nvarchar(256)
as
SELECT ModuleControlID,
ModuleDefID,
ControlKey,
ControlTitle,
ControlSrc,
IconFile,
ControlType,
ViewOrder
from dbo.ModuleControls
where ((ModuleDefId is null and @ModuleDefId is null) or (ModuleDefID = @ModuleDefID))
and ((ControlKey is null and @ControlKey is null) or (ControlKey = @ControlKey))
and ((ControlSrc is null and @ControlSrc is null) or (ControlSrc = @ControlSrc))
it looks like there is a problem with the case-sensitive. but my database is case-insensitive.
please help me!
thx