Hi
I am trying to install DNN 4.3.5 but am having problems with the installation script. Looking at the event log it appears to be a missing stored proceedure! I don't understand how this is possible, as I've checked that the stored proc does indeed exist in the DB.
The web.config file has been changed to use a new, empty DB, i.e.:
key="SiteSqlServer" value="server=69.XXX.XXX.245\sqlexpress;database=dnntest;uid=dnntest;pwd=XXXXX;"
Any help would be appreciated.
All pertinant error messages are listed below. The first is a copy of the installation script output, and the following four are the items listed in the event log.
Installing DotNetNuke
Version: 04.03.05
Installation Status Report
00:00:00.050 - Installing Version:
3.1.0
00:00:00.080 - Installing Script:
DotNetNuke.SetUp.SqlDataProvider
Success00:00:00.310 - Installing Script:
DotNetNuke.Schema.SqlDataProvider
Success00:00:31.234 - Installing Script:
DotNetNuke.Data.SqlDataProvider
Success00:01:22.348
- Installing MemberRole Provider:
00:01:22.348 - Executing
InstallCommon.sql
00:01:25.252 - Executing
InstallMembership.sql
00:01:30.630 - Executing
InstallProfile.sql
00:01:33.073 - Executing InstallRoles.sql
Success00:01:36.418 - Upgrading to Version: 3.1.1
Success00:01:46.282 - Upgrading to Version: 3.2.0
Success00:01:46.543 - Upgrading to Version: 3.2.1
Success00:01:46.913 - Upgrading to Version: 3.2.2
Success00:01:47.234 - Upgrading to Version: 3.2.3
Success00:01:54.534 - Upgrading to Version: 3.2.4
Success00:01:54.664 - Upgrading to Version: 3.2.5
Success00:01:54.714 - Upgrading to Version: 3.2.6
Success00:01:54.935 - Upgrading to Version: 3.2.7
Success00:01:54.975 - Upgrading to Version: 3.3.0
Success00:01:55.045 - Upgrading to Version: 3.3.1
Success00:01:55.165 - Upgrading to Version: 3.3.2
Success00:01:55.576 - Upgrading to Version: 3.3.3
Success00:01:56.347 - Upgrading to Version: 4.0.0
Success00:01:57.158 - Upgrading to Version: 4.0.1
Success00:01:57.589 - Upgrading to Version: 4.0.2
Success00:01:57.719 - Upgrading to Version: 4.0.3
Success00:01:57.859 - Upgrading to Version: 4.0.4
Success00:02:02.666 - Upgrading to Version: 4.0.5
Success00:02:02.696 - Upgrading to Version: 4.0.6
Success00:02:02.766 - Upgrading to Version: 4.0.7
Success00:02:02.806 - Upgrading to Version: 4.3.0
Success00:02:03.016 - Upgrading to Version: 4.3.1
Success00:02:03.046 - Upgrading to Version: 4.3.2
Success00:02:03.437 - Upgrading to Version: 4.3.3
Success00:02:04.238 - Upgrading to Version: 4.3.4
Success00:02:04.328 - Upgrading to Version: 4.3.5
Success00:02:05.620 - Performing General
Upgrades
00:02:08.194 - Loading Host Settings:
00:02:09.315 - Configuring
SuperUser:
00:02:10.748 - Installing Modules:
00:02:10.788 - Installing
Module File d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Announcements_03.03.04_Install.zip:
Success00:02:13.552 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Blog_3.02.00_Install.zip:
Success00:02:22.134 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Contacts_3.1_Install.zip:
Success00:02:23.035 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Documents_03.01.05_Install.zip:
Success00:02:25.098 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Events_3.2_Install.zip:
Success00:02:33.430 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\FAQs_3.1_Install.zip:
Success00:02:34.832 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Feedback_03.02.01_Install.zip:
Success00:02:36.024 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Forum_3.20.08_Install.zip:
Success00:03:16.262 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Gallery_3.0.12_Install.zip:
Success00:03:30.342 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Help_2.0.4_Install.zip:
Success00:03:35.590 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\HTML_3.3.0_Install.zip:
Success00:03:37.282 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\IFrame_3.2_Install.zip:
Success00:03:38.964 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Links_3.3_Install.zip:
Success00:03:47.406 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Media_03.02.02_Install.zip:
Success00:03:51.613 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\NewsFeeds_3.1.1_Install.zip:
Success00:03:52.694 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Reports_4.3.1_Source.zip:
Success00:03:56.359 - Installing Module File
d:\HostingSpaces\Code
Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Repository_3.1.10_Install.zip:
Server Error in '/dnntest' Application.
Runtime Error
Description:
An application error occurred on the server. The current custom error
settings for this application prevent the details of the application error from
being viewed remotely (for security reasons). It could, however, be viewed by
browsers running on the local server machine.
Details: To enable
the details of this specific error message to be viewable on remote machines,
please create a <customErrors> tag within a "web.config" configuration
file located in the root directory of the current web application. This
<customErrors> tag should then have its "mode" attribute set to
"Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration> |
Notes:
The current error page you are seeing can be replaced by a custom error page by
modifying the "defaultRedirect" attribute of the application's
<customErrors> configuration tag to point to a custom error page
URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration> |
I have included the ouput of all four messages below, for those who wish to
know:
1st Error Message:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event
Category: Web Event
Event ID: 1309
Date: 14/11/2006
Time: 1:46:09
AM
User: N/A
Computer: ULTIMA4
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time:
11/14/2006 1:46:09 AM
Event time (UTC): 11/13/2006 2:46:09 PM
Event ID:
941f98e1f7274e7c9206b66bf0dc1e3b
Event sequence: 6
Event occurrence: 1
Event detail code: 0
Application information:
Application
domain: /LM/W3SVC/2079243352/ROOT/dnntest-3-128079027480130928
Trust
level: Full
Application Virtual Path: /dnntest
Application Path:
d:\HostingSpaces\Code Red1\testing.XXXXXX.com.au\wwwroot\dnntest\
Machine name: ULTIMA4
Process information:
Process ID: 5316
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK
SERVICE
Exception information:
Exception type: SqlException
Exception message:
Could not find stored
procedure 'dbo.GetPortals'.
Request information:
Request URL:
http://testing.XXXXX.com.au/dnntest/Default.aspx
Request path: /dnntest/Default.aspx
User host address:
124.XXX.XXX.XXX
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name:
NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack
trace: 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.SqlDataReader.ConsumeMetaData()
at
System.Data.SqlClient.SqlDataReader.get_MetaData()
at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream, String method)
at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String
method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior)
at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection
connection, SqlTransaction transaction, CommandType commandType, String
commandText, SqlParameter[] commandParameters, SqlConnectionOwnership
connectionOwnership)
at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters)
at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, CommandType commandType, String commandText)
at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, String spName, Object[] parameterValues)
at
DotNetNuke.Data.SqlDataProvider.GetPortals()
at
DotNetNuke.Entities.Portals.PortalController.GetPortals()
at
DotNetNuke.Common.Global.CacheMappedDirectory()
at
DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs
E)
2nd Error Message:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event
Category: Web Event
Event ID: 1309
Date: 14/11/2006
Time: 1:46:12
AM
User: N/A
Computer: ULTIMA4
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time:
11/14/2006 1:46:12 AM
Event time (UTC): 11/13/2006 2:46:12 PM
Event ID:
e8a642b74af142548f59fa34b6b27276
Event sequence: 2
Event occurrence: 1
Event detail code: 0
Application information:
Application
domain: /LM/W3SVC/2079243352/ROOT/dnntest-4-128079027721678256
Trust
level: Full
Application Virtual Path: /dnntest
Application Path:
d:\HostingSpaces\Code Red1\testing.XXXXX.com.au\wwwroot\dnntest\
Machine name: ULTIMA4
Process information:
Process ID: 5316
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK
SERVICE
Exception information:
Exception type: SqlException
Exception message: Could not find stored procedure 'dbo.GetPortals'.
Request information:
Request URL:
http://testing.XXXXX.com.au/dnntest/Install/Install.aspx?mode=Install
Request path: /dnntest/Install/Install.aspx
User host address:
124.XXX.XXX.XXX
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 6
Thread account name:
NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack
trace: 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.SqlDataReader.ConsumeMetaData()
at
System.Data.SqlClient.SqlDataReader.get_MetaData()
at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream, String method)
at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String
method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior)
at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection
connection, SqlTransaction transaction, CommandType commandType, String
commandText, SqlParameter[] commandParameters, SqlConnectionOwnership
connectionOwnership)
at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, CommandType commandType, String commandText, SqlParameter[]
commandParameters)
at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, CommandType commandType, String commandText)
at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, String spName, Object[] parameterValues)
at
DotNetNuke.Data.SqlDataProvider.GetPortals()
at
DotNetNuke.Entities.Portals.PortalController.GetPortals()
at
DotNetNuke.Common.Global.CacheMappedDirectory()
at
DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs
E)
3rd Error Message:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event
Category: Web Event
Event ID: 1309
Date: 14/11/2006
Time: 1:52:08
AM
User: N/A
Computer: ULTIMA4
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time:
11/14/2006 1:52:07 AM
Event time (UTC): 11/13/2006 2:52:07 PM
Event ID:
c238ec9037d44e1b98e016ba4324cb1d
Event sequence: 5
Event occurrence: 2
Event detail code: 0
Application information:
Application
domain: /LM/W3SVC/2079243352/ROOT/dnntest-4-128079027721678256
Trust
level: Full
Application Virtual Path: /dnntest
Application Path:
d:\HostingSpaces\Code Red1\testing.XXXXX.com.au\wwwroot\dnntest\
Machine name: ULTIMA4
Process information:
Process ID: 5316
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK
SERVICE
Exception information:
Exception type:
ThreadAbortException
Exception message: Thread was being aborted.
Request information:
Request URL:
http://testing.XXXXX.com.au/dnntest/Install/Install.aspx?mode=Install
Request path: /dnntest/Install/Install.aspx
User host address:
124.XXX.XXX.XXX
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 6
Thread account name:
NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack
trace: at System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
Boolean& completedSynchronously)
at
System.Web.HttpApplication.ResumeSteps(Exception error)
at
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
context, AsyncCallback cb, Object extraData)
at
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest
wr)
4th Error Message:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event
Category: None
Event ID: 1073
Date: 14/11/2006
Time: 1:52:08
AM
User: N/A
Computer: ULTIMA4
Description:
Failed to process
request.
Exception: System.Threading.ThreadAbortException
Message: Thread was being
aborted.
StackTrace: at
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
at
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
at
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)