Database Error

Last post 07-28-2004, 9:48 AM by cutechat. 5 replies.
Sort Posts: Previous Next
  •  07-27-2004, 3:04 PM 1332

    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
    ------------------------------------------------------------------------------------------
  •  07-27-2004, 3:20 PM 1334 in reply to 1332

    Re: Database Error

    gordonk,

     
     
    Please check your sql server database: who is the owner of the Users table?

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

  •  07-27-2004, 10:18 PM 1335 in reply to 1332

    Re: Database Error

    Hi :

     
    Maybe you choose the option 'Create New DataBase' while installation.
     
    and then the 'configuration/cuteChat/@ConnectionString' would be "Server=(local);Database=DotNetNuke;uid=sa;pwd=abcde;application name=CuteChatSample"
     
    please check your web.config , and change
     
    <add key="CuteChatDotNetNukeOwnerPrefix" value="dbo." />
     
    to
     
    <add key="CuteChatDotNetNukeOwnerPrefix" value="DotNetNuke.dbo." /> (if your DotNetNuke's database name is 'DotNetNuke')
     
    That's OK if your DotNetNuke application use the <data defaultProvider="SqlDataProvider">
     
    ---
     
    If your DotNetNuke application use AccessDataProvider, the cutechat current not support 'directly' now!
    But if your are insteresting in the CuteChat.DotNetNukeLib.dll
    You could found the source in the folder :
    C:\Program Files\CuteSoft\CuteChat\Toolkit\Solution\CuteChat.DotNetNukeLib\
    You could modify the code to connect the acess database as you want.
     
     
    Hope that helps.
     
     
     
  •  07-27-2004, 10:22 PM 1336 in reply to 1335

    Re: Database Error

    Hi,
    -->
    Server=(local);Database=CuteChatSample;uid=sa;pwd=abcde;
     
    :-)
  •  07-28-2004, 5:44 AM 1340 in reply to 1335

    Re: Database Error

    Hi,
     
    -------------------------------------------------------------------------------------
     cutechat wrote:

    Hi :

    Maybe you choose the option 'Create New DataBase' while installation.
    -------------
    please check your web.config , and change
    <add key="CuteChatDotNetNukeOwnerPrefix" value="dbo." />
    to
    <add key="CuteChatDotNetNukeOwnerPrefix" value="DotNetNuke.dbo." /> (if your DotNetNuke's database name is 'DotNetNuke')
     
     
    Thank you!! It works fine now
  •  07-28-2004, 9:48 AM 1343 in reply to 1340

    Re: Database Error

    :-)
     

    Glad that I could help .

View as RSS news feed in XML