Mailing lists no longer work (SM 15)
Problem reported by Ben Rowland - June 28, 2016 at 10:22 AM
Submitted
After upgrading to SM 15, I noticed that my existing mailing lists no longer work.
 
When I attempt to add a new list, there is no error, but the list is not created. Nothing appears to happen.
 
When I attempt to edit an existing mailing list, I receive an error. Here is what was reported in the event log:
 
Event code: 3005 
Event message: An unhandled exception has occurred. 
Event time: 6/28/2016 12:16:42 PM 
Event time (UTC): 6/28/2016 5:16:42 PM 
Event ID: c23d4a25efa047218262bbf18eec4f3d 
Event sequence: 71 
Event occurrence: 20 
Event detail code: 0 
 
Application information: 
    Application domain: /LM/W3SVC/123/ROOT-10-131116075331114285 
    Trust level: Full 
    Application Virtual Path: / 
    Application Path: C:\Program Files (x86)\SmarterTools\SmarterMail\MRS\ 
    Machine name: TERRA 
 
Process information: 
    Process ID: 9056 
    Process name: w3wp.exe 
    Account name: NT AUTHORITY\NETWORK SERVICE 
 
Exception information: 
    Exception type: IndexOutOfRangeException 
    Exception message: Index was outside the bounds of the array.
Server stack trace: 
   at System.Data.SQLite.SQLiteDataReader.GetSQLiteType(Int32 i)
   at System.Data.SQLite.SQLiteDataReader.GetValue(Int32 i)
   at System.Data.IDataReader_ExtensionMethods7BCA73B06BAB478aA3AC6AC60979BA25.ReadBool(IDataReader reader, String column, Boolean defaultIfNull)
   at MailStore.MailingLists.Data.MailingListRepository.#o9j.#Fgk(IDataReader #g5c)
   at MailStore.MailingLists.Data.MailingListRepositoryBase`1.ProcessReaderFirstOrDefault[O](IDataReader reader, Func`2 readMethod)
   at MailStore.MailingLists.Data.MailingListRepository.DefaultReaderMethodFirstOrDefault(IDataReader reader)
   at MailStore.MailingLists.Data.MailingListRepositoryBase`1.Load(Int64 id)
   at MailService.Remoting.Mail.GetMailListById(String sessionStr, String domainName, Int32 listId)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)
Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at SmarterMail.RemoteInterface.IMail.GetMailListById(String sessionStr, String domainName, Int32 listId)
   at SMWeb.HelperClasses.RemoteWrapper.SessionCallWithConnection[T](UserData usr, Func`2 f)
   at SMWeb.DomainAdmin.frmLists.DeleteIcon_Click(Object sender, EventArgs e)
   at SmarterTools.Web.WebControls.MenuItem.RaisePostBackEvent(String args)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Request information: 
    Request URL: [snip]
    Request path: /DomainAdmin/frmLists.aspx 
    User host address: 50.73.111.1 
    User:  
    Is authenticated: False 
    Authentication Type:  
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
 
Thread information: 
    Thread ID: 125 
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
    Is impersonating: False 
    Stack trace:    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at SmarterMail.RemoteInterface.IMail.GetMailListById(String sessionStr, String domainName, Int32 listId)
   at SMWeb.HelperClasses.RemoteWrapper.SessionCallWithConnection[T](UserData usr, Func`2 f)
   at SMWeb.DomainAdmin.frmLists.DeleteIcon_Click(Object sender, EventArgs e)
   at SmarterTools.Web.WebControls.MenuItem.RaisePostBackEvent(String args)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details: 

Reply to Thread