Upgrade error from 3.0 to 3.1 Cutechat and Cutemessenger

Last post 10-23-2006, 11:36 AM by Adam. 3 replies.
Sort Posts: Previous Next
  •  10-21-2006, 4:54 PM 23755

    Upgrade error from 3.0 to 3.1 Cutechat and Cutemessenger

    Need help not sure if I am deleting everything but need help installing. on dotnetnuke install 4.3.5
     
    StartJob Registering DesktopModule
    Info Registering Definitions
    Failure

    ExceptionSystem.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleDefinitions'. Cannot insert duplicate key in object 'ModuleDefinitions'. The statement has been terminated. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleDefinition(Int32 DesktopModuleId, String FriendlyName, Int32 DefaultCacheTime) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.RegisterModules(PaFolder Folder, ArrayList Modules, ArrayList Controls) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()

     

  •  10-21-2006, 11:25 PM 23759 in reply to 23755

    Re: Upgrade error from 3.0 to 3.1 Cutechat and Cutemessenger

    TLI,
     
    When upgrading to 3.1.1, please update CuteSoft.Chat.dll, all client files and run the followintg upgrade script:
     
    upgrade_3.1_to_3.1.1.sql
     
    If you want to run the PA for the DNN, please remove all the existing chat and messenger first.
     
    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

  •  10-21-2006, 11:44 PM 23760 in reply to 23759

    Re: Upgrade error from 3.0 to 3.1 Cutechat and Cutemessenger

    where do I download this sql script.  I do not see it in the download for cutechat or messenger
  •  10-23-2006, 11:36 AM 23767 in reply to 23760

    Re: Upgrade error from 3.0 to 3.1 Cutechat and Cutemessenger

    TLI,
     
    upgrade_3.0_to_3.1.sql
     

    CREATE TABLE [dbo].[CuteSupportNote] (
     [NoteId] [int] IDENTITY (1, 1) NOT NULL ,
     [OperatorId] [int] NOT NULL ,
     [OperatorName] [nvarchar] (50)  NOT NULL ,
     [CreateTime] [datetime] NOT NULL ,
     [UpdateTime] [datetime] NOT NULL ,
     [Color] [nvarchar] (50)  NOT NULL ,
     [Title] [nvarchar] (200)  NOT NULL ,
     [Content] [ntext]  NOT NULL
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    ALTER TABLE [dbo].[CuteSupportNote] WITH NOCHECK ADD
     CONSTRAINT [PK_CuteSupportNote] PRIMARY KEY  CLUSTERED
     (
      [NoteId]
     )  ON [PRIMARY]
    CREATE TABLE [dbo].[CuteSupportSession] (
     [LocationId] [int] IDENTITY (1, 1) NOT NULL ,
     [CustomerId] [uniqueidentifier] NOT NULL ,
     [BeginTime] [datetime] NOT NULL ,
     [ActiveTime] [datetime] NOT NULL ,
     [UserId] [int] NULL ,
     [DisplayName] [nvarchar] (50)  NOT NULL ,
     [IPAddress] [nvarchar] (50)  NOT NULL ,
     [Culture] [nvarchar] (50)  NOT NULL ,
     [Platform] [nvarchar] (50)  NOT NULL ,
     [Browser] [nvarchar] (50)  NOT NULL ,
     [OperatorId] [int] NOT NULL ,
     [OperatorName] [nvarchar] (50)  NOT NULL ,
     [PubicProperties] [ntext]  NULL
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    ALTER TABLE [dbo].[CuteSupportSession] WITH NOCHECK ADD
     CONSTRAINT [PK_CuteSupportSession] PRIMARY KEY  CLUSTERED
     (
      [LocationId]
     )  ON [PRIMARY]
    ALTER TABLE dbo.CuteChatClient ADD
     IPAddress nvarchar(50) NULL
    ALTER TABLE dbo.CuteSupportCustomer ADD
     Platform nvarchar(50) NULL
    ALTER TABLE dbo.CuteSupportCustomer ADD
     Browser nvarchar(50) NULL
    ALTER TABLE dbo.CuteSupportCustomer
     DROP COLUMN LocationId

    GO
    EXEC sp_rename 'CuteChatClient.AnonymousPubicProperties', 'AnonymousPublicProperties', 'COLUMN';
    GO
    GO
    EXEC sp_rename 'CuteChatUser.PubicProperties', 'PublicProperties', 'COLUMN';
    GO
    GO
    EXEC sp_rename 'CuteSupportSession.PubicProperties', 'PublicProperties', 'COLUMN';
    GO
    GO
    EXEC sp_rename 'CuteSupportCustomer.PubicProperties', 'PublicProperties', 'COLUMN';

    GO
     
     
    upgrade_3.1_to_3.1.1.sql
     
    GO
    EXEC sp_rename 'CuteChatClient.AnonymousPubicProperties', 'AnonymousPublicProperties', 'COLUMN';
    GO
    GO
    EXEC sp_rename 'CuteChatUser.PubicProperties', 'PublicProperties', 'COLUMN';
    GO
    GO
    EXEC sp_rename 'CuteSupportSession.PubicProperties', 'PublicProperties', 'COLUMN';
    GO
    GO
    EXEC sp_rename 'CuteSupportCustomer.PubicProperties', 'PublicProperties', 'COLUMN';
    GO


    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

View as RSS news feed in XML