Written by:Will
1/24/2008 

Please note, that this will only work for errors that get logged into the DNN Event Log.  Also, you will need query access to your database.

All you have to do is run this simple query, and your last error that the site experienced will load in your query window:

SELECT TOP 1 CAST([LogProperties] AS XML)
FROM [dbo].[EventLog]
ORDER BY [LogCreateDate] DESC;

If you are using a version prior to SQL Server 2005, you can still perform this query, although you are going to have to adapt it to XML yourself (in regards to the line breaks and formatting).  Here is your version of the query:

SELECT TOP 1 [LogProperties]
FROM [dbo].[EventLog]
ORDER BY [LogCreateDate] DESC

TrackbackPrint

Tags:

Categories:DotNetNuke

Location: BlogsThe Mighty Blog

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel