Support forums » Products » Cute Chat and Cute Web Messeng... » Re: Install Problems

Install Problems

Last post 12-05-2007, 4:47 AM by jazzylily. 5 replies.
Sort Posts: Previous Next

  •  12-03-2007, 9:50 AM 35593

    Install Problems

    Reply Quote
    When I installed I had lots of errors with the sql
     
    I have took the sql file and tried to run it to find the problem. 
    This is what I get
     
    System.Data.SqlClient.SqlException: Unclosed quotation mark after the character string 'CuteChat4_Lobby]'. Incorrect syntax near 'CuteChat4_Lobby]'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CuteChat4_Lobby]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CuteChat4_Lobby]]
     
    Can anyone tell me what the problem could be?
     
    Thanks

  •  12-03-2007, 10:24 AM 35595 in reply to 35593

    Re: Install Problems

    Reply Quote
    jazzylily,
     
    Are you using Cute Chat standalone?
     
    Which version of SQL Server are you using?
     
    When did you get this error?
     
    Keep me posted
     
     

    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

  •  12-04-2007, 5:06 AM 35622 in reply to 35595

    Re: Install Problems

    Reply Quote
    I am not using any yet as i cant install it.  Appears that both have been installed.
     
    I am using SQL Server 2005.
     
    This is the error I get when I try to install
     
    StartJob Begin Sql execution
    Info Executing 01.00.00.SqlDataProvider
    StartJob Start Sql execution: 01.00.00.SqlDataProvider file
    Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE [dbo].[CuteChat4_SupportAgent] ADD CONSTRAINT [FK_CuteChat4_SupportAgent_CuteChat4_SupportDepartment] FOREIGN KEY ( [DepartmentId] ) REFERENCES [dbo].[CuteChat4_SupportDepartment] ( [DepartmentId] ) ON DELETE CASCADE GO
    EndJob End Sql execution: 01.00.00.SqlDataProvider file
     
    Broke it down and tried to run all statements separately but still no luck.
     
    Appreciate your help.
    Thanks
    Sarah
     

  •  12-04-2007, 6:10 AM 35623 in reply to 35622

    Re: Install Problems

    Reply Quote
    I have managed to get it installed and run the sql.  Tables do exist.
     
    Now when I try to add the embedded module to a page I just get a blank container.  Any ideas?

  •  12-04-2007, 10:11 AM 35630 in reply to 35623

    Re: Install Problems

    Reply Quote
    jazzylily,
     
    Have you finished the step below?
     
    Modify web.config file and Specify the CuteChat.DataDirectory

     <appSettings>
      ...
       <add key="CuteChat.DataDirectory" value="DesktopModules/CuteSoft_Client/CuteChat" />
      </appSettings>
     
     
     

    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

  •  12-05-2007, 4:47 AM 35659 in reply to 35630

    Re: Install Problems

    Reply Quote
    Thanks Adam.  I had to set up dotnetnuke again as there was a problem with my database.  Reinstalled it and all seems to be ok now.
View as RSS news feed in XML