| Author |  | 
      
        | neil.dobson Newbie
 
  
 
 Joined: 11 July 2011
 Location: Australia
 Online Status: Offline
 Posts: 3
 | 
          Hi,
           | Posted: 11 July 2011 at 1:51am | IP Logged |   |  
           | 
 |  I'm just trialing WebMail Pro and i'm unable to save any signatures. All accounts just give internal server error.
 I tried re-installing the whole system including removing the db and starting from scratch but the same error occurs every time.
 Everything else is working fine.
 Here's the debug log:
 
 [11/07/2011 6:43:08 PM][] - >>>>>>>>>>>>>>>>  IN  >>>>>>>>>>>>>>>>
 [11/07/2011 6:43:08 PM][] - <?xml version="1.0" encoding="utf-8"?><webmail><param name="action" value="update"/><param name="request" value="identity"/><identity html_signature="0" use_signature="1" id_acct="1" id="-1"><email><![CDATA[user@mydomain.net]]></email><name><![CDATA[fffdfgdfgdf]]></name><signature><![CDATA[undefined]]></signature></identity></webmail>
 [11/07/2011 6:43:08 PM][] - >>>>>>>>>>>>>>>>  IN  >>>>>>>>>>>>>>>>
 [11/07/2011 6:43:08 PM][CreateParameter] - @id_user='1'
 [11/07/2011 6:43:08 PM][CreateParameter] - @id_acct='1'
 [11/07/2011 6:43:08 PM][CreateParameter] - @email='user@mydomain.net'
 [11/07/2011 6:43:08 PM][CreateParameter] - @friendly_nm='fffdfgdfgdf'
 [11/07/2011 6:43:08 PM][CreateParameter] - @signature='undefined'
 [11/07/2011 6:43:08 PM][CreateParameter] - @use_signature='True'
 [11/07/2011 6:43:08 PM][CreateParameter] - @signature_type='0'
 [11/07/2011 6:43:08 PM][CreateParameter] - @id_identity='-1'
 [11/07/2011 6:43:08 PM][PrepareCommand] - UPDATE awm_identity SET
 id_user = @id_user,
 id_acct = @id_acct,
 email = @email,
 friendly_nm = @friendly_nm,
 signature = @signature,
 use_signature = @use_signature,
 signature_type = @signature_type
 WHERE id_identity=@id_identity
 ------------------------------------------------------------
 [11/07/2011 6:43:08 PM] ERROR!!!
 [Message]
 Internal Server Error. Please, contact your system administrator in order to report the problem.
 [TargetSite]
 Void OnError(System.Data.SqlClient.SqlException, Boolean)
 [Stack Trace]
 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
 at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
 at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
 at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
 at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
 at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
 at WebMail.DbManager.UpdateIdentity(Int32 id_identity, Int32 id_user, Int32 id_acct, String email, String friendly_nm, String signature, Boolean use_signature, SignatureType signature_type)
 [Method]: UpdateIdentity
 [Line, Column]: [0, 0]
 ------------------------------------------------------------
 [11/07/2011 6:43:08 PM][] - <<<<<<<<<<<<<<<<<  OUT  <<<<<<<<<<<<<<<
 [11/07/2011 6:43:08 PM][] - <?xml version="1.0" encoding="utf-8"?><webmail><error><![CDATA[Internal Server Error. Please, contact your system administrator in order to report the problem.]]></error></webmail>
 [11/07/2011 6:43:08 PM][] - <<<<<<<<<<<<<<<<<  OUT  <<<<<<<<<<<<<<<
 
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | neil.dobson Newbie
 
  
 
 Joined: 11 July 2011
 Location: Australia
 Online Status: Offline
 Posts: 3
 | 
          FYI, running v6.2 .NET under IIS7.5 on Win2008R2 with SQL Server 2008R2 on remote machine.
           | Posted: 11 July 2011 at 1:54am | IP Logged |   |  
           | 
 |  | 
       
        | Back to Top |     | 
       
       
        |  | 
        | neil.dobson Newbie
 
  
 
 Joined: 11 July 2011
 Location: Australia
 Online Status: Offline
 Posts: 3
 | 
          Furthermore, table awm_identity does not exist in the db. Here's the tables that do exist:
           | Posted: 11 July 2011 at 1:59am | IP Logged |   |  
           | 
 |  
 a_users
 acal_appointments
 acal_calendars
 acal_cron_runs
 acal_eventrepeats
 acal_events
 acal_exclusions
 acal_publications
 acal_reminders
 acal_sharing
 acal_users_data
 awm_accounts
 awm_addr_book
 awm_addr_groups
 awm_addr_groups_contacts
 awm_domains
 awm_filters
 awm_folders
 awm_folders_tree
 awm_messages
 awm_messages_body
 awm_reads
 awm_senders
 awm_settings
 awm_subadmin_domains
 awm_subadmins
 awm_temp
 
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | Igor AfterLogic Support
 
  
 
 Joined: 24 June 2008
 Location: United States
 Online Status: Offline
 Posts: 6168
 | 
          Have passed this over to the developers, will keep you posted.
           | Posted: 11 July 2011 at 10:18pm | IP Logged |   |  
           | 
 |  
 --
 Regards,
 Igor, AfterLogic Support
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | Igor AfterLogic Support
 
  
 
 Joined: 24 June 2008
 Location: United States
 Online Status: Offline
 Posts: 6168
 | 
          The issue has been fixed, please try the update and let us know if it works for you.
           | Posted: 12 July 2011 at 10:29pm | IP Logged |   |  
           | 
 |  
 --
 Regards,
 Igor, AfterLogic Support
 | 
       
        | Back to Top |     | 
       
       
        |  |