Database Error

  •  07-27-2004, 3:04 PM

    Database Error

    Hi,

     
    I get a database error when I attempt to use Chat.
    It installed fine and I setup a room ok but when I click on Chat I get the error shown below
    CuteChat appears to be looking for an object which doesn't exist in the database.
    I am running DNN 2.12 with an MS SQL Server 2000 database.
    Cheer
    Gordon
     
    ------------------------------------------------------------------------------------------
     

    Server Error in '/DotNetNuke' Application.

    Invalid object name 'dbo.Users'.

    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: Invalid object name 'dbo.Users'.

    Source Error:

    Line 28: 	room=rm.GetRoom(roomid);
    Line 29: 	
    Line 30: 	string adminuniquename=UserIdentityAdapter.DefaultAdapter.GetCurrentUserUniqueName(Context);
    Line 31: 	if(adminuniquename==null||adminuniquename=="")
    Line 32: 	{

    Source File: C:\Inetpub\DotNetNuke\DesktopModules\CuteChat\ChatRoom.Aspx    Line: 30

    Stack Trace:

    [SqlException: Invalid object name 'dbo.Users'.]
       System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +264
       System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +877
       CuteChat.DotNetNukeLib.DotNetNukeSqlDataProvider.GetUserUniqueName(Int32 userid) in l:\solutions\cutechat\toolkit\solution\cutechat.dotnetnukelib\sqldataprovider.cs:37
       CuteChat.DotNetNukeLib.SqlServerUserIdentityAdapter.GetCurrentUserUniqueName(HttpContext context) in l:\solutions\cutechat\toolkit\solution\cutechat.dotnetnukelib\useridentityadapter.cs:31
       ASP.ChatRoom_Aspx.OnInit(EventArgs args) in C:\Inetpub\DotNetNuke\DesktopModules\CuteChat\ChatRoom.Aspx:30
       System.Web.UI.Control.InitRecursive(Control namingContainer) +241
       System.Web.UI.Page.ProcessRequestMain() +174
    


    Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
    ------------------------------------------------------------------------------------------
View Complete Thread