Hi all..If anyone can help with this, I will greatly appreciate it.
I have just completed the upgrade to V 04.06.02. Previous version was 4.1.
The problem is that the existing events that are stored in the DB are no longer accesible via the Events module.
The module will not allow new events to be created, and will not display those previously created.
When I try to link a sub calendar to the main calendar, I see this msg.
A critical error has occurred.
The stored procedure 'dbo.EventsMasterAssignedModules' doesn't exist.
When I try to Add a new Event, then I get this...
Error: Edit Event is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.EventsCategoryList' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.EventsCategoryList' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Events.Data.SqlDataProvider.EventsCategoryList(Int32 PortalId) at DotNetNuke.Modules.Events.EventCategoryController.EventsCategoryList(Int32 PortalID) at DotNetNuke.Modules.Events.EditEvents.LoadCategory(Int32 Category) at DotNetNuke.Modules.Events.EditEvents.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---