Admin Edit Messages error RSS

• • Reply
  para7

  None

  0 Points

  377 Posts

  Admin Edit Messages error

  Nov 03, 2003 10:43 AM|para7|LINK

  It seems I can not save any messages. I get: " SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. Source Error: Line 102: Line 103: void btnEdit_Click(Object s, EventArgs e) { Line 104: AdminUtility.EditMessage(dropMessageNames.SelectedItem.Text, txtMessageTitle.Text, txtMessageBody.Text); Line 105: } Line 106: " Anyone else have this problem ?
  Jørgen A.J.
  
  
  
• • Reply
  mumfie2003

  None

  0 Points

  241 Posts

  Re: Admin Edit Messages error

  Nov 03, 2003 11:19 AM|mumfie2003|LINK

  Yes. I have seen it but not had a chance to investigate it. HTH
  Colin Munford
  
  
  http://www.colin-munford.me.uk
• • Reply
  Redd

  Member

  35 Points

  1052 Posts

  Re: Admin Edit Messages error

  Nov 03, 2003 11:21 AM|Redd|LINK

  Dunno... sounds pretty serious though. May want to contact your SQL admin on that one.
  Stephen M. Redd
  http://www.reddnet.net
• • Reply
  para7

  None

  0 Points

  377 Posts

  Re: Admin Edit Messages error

  Nov 03, 2003 11:53 AM|para7|LINK

  It's the same on localhost and local database...
  Jørgen A.J.
  
  
  
• • Reply
  mumfie2003

  None

  0 Points

  241 Posts

  Re: Admin Edit Messages error

  Nov 03, 2003 01:12 PM|mumfie2003|LINK

  I have not seen problem on localhost. Strangely the table Community_Messages seems to get updated even though the error is reported. I did remove the embedded <> as a test but the error still occurs regardless.
  Colin Munford
  
  
  http://www.colin-munford.me.uk
• • Reply
  mumfie2003

  None

  0 Points

  241 Posts

  Re: Admin Edit Messages error

  Nov 03, 2003 03:08 PM|mumfie2003|LINK

  Para7, I updated the collation to database default on the ntext and nVarChar fields in table Community_messages using Enterprise Manager. Seems to have resolved the error on mine although not sure why. HTH
  Colin Munford
  
  
  http://www.colin-munford.me.uk
• • Reply
  para7

  None

  0 Points

  377 Posts

  Re: Admin Edit Messages error

  Nov 03, 2003 06:35 PM|para7|LINK

  How do I do that. If I open in design view I find no update function. But I can kind of reconfigure the collation. But same errors after that.
  Jørgen A.J.
  
  
  
• • Reply
  mumfie2003

  None

  0 Points

  241 Posts

  Re: Admin Edit Messages error

  Nov 04, 2003 03:40 AM|mumfie2003|LINK

  Open the table in EM design mode and select the column. On the column properties tab is a field "collation" Click on the "..." then press button "Restore Default" Close the dialog and save the changes. Thats the method I used. HTH
  Colin Munford
  
  
  http://www.colin-munford.me.uk
• • Reply
  para7

  None

  0 Points

  377 Posts

  Re: Admin Edit Messages error

  Nov 04, 2003 08:27 AM|para7|LINK

  And it worked for me too. Thanks for help...
  Jørgen A.J.