I need to know the SQL script or command to delete a profile field. I'm using Active Social and it's causing an error becuse of the profile "Status" field. I deleted the "Status" profile field, but I guest I need to do so in the database. Not a SQL guy so not sure to do this. Hoping someone will read this and be able to help.

See thread on Activemodue for more detail

http://www.activemodules.com/activeso... 

Thanks

Hi,

On a related question, I have deleted some fields from Profile Properties (custom fields that I had created), but they are still showing up in Active Social profiles and registration etc. How do I delete these orphaned fields?

Thanks in advance.

I have a similar problem - Can anybody help us out? It is a DNN 6 website - we have used without problems until Now. It is not letting us sending any email from the site. It said to check the event viewer.

In the event viewer, the site is having these failures constantly and they do not stop.


THREAD ID: 132

TYPE: DotNetNuke.Services.ModuleCache.PurgeModuleCache

EXCEPTION: String was not recognized as a valid DateTime.

RESCHEDULED FOR: 8/1/2016 7:48:48 PM

SOURCE: STARTED_FROM_BEGIN_REQUEST

ACTIVE THREADS: 0

FREE THREADS: 1

READER TIMEOUTS: 0

WRITER TIMEOUTS: 0

IN PROGRESS: 0

IN QUEUE: 6

Server Name: WEB28


And then:


AssemblyVersion: 6.0.0

PortalID: -1

PortalName:

UserID: -1

UserName:

ActiveTabID: -1

ActiveTabName:

RawURL:

AbsoluteURL:

AbsoluteURLReferrer:

UserAgent:

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: e0d150d9-0442-4b8c-a5a4-1ad4cf516676

InnerException: String was not recognized as a valid DateTime.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.DateTimeParse.Parse

StackTrace:

Message: System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at DotNetNuke.Services.ModuleCache.FileProvider.IsFileExpired(String file) at DotNetNuke.Services.ModuleCache.FileProvider.PurgeExpiredItems(Int32 portalId) at DotNetNuke.Services.ModuleCache.PurgeModuleCache.DoWork()

Source:

Server Name: WEB28

Thanks for the help.