| Author |
Messages |
|
memond
Posts:19
Send A Message
 |
| 01/30/2008 3:09 PM |
|
Hi I tried installing the first part of the search tool, the Seamus zip file and I got an error. I uninstalled the module (I think - this was last week - but at any rate it wasn'tin the module list) and downloaded the latest versions 4.5.5 I think it was, anyway I tried installing Seamus again and got an error again. Could someone tell me what I might be doing wrong?
Thanks
Mike
I am running:
DNN 4.6.0
MSSQL 2005
Here are the errors:
StartJob Start Sql execution: 01.00.00.SqlDataProvider file
Failure
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 4: Incorrect syntax near 'fulltext'. 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 (left(@@VERSION, 26)) = 'Microsoft SQL Server 2005 ' BEGIN Create fulltext index On dbo.[Venexus_BrainDump] (IndexURL, IndexTitle, IndexWashedContent) Key Index PKVenexusSearchEngine On VenexusSearchCatalog With Change_Tracking Auto END System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'. 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 (left(@@VERSION, 26)) = 'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_column 'dbo.[Venexus_BrainDump]', 'IndexWashedContent', 'add' END System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'. 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 (left(@@VERSION, 26)) = 'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_table 'dbo.[Venexus_BrainDump]', 'activate' END System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'. 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 (left(@@VERSION, 26)) = 'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_table 'dbo.[Venexus_BrainDump]', 'start_full' END
StartJob Start Sql execution: 02.02.03.SqlDataProvider file
Failure
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'Approved' in table 'dbo.Venexus_IndexCategory' is specified more than once. 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.[Venexus_IndexCategory] ADD Approved bit
EndJob End Sql execution: 02.02.03.SqlDataProvider file
StartJob Start Sql execution: 02.02.05.SqlDataProvider file
Failure
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'Count' in table 'dbo.Venexus_Keyword' is specified more than once. 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.[Venexus_Keyword] ADD [Count] int DEFAULT ((0))
EndJob End Sql execution: 02.02.05.SqlDataProvider file
StartJob Start Sql execution: 02.04.02.SqlDataProvider file
Failure
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'Venexus_CategorySecurity' in the database. 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 not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[}Venexus_CategorySecurity]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE dbo.[Venexus_CategorySecurity] ( [CategorySecurityID] [int] IDENTITY (1, 1) NOT NULL , [CategoryID] [int] NOT NULL , [UserID] [int] NULL , [RoleID] [int] NULL , [CreateDate] [datetime] NOT NULL , [StartDate] [datetime] NULL , [EndDate] [datetime] NULL , [RequireApproval] [bit] NOT NULL , [ModuleID] [int] NULL , CONSTRAINT [PK_Venexus_CategorySecurity] PRIMARY KEY CLUSTERED ( [CategorySecurityID] ) ON [PRIMARY] ) ON [PRIMARY] END
EndJob End Sql execution: 02.04.02.SqlDataProvider file
|
|
|
|
|
memond
Posts:19
Send A Message
|
| 01/30/2008 3:19 PM |
|
Just to add to the last post...
I went back to module definitions page after the above install attempt. I noticed venexus.seamus version 2. something there, may have just missed it the first time, hit the edit button as I was goin got ununstall it and the site kinda blew up. Not able to get anything more than a site error page when I try to get back into the site. |
|
|
|
|
Venexus Host
Posts:24
Send A Message
|
| 01/30/2008 4:01 PM |
|
| looks like some tables still existed when you installed again. |
|
|
|
|
Venexus Host
Posts:24
Send A Message
|
| 01/30/2008 4:02 PM |
|
| You Edited the module defs? I am not sure I understand. You reinstalled and the entire site is down? Did you change the web.config for custom errors from "RemoteOnly" to "Off" to get full error message? |
|
|
|
|
memond
Posts:19
Send A Message
|
| 01/30/2008 4:03 PM |
|
| Hrm, should I delete all the venexus tables to restore the site? We looked at them and they were all cleared out. |
|
|
|
|
memond
Posts:19
Send A Message
|
| 01/31/2008 4:00 PM |
|
Problem seems to be resolved. We fixed a table error we had on our end that was bringing the site down but I still got a seamus error upon install - pasted below on request from Venexus. I continued on with the configure and search install without issue. The error does not seem to have an effect on the search and all is looking well at the moment.
Thanks for all the help and the quick responses Venexus support!
Mike
Seamus install errors:
StartJob Starting Installation
StartJob Reading files
Info Loading tempdocs/temp.txt
Info File tempdocs\temp.txt read successfully
Info Loading 01.02.00.SqlDataProvider
Info File 01.02.00.SqlDataProvider read successfully
Info Loading 02.00.00.SqlDataProvider
Info File 02.00.00.SqlDataProvider read successfully
Info Loading 02.01.00.SqlDataProvider
Info File 02.01.00.SqlDataProvider read successfully
Info Loading 02.02.03.SqlDataProvider
Info File 02.02.03.SqlDataProvider read successfully
Info Loading EditVenexusSeamus.ascx.resx
Info File EditVenexusSeamus.ascx.resx read successfully
Info Loading SeamusImage.aspx
Info File SeamusImage.aspx read successfully
Info Loading seamusfetching.gif
Info File seamusfetching.gif read successfully
Info Loading seamus.xslt
Info File seamus.xslt read successfully
Info Loading seamus.gif
Info File seamus.gif read successfully
Info Loading rss.gif
Info File rss.gif read successfully
Info Loading itextsharp.dll
Info File itextsharp.dll read successfully
Info Loading EntitySpaces.Interfaces.dll
Info File EntitySpaces.Interfaces.dll read successfully
Info Loading EntitySpaces.Core.dll
Info File EntitySpaces.Core.dll read successfully
Info Loading DocConverter.dll
Info File DocConverter.dll read successfully
Info Loading temp.txt
Info File temp.txt read successfully
Info Loading EntitySpaces.SqlClientProvider.dll
Info File EntitySpaces.SqlClientProvider.dll read successfully
Info Loading EntitySpaces.LoaderMT.dll
Info File EntitySpaces.LoaderMT.dll read successfully
Info Loading EntitySpaces.Web.dll
Info File EntitySpaces.Web.dll read successfully
Info Loading EntitySpaces.Web.Design.dll
Info File EntitySpaces.Web.Design.dll read successfully
Info Loading 01.00.00.SqlDataProvider
Info File 01.00.00.SqlDataProvider read successfully
Info Loading 02.01.05.SqlDataProvider
Info File 02.01.05.SqlDataProvider read successfully
Info Loading 02.02.00.SqlDataProvider
Info File 02.02.00.SqlDataProvider read successfully
Info Loading 02.02.01.SqlDataProvider
Info File 02.02.01.SqlDataProvider read successfully
Info Loading 02.02.02.SqlDataProvider
Info File 02.02.02.SqlDataProvider read successfully
Info Loading ViewVenexusSeamus.ascx.resx
Info File ViewVenexusSeamus.ascx.resx read successfully
Info Loading EditVenexusSeamus.ascx
Info File EditVenexusSeamus.ascx read successfully
Info Loading ViewVenexusSeamus.ascx
Info File ViewVenexusSeamus.ascx read successfully
Info Loading 02.03.04.SqlDataProvider
Info File 02.03.04.SqlDataProvider read successfully
Info Loading RadAjax.Net2.dll
Info File RadAjax.Net2.dll read successfully
Info Loading 02.04.00.SqlDataProvider
Info File 02.04.00.SqlDataProvider read successfully
Info Loading 02.04.02.SqlDataProvider
Info File 02.04.02.SqlDataProvider read successfully
Info Loading 02.02.05.SqlDataProvider
Info File 02.02.05.SqlDataProvider read successfully
Info Loading 02.04.01.SqlDataProvider
Info File 02.04.01.SqlDataProvider read successfully
Info Loading Settings.ascx.resx
Info File Settings.ascx.resx read successfully
Info Loading Uninstall.SqlDataProvider
Info File Uninstall.SqlDataProvider read successfully
Info Loading Venexus.Modules.VenexusSeamus.dll
Info File Venexus.Modules.VenexusSeamus.dll read successfully
Info Loading VenexusSeamus.dnn
Info File VenexusSeamus.dnn read successfully
Info Loading Settings.ascx
Info File Settings.ascx read successfully
Info Loading 02.04.04.SqlDataProvider
Info File 02.04.04.SqlDataProvider read successfully
EndJob Reading files done.
StartJob Reading Installation Manifest file
Info DNN file is in valid 3.0 format.
Info xml loaded.
Info Loading files info
Info Found valid path (tempdocs) for temp.txt.
Info Found valid path (App_LocalResources) for ViewVenexusSeamus.ascx.resx.
Info Found valid path (App_LocalResources) for EditVenexusSeamus.ascx.resx.
Info Found valid path (App_LocalResources) for Settings.ascx.resx.
Info Loading Modules info
Info Loading Control info for 'VenexusSeamus' module
EndJob Manifest file finished successfully
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: Line 4:
Incorrect syntax near 'fulltext'. 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 (left(@@VERSION, 26)) =
'Microsoft SQL Server 2005 ' BEGIN Create fulltext index On dbo.[Venexus_BrainDump] (IndexURL, IndexTitle,
IndexWashedContent) Key Index PKVenexusSearchEngine On VenexusSearchCatalog With Change_Tracking Auto END
System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'.
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 (left(@@VERSION, 26)) =
'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_column 'dbo.[Venexus_BrainDump]', 'IndexWashedContent', 'add'
END System.Data.SqlClient.SqlException: You must first create a full-text index on table
'dbo.[Venexus_BrainDump]'. 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 (left(@@VERSION, 26)) =
'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_table 'dbo.[Venexus_BrainDump]', 'activate' END
System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'.
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 (left(@@VERSION, 26)) =
'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_table 'dbo.[Venexus_BrainDump]', 'start_full' END
EndJob End Sql execution: 01.00.00.SqlDataProvider file
Info Executing 01.02.00.SqlDataProvider
StartJob Start Sql execution: 01.02.00.SqlDataProvider file
EndJob End Sql execution: 01.02.00.SqlDataProvider file
Info Executing 02.00.00.SqlDataProvider
StartJob Start Sql execution: 02.00.00.SqlDataProvider file
EndJob End Sql execution: 02.00.00.SqlDataProvider file
Info Executing 02.01.00.SqlDataProvider
StartJob Start Sql execution: 02.01.00.SqlDataProvider file
EndJob End Sql execution: 02.01.00.SqlDataProvider file
Info Executing 02.01.05.SqlDataProvider
StartJob Start Sql execution: 02.01.05.SqlDataProvider file
EndJob End Sql execution: 02.01.05.SqlDataProvider file
Info Executing 02.02.00.SqlDataProvider
StartJob Start Sql execution: 02.02.00.SqlDataProvider file
EndJob End Sql execution: 02.02.00.SqlDataProvider file
Info Executing 02.02.01.SqlDataProvider
StartJob Start Sql execution: 02.02.01.SqlDataProvider file
EndJob End Sql execution: 02.02.01.SqlDataProvider file
Info Executing 02.02.02.SqlDataProvider
StartJob Start Sql execution: 02.02.02.SqlDataProvider file
EndJob End Sql execution: 02.02.02.SqlDataProvider file
Info Executing 02.02.03.SqlDataProvider
StartJob Start Sql execution: 02.02.03.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names
in each table must be unique. Column name 'Approved' in table 'dbo.Venexus_IndexCategory' is specified more than
once. 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.[Venexus_IndexCategory] ADD Approved bit
EndJob End Sql execution: 02.02.03.SqlDataProvider file
Info Executing 02.02.05.SqlDataProvider
StartJob Start Sql execution: 02.02.05.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is
already an object named 'Venexus_CategorySecurity' in the database. 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 not exists (select *
from dbo.sysobjects where id = object_id(N'dbo.[}Venexus_CategorySecurity]') and OBJECTPROPERTY(id, N'IsTable') =
1) BEGIN CREATE TABLE dbo.[Venexus_CategorySecurity] ( [CategorySecurityID] [int] IDENTITY (1, 1) NOT NULL ,
[CategoryID] [int] NOT NULL , [UserID] [int] NULL , [RoleID] [int] NULL , [CreateDate] [datetime] NOT NULL ,
[StartDate] [datetime] NULL , [EndDate] [datetime] NULL , [RequireApproval] [bit] NOT NULL , [ModuleID] [int]
NULL , CONSTRAINT [PK_Venexus_CategorySecurity] PRIMARY KEY CLUSTERED ( [CategorySecurityID] ) ON [PRIMARY] ) ON
[PRIMARY] END System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'Count'
in table 'dbo.Venexus_Keyword' is specified more than once. 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.[Venexus_Keyword] ADD [Count] int DEFAULT ((0))
EndJob End Sql execution: 02.02.05.SqlDataProvider file
Info Executing 02.04.00.SqlDataProvider
StartJob Start Sql execution: 02.04.00.SqlDataProvider file
EndJob End Sql execution: 02.04.00.SqlDataProvider file
Info Executing 02.04.01.SqlDataProvider
StartJob Start Sql execution: 02.04.01.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names
in each table must be unique. Column name 'Title' in table 'dbo.Venexus_UserIndex' is specified more than once.
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.[Venexus_UserIndex] ADD [Title] nvarchar(250) System.Data.SqlClient.SqlException: Column names in each table
must be unique. Column name 'URL' in table 'dbo.Venexus_UserIndex' is specified more than once. 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.[Venexus_UserIndex] ADD [URL] nvarchar(2000)
EndJob End Sql execution: 02.04.01.SqlDataProvider file
Info Executing 02.04.02.SqlDataProvider
StartJob Start Sql execution: 02.04.02.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is
already an object named 'Venexus_CategorySecurity' in the database. 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 not exists (select *
from dbo.sysobjects where id = object_id(N'dbo.[}Venexus_CategorySecurity]') and OBJECTPROPERTY(id, N'IsTable') =
1) BEGIN CREATE TABLE dbo.[Venexus_CategorySecurity] ( [CategorySecurityID] [int] IDENTITY (1, 1) NOT NULL ,
[CategoryID] [int] NOT NULL , [UserID] [int] NULL , [RoleID] [int] NULL , [CreateDate] [datetime] NOT NULL ,
[StartDate] [datetime] NULL , [EndDate] [datetime] NULL , [RequireApproval] [bit] NOT NULL , [ModuleID] [int]
NULL , CONSTRAINT [PK_Venexus_CategorySecurity] PRIMARY KEY CLUSTERED ( [CategorySecurityID] ) ON [PRIMARY] ) ON
[PRIMARY] END
EndJob End Sql execution: 02.04.02.SqlDataProvider file
Info Executing 02.04.04.SqlDataProvider
StartJob Start Sql execution: 02.04.04.SqlDataProvider file
EndJob End Sql execution: 02.04.04.SqlDataProvider file
EndJob Finished Sql execution
StartJob Creating files
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\ViewVenexusSeamus.ascx
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\EditVenexusSeamus.ascx
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Settings.ascx
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\SeamusImage.aspx
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\rss.gif
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\seamus.gif
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\seamus.xslt
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\seamusfetching.gif
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\01.00.00.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\01.02.00.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.00.00.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.01.00.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.01.05.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.02.00.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.02.01.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.02.02.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.02.03.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.02.05.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.04.00.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.04.01.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.04.02.SqlData
Provider
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Providers\DataProviders\SqlDataProvider\02.04.04.SqlData
Provider
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\Uninstall.SqlDataProvider
Info Created D:\Sites\DotNetNuke\website\bin\EntitySpaces.Core.dll
Info Created D:\Sites\DotNetNuke\website\bin\EntitySpaces.Interfaces.dll
Info Created D:\Sites\DotNetNuke\website\bin\EntitySpaces.SqlClientProvider.dll
Info Created D:\Sites\DotNetNuke\website\bin\EntitySpaces.Web.Design.dll
Info Created D:\Sites\DotNetNuke\website\bin\EntitySpaces.Web.dll
Info Created D:\Sites\DotNetNuke\website\bin\EntitySpaces.LoaderMT.dll
Info Created D:\Sites\DotNetNuke\website\bin\RadAjax.Net2.dll
Info Created D:\Sites\DotNetNuke\website\bin\Venexus.Modules.VenexusSeamus.dll
Info Created D:\Sites\DotNetNuke\website\bin\DocConverter.dll
Info Created D:\Sites\DotNetNuke\website\bin\itextsharp.dll
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\tempdocs\temp.txt
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\App_LocalResources\ViewVenexusSeamus.ascx.resx
Info Created
D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\App_LocalResources\EditVenexusSeamus.ascx.resx
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\App_LocalResources\Settings.ascx.resx
Info Created D:\Sites\DotNetNuke\website\DesktopModules\VenexusSeamus\VenexusSeamus.dnn.config
EndJob Files created
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
EndJob Installation successful.
Loaded Seamus module on a page;
Noticed a broken image tag on the module face
|
|
|
|
|
Venexus Host
Posts:24
Send A Message
|
| 02/01/2008 10:06 AM |
|
| Those errors are fine. They just mean you already have a column or table in your db so it could not add it. |
|
|
|
|
memond
Posts:19
Send A Message
|
| 02/05/2008 11:37 AM |
|
Ok, thanks. That helps considerably in narrowing my trouble shooting! I did get an email from Jeff over the weekend indicating an authentication setting that is throwing things off, I'll delve into that a little deeper here and see if I can't fix the issue.
Thanks again,
Mike |
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
|
|
 |
|