Hello,

I just installed the latest Events 6.0.1 on a brand new dnn 6.1.5. The installation report was all ok, but I got the following exception logged in the event viewer:

1. The stored procedure '(dbo).EventsUpgrade' doesn't exist.

2. The stored procedure '(dbo).EventsNotificationDelete' doesn't exist.

What am I supposed to do?

Thanks

Franco

Hi Roger,
I just masked the dbo as i thouhgt it would not be relevant. Anyway, here are the 2 errors:
_______________________________________

AssemblyVersion: 6.1.5

PortalID: -1

PortalName:

UserID: -1

UserName:

ActiveTabID: -1

ActiveTabName:

RawURL: /Host/Extensions/tabid/36/ctl/Install/rtab/36/portalid/0/Default.aspx?popUp=true

AbsoluteURL: /Host/Extensions/tabid/36/ctl/Install/rtab/36/portalid/0/Default.aspx

AbsoluteURLReferrer: http://www.ttc.lu/Host/Extensions/tabid/36/ctl/Install/rtab/36/portalid/0/Default.aspx?popUp=true

UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: ad2c8530-5563-4adb-a8f9-62089a802c70

InnerException: The stored procedure 'dnn_ttc.EventsUpgrade' doesn't exist.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlCommand.DeriveParameters

StackTrace:

Message: System.InvalidOperationException: The stored procedure 'dnn_ttc.EventsUpgrade' 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.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Events.SqlDataProvider.EventsUpgrade(String ModuleVersion) at DotNetNuke.Modules.Events.EventController.UpgradeModule(String Version)
_____________________________

AssemblyVersion: 6.1.5

PortalID: -1

PortalName:

UserID: -1

UserName:

ActiveTabID: -1

ActiveTabName:

RawURL:

AbsoluteURL:

AbsoluteURLReferrer:

UserAgent:

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 63a217fb-3440-4fb3-a326-a2504cb445dd

InnerException: The stored procedure 'dnn_ttc.EventsNotificationDelete' doesn't exist.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlCommand.DeriveParameters

StackTrace:

Message: System.InvalidOperationException: The stored procedure 'dnn_ttc.EventsNotificationDelete' 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.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Events.SqlDataProvider.EventsNotificationDelete(DateTime DeleteDate) at DotNetNuke.Modules.Events.EventNotification.SendEventNotifications() at DotNetNuke.Modules.Events.EventNotification.DoWork()

Lookinmg at it again, it's going to be better if you uninstall and re-install with 6.0.2 when it gets released. There are quite a few sprocs that are going to be missing. Alternatively install 5.2.3 then upgrade to 6.0.1.

Cheers
Roger

---

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback

---

Requirements/Bugs - Please submit them on Codeplex