|
|
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
|
|
|
|
|