I had the search for DMX 5 all set up and working fine. It was returning results to the DMX module and the site search page with no trouble. As of today, it has stopped working and I am getting the error you see below. The only thing that changed with the site is that I attached the DNN database to the SQL server through management studio and changed the connection string from "User Instance=True" to "User Instance=False". Everything else on the DNN site is still working. Please help...
AssemblyVersion: 5.4.2
PortalID: 0
PortalName: MDA Marketing Materials
UserID: 1
UserName: ************
ActiveTabID: 41
ActiveTabName: Search Results
RawURL: /SearchResults.aspx?Search=letterhead
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://marketing.maddogg....reader&content=0
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDR; Zune 4.0; .NET4.0C; .NET4.0E)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 4a1780d0-0bb5-4dd6-9b5d-7d6172c079a6
InnerException: Value cannot be null. Parameter name: reader
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlBulkCopy.WriteToServer
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Value cannot be null. Parameter name: reader ---> System.ArgumentNullException: Value cannot be null. Parameter name: reader at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader) at Bring2mind.DNN.Modules.DMX.Data.SqlDataProvider.BulkCopyReader(String tableName, IDataReader reader, Boolean closeReader, String[] mappings) at Bring2mind.DNN.Modules.DMX.Data.SqlDataProvider.SetSearch(Int32 PortalId, String SearchId, IDataReader SearchResults) at Bring2mind.DNN.Modules.DMX.Services.Search.SearchController.Search(Int32 PortalId, String SearchId, List`1 SearchTerms, Int32 CollectionId, Boolean OnlyLastVersion, Boolean HideDeleted, Boolean OnlyApproved) at Bring2mind.DNN.Modules.DMX.Search.ᜀ() at Bring2mind.DNN.Modules.DMX.Search.ᜀ(Object A_0, EventArgs A_1) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---