Has anyone else noticed that after upgrading to 5.1.1 they get very few eventtypes in the eventlog?

Normally, the eventlog has all sorts of things, users logging in, application specific evnets, etc.   This behavior seems to be common across all of my systems that have been upgraded.

The only think in my eventlog (or in the underlying table) is execptions and appstart events.  nothing else.

Could this have something to do with the primary key change?  Or is there some other configuration parameter that might not be correct?

In researching this further, my database stats show that the PurgeEventlog query is running every minute (is this right?)  There is a task that says it purses the evetnlogcache every minute...  am I confused?  Anyway, this query being the # query in my system is very very new.

Looking @ the stored procedure, I think it is in error:

DELETE

FROM dbo.DNN_EventLog
FROM dbo.DNN_EventLogConfig elc   --- umm is this legal? is there a missing bit here?
WHERE
(
SELECT COUNT(*)
FROM dbo.DNN_EventLog el
WHERE el.LogConfigID = elc.ID
and dbo.DNN_EventLog.LogTypeKey = el.LogTypeKey
and el.LogCreateDate >= dbo.DNN_EventLog.LogCreateDate
) > elc.KeepMostRecent

AND

I believe this is due to a minor issue in 5.1.0 where some some people had a error.

System.Data.SqlClient.SqlException: Table 'EventLog' already has a primary key defined on it.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.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)



/* Change primary key of EventLog Table */
/****************************************/

IF NOT EXISTS (SELECT 1 FROM INformATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dbo.EventLog' AND COLUMN_NAME = 'LogEventID')
BEGIN
--Note this name does NOT have an object qualifier in 4.x upgrades
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLogMaster

--Note this name does have an object qualifier in 5.x installs
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLogMaster

ALTER TABLE dbo.EventLog
ADD LogEventID bigint NOT NULL IDENTITY (1, 1)

ALTER TABLE dbo.EventLog
ADD CONSTRAINT PK_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )
END

As i think i read from charles that this was due to a enhancement and there would be a fix in 5.1.1 i assume the fix or original error caused it to remove all default enabled items in event viewer.  This is purely speculation but may help.  I went into my event log afterwards and re enabled the items in event log settings the item i wanted to see logged.  Only one i can't find in when a user logs in. Also new registrations. Any idea of where can find info on the new items?

yup, thanks for all the help on this one...

I just compared the entries in the eventlogconfig and the eventlogtypes tables and found that there are 36 entries in the eventlogtypes table that are  not in eventlogconfig.

Given that prior to the upgrade, I'm not sure if the upgrader broke the tables, if the underlying code is no longer tolerent of the missing entries or if the upgrader simply changed the 'all' event to disabled.  one way or another is was a bit unnerving to have that suddenly change.

The missing entries are:

ADMIN_ALERT
APPLICATION_SHUTTING_DOWN
DEBUG
HOST_ALERT
LOG_NOTIFICATION_FAILURE
LOGIN_FAILURE
LOGIN_SUCCESS
LOGIN_SUPERUSER
LOGIN_USERLOCKEDOUT
LOGIN_USERNOTAPPROVED
MODULE_CREATED
MODULE_DELETED
MODULE_RESTORED
MODULE_SENT_TO_RECYCLE_BIN
MODULE_UPDATED
PASSWORD_SENT_FAILURE
PASSWORD_SENT_SUCCESS
PORTAL_CREATED
PORTAL_DELETED
ROLE_CREATED
ROLE_DELETED
ROLE_UPDATED
SCHEDULE_FIRED_FROM_EVENT
SCHEDULER_SHUTTING_DOWN
SCHEDULER_STARTED
SCHEDULER_STOPPED
SEARCH_INDEXER_EXCEPTION
TAB_CREATED
TAB_DELETED
TAB_RESTORED
TAB_SENT_TO_RECYCLE_BIN
TAB_UPDATED
USER_CREATED
USER_DELETED
USER_ROLE_CREATED
USER_ROLE_DELETED