|
Upgrade error from 3.0 to 3.1 Cutechat and Cutemessenger
Last post 10-23-2006, 11:36 AM by Adam. 3 replies.
-
10-21-2006, 4:54 PM |
-
TLI
-
-
-
Joined on 10-15-2006
-
-
Posts 3
-
-
|
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 |
-
10-21-2006, 11:44 PM |
-
TLI
-
-
-
Joined on 10-15-2006
-
-
Posts 3
-
-
|
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 |
-
Adam
-
-
-
Joined on 09-23-2003
-
Aurora, ON
-
Posts 18,678
-
-
|
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
|
|
|
|
|