Actually, I'm having the same problem and I do have several events in the event viewer (I tried to change "Survey Settings" several times).  The survey module instance is named "President" and this is the message in the event viewer:

ModuleId: 402

ModuleDefId: 117

FriendlyName: President

ModuleControlSource: DesktopModules/Survey/Survey.ascx

AssemblyVersion: 6.1.0

PortalID: 0

PortalName: Birmingham Bar Association

UserID: 1

UserName: host

ActiveTabID: 55

ActiveTabName: Home

RawURL: /Home/tabid/55/ctl/Module/ModuleId/402/Default.aspx?popUp=true

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://birminghambarassociation.org/Home/tabid/55/ctl/Module/ModuleId/402/Default.aspx?popUp=true

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

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 5d5401e2-1266-4e38-8119-cd67231049fb

InnerException: Object cannot be cast from DBNull to other types.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.DBNull.System.IConvertible.ToDateTime

StackTrace:

Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Object cannot be cast from DBNull to other types. ---> System.InvalidCastException: Object cannot be cast from DBNull to other types. at System.DBNull.System.IConvertible.ToDateTime(IFormatProvider provider) at System.Convert.ToDateTime(Object value) at DotNetNuke.Modules.Survey.Settings.UpdateSettings() --- End of inner exception stack trace ---

Source:

Server Name: WSS45

I'm looking at the database through the web admin tool of my website hosting provider, so it's a little foreign.  On to more drastic remedies; if I were to remove the survey module and then reinstall it would that ultimately solve the issue?  What would generate null values in datetime fields?

SurveyID

int

4

10

0

False

True

1

1

False

ModuleID

int

4

10

0

False

False

False

Question

nvarchar

500

False

False

False

ViewOrder

int

4

10

0

True

False

False

OptionType

char

1

False

False

False

CreatedDate

datetime

8

False

False

False

CreatedByUser

int

4

10

0

False

False

False