Unable to load or create chat rooms

Last post 11-17-2008, 11:01 PM by cutechat. 3 replies.
Sort Posts: Previous Next
  •  11-17-2008, 10:12 PM 45893

    Unable to load or create chat rooms


    My developer is having issues with creating chat rooms via the admin pages or open existing chat room. We get the following error when the API tries to load the chat room:

    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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

    Source Error:

    Line 150:   <%IChatLobby[] lobbies=ChatApi.GetLobbyArray();%>

    Stack Trace:

     

    [SqlNullValueException: Data is Null. This method or property cannot be called on Null values.]

       System.Data.SqlClient.SqlBuffer.get_String() +80

       System.Data.SqlClient.SqlDataReader.GetString(Int32 i) +52

       CuteChat.SqlServerDataProvider.GetLobbies() +395

       CuteChat.ChatDataManager.GetLobbies() +38

       CuteChat.ChatApi.GetLobbyArray() +111

       ASP.cutesoft_client_cutechat_channel_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in d:"Web"Staging"CuteSoft_Client"CuteChat"Channel.aspx:150

       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +98

       System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20

       System.Web.UI.Page.Render(HtmlTextWriter writer) +26

       CuteChat.ChatPageBase.Render(HtmlTextWriter writer) +65

       System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25

       System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121

       System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22

       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2558

     Can someone help? We've had this issue since Oct 29 and have submitted a support request.

  •  11-17-2008, 10:26 PM 45895 in reply to 45893

    Re: Unable to load or create chat rooms

    Hi,
     
    Can you check the SqlServer table CuteChat4_Lobby ?
     
    All columns should not allow DBNull.
     
    Regards,
    Terry
  •  11-17-2008, 10:46 PM 45896 in reply to 45895

    Re: Unable to load or create chat rooms

    Thank you, Terry.
     
    What should be in the columns that are empty?
     
    v/r, Christina
  •  11-17-2008, 11:01 PM 45897 in reply to 45896

    Re: Unable to load or create chat rooms

    Christina,
     
    The columns allow empty string "" , but should not be NULL .
     
    If you found the columns allow NULL , please run the SQL SCRIPT again.
     
    Regards,
    Terry
     
View as RSS news feed in XML