Hi all... I think I have a problem.

On my only DNN 5.0 install, my SQL database seems to be rapidly increasing, so much so that in less than 1.5 hours it increased by 3 MB.  This has led to issues with the portal and with hosting services b/c of obvious reasons...

I logged in this morning, ran a series of queries in the Host > SQL page of the portal.  Here's what I did:

1) sp_spaceused, database size was 250.18 MB, unallocated space was 0.11 MB

2) DBCC SHRINKDATABASE (mydatabasename) -- this didn't get me any reduction in size

3) TRUNCATE TABLE eventlog

4) TRUNCATE TABLE sitelog

5) sp_spaceused, database size still showed over 250 MB, BUT the unallocated space was actually LARGER than the database size (i know, weird)

6) DBCC SHRINKDATABASE (mydatabasename)

7) sp_spaceused -- database size 23.18 MB, unallocated space 0.13 MB

Now all seems fine, but then like I said, I checked back on this site in 1.5 hours and the sp_spaceused stored procedure turned up an increase of 3MB in size.

THEN I went to Host > Host Settings > Other settings and noticed the SiteLog storage was set to Database.  Was THAT my problem?  I changed it to File System.

Keep in mind for the last several weeks I have been running Mitch's SQL jobs module w/clean site log and clean event log jobs scheduled to run weekly.

Is this a DNN 5 thing?

You should attempt to fix errors in your event log. On the event log page itself you can choose what to / what not to log.

I have a bunch of errors from a single module with moduleID 607, but when I query the DesktopModules table for a module with that ID, nothing is returned.

The error is like this: (there is more to it, and the error repeats for a bunch of IMG_20XX.jpg files -- on the Title line)

ModuleId: 607
SearchItemId: 0
Title: IMG_2071.JPG
SearchKey: 159
GUID: ctl=SlideShow&mid=607&ItemID=159
AssemblyVersion: 05.00.00
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: a3fb6c3d-646e-4c56-879e-582df3a07a0b
InnerException: Cannot insert the value NULL into column 'PubDate', table 'mydatabasename.dbo.SearchItem'; column does not allow nulls. INSERT fails. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace: