Dear DNN Forum'ers:
First off, DNN434 installed properly (I thought) on 1and1 hosting. I successfully created a site on the portal. I could add modules and they functioned as expected.
Then I tried to implement the Announcements module and I got the "Announcements unavailable" critical error.
Using the admin logs, I saw that the complaint was that a "GetAnnouncements" stored proc was missing. So, I deleted the Announcements module and re-installed it. That went well. I then tried again to implement the Announcements module and this time the whole site blew up.
Now, I cannot access the site at all. I get the following in the browser: [Any ideas???]
Thanks for any help. Sure hope I don't have to re-install DNN and rebuild everything.
Chris
Server Error in '/dnn' Application.
The stored procedure 'dbo125700266.GetAnnouncements' 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 'dbo125700266.GetAnnouncements' 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 'dbo125700266.GetAnnouncements' doesn't exist.]
System.Data.SqlClient.SqlCommand.DeriveParameters() +878808
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.Modules.Announcements.SqlDataProvider.GetAnnouncements(Int32 ModuleId, DateTime StartDate, DateTime EndDate) +233
DotNetNuke.Modules.Announcements.AnnouncementsController.GetAnnouncements(Int32 ModuleId, DateTime StartDate, DateTime EndDate) +68
DotNetNuke.Modules.Announcements.Announcements.Page_Load(Object sender, EventArgs e) +491
[ModuleLoadException: Error: Announcements is currently unavailable.]
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(String FriendlyMessage, PortalModuleBase ctrlModule, Exception exc, Boolean DisplayErrorMessage) +483
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(PortalModuleBase ctrlModule, Exception exc) +100
DotNetNuke.Modules.Announcements.Announcements.Page_Load(Object sender, EventArgs e) +546
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
[PageLoadException: Error: Announcements is currently unavailable.]
DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) +351
DotNetNuke.Framework.PageBase.Page_Error(Object Source, EventArgs e) +377
System.Web.UI.TemplateControl.OnError(EventArgs e) +105
System.Web.UI.Page.HandleError(Exception e) +73
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6944
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +154
System.Web.UI.Page.ProcessRequest() +86
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +18
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.default_aspx.ProcessRequest(HttpContext context) +4
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
|
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42