Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/05/2006 10:50 AM by  Peter Donker
Full-text Search and DNN 4.3.5
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
SKung
New Member
New Member
Posts:1


--
12/04/2006 6:14 PM

    Hi,

    We recently purchased DMX module version 03.04.08 and we are trying to implement full-text search.

    Somehow, we are not able to get it to work.

    We had installed the demo version first prior to installing the professional version. 

    During install of the professional version, we received the following error messages:

    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandle
    dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at
    System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean
    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String
    sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
    DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at
    DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /**
    PROCEDURES ******/ CREATE PROCEDURE dbo.DMX_CleanupLog @ThresholdDate DateTim
    DELETE FROM DMX_Log WHERE ((DMX_Log.Datime < @ThresholdDate) AND (EntId IN ( SEL
    DMX_Entries WHERE DMX_Entries.PortalId = @PortalId) )) System.Data.SqlClient.SqlExcepti
    object named 'DMX_GetAllPortalCollections' in the database. at System.Data.SqlClient.SqlCon
    (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalCon
    Page 4 of 12
    LADANet > Host > File Manager ( DNN 4.3.5 )
    11/27/2006
    http://dapwbadm00002/Host/File%20Manager/tabid/19/ctl/Edit/mid/323/ftype/Module/rt...
    Failure
    (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.Thro
    (TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBe
    cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsPar
    stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodNam
    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String
    sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
    DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at
    DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CR
    dbo.DMX_GetAllPortalCollections @PortalId Int AS SELECT DMX_Entries.Description, DMX_En
    DMX_Entries WHERE (((DMX_Entries.EntryType) LIKE 'Collection') AND ((NOT DMX_Entries.D
    ((DMX_Entries.PortalId)=@PortalId)) ORDER BY DMX_Entries.Description System.Data.SqlC
    There is already an object named 'DMX_GetCollectionContents' in the database. at
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnect
    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean break
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateOb
    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, S
    dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at
    System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean
    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String
    sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
    DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at
    DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CR
    dbo.DMX_GetCollectionContents @ParentId Int AS SELECT DMX_Entries.*, LTrim(RTrim(User
    '+Users.LastName)) AS FullName FROM DMX_Entries INNER JOIN Users ON DMX_Entries.Use
    WHERE (((DMX_Entries.CollectionId)=@ParentId) And ((DMX_Entries.EntryId)=(DMX_Entrie
    System.Data.SqlClient.SqlException: There is already an object named 'DMX_GetLogForEntry
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnect
    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean break
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateOb
    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, S
    dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at
    System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean
    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String
    sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at
    DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at
    DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CR
    dbo.DMX_GetLogForEntry @LastVersionId Int AS SELECT DMX_Log.*, LTrim(RTrim(Users.Firs
    '+Users.LastName)) AS FullName, DMX_Entries.Version FROM DMX_Entries INNER JOIN (DM

    SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is

    named 'DMX_CleanupLog' in the database. at System.Data.SqlClient.SqlConnection.OnError(S

    Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlExcep

    breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParse

    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandle

    dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at

    System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean

    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String

    sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at

    DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at

    DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /**

    PROCEDURES ******/ CREATE PROCEDURE dbo.DMX_CleanupLog @ThresholdDate DateTim

    DELETE FROM DMX_Log WHERE ((DMX_Log.Datime < @ThresholdDate) AND (EntId IN ( SEL

    DMX_Entries WHERE DMX_Entries.PortalId = @PortalId) )) System.Data.SqlClient.SqlExcepti

    object named 'DMX_GetAllPortalCollections' in the database. at System.Data.SqlClient.SqlCon

    (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalCon

    Page LADANet > Host > File Manager ( DNN 4.3.5 ) e 4 of 12

    http://dapwbadm00002/Host/File%20Manager/tabid/19/ctl/Edit/mid/323/ftype/Module/rt... 11/27/2006

    Failure

    (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.Thro

    (TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBe

    cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsPar

    stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodNam

    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String

    sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at

    DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at

    DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CR

    dbo.DMX_GetAllPortalCollections @PortalId Int AS SELECT DMX_Entries.Description, DMX_En

    DMX_Entries WHERE (((DMX_Entries.EntryType) LIKE 'Collection') AND ((NOT DMX_Entries.D

    ((DMX_Entries.PortalId)=@PortalId)) ORDER BY DMX_Entries.Description System.Data.SqlC

    There is already an object named 'DMX_GetCollectionContents' in the database. at

    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnect

    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean break

    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateOb

    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, S

    dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at

    System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean

    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String

    sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at

    DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at

    DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CR

    dbo.DMX_GetCollectionContents @ParentId Int AS SELECT DMX_Entries.*, LTrim(RTrim(User

    '+Users.LastName)) AS FullName FROM DMX_Entries INNER JOIN Users ON DMX_Entries.Use

    WHERE (((DMX_Entries.CollectionId)=@ParentId) And ((DMX_Entries.EntryId)=(DMX_Entrie

    System.Data.SqlClient.SqlException: There is already an object named 'DMX_GetLogForEntry

    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnect

    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean break

    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateOb

    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, S

    dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at

    System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean

    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String

    sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at

    DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at

    DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CR

    dbo.DMX_GetLogForEntry @LastVersionId Int AS SELECT DMX_Log.*, LTrim(RTrim(Users.Firs

    '+Users.LastName)) AS FullName, DMX_Entries.Version FROM DMX_Entries INNER JOIN (DM

    Users ON DMX_Log.UserId = Users.UserID) ON DMX_Entries.EntryId = DMX_Log.EntId WHE

    (((DMX_Entries.LastVersionId)=@LastVersionId)) ORDER BY DMX_Log.Datime System.Data.

    There is already an object named 'DMX_GetVersionList' in the database. at

    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnect

    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean break

    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateOb

    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, S

    dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at

    System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean

    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String

    sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at

    DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at

    DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CR

    dbo.DMX_GetVersionList @LastVersionId Int, @PortalId Int AS SELECT DMX_Entries.*, LTrim

    (Users.FirstName+' '+Users.LastName)) AS FullName FROM DMX_Entries INNER JOIN Users

    DMX_Entries.UserId=Users.UserID WHERE (((DMX_Entries.LastVersionId)=@LastVersionId)

    ((DMX_Entries.PortalId)=@PortalId)) ORDER BY DMX_Entries.DateSubmitted

    Were we supposed to remove the demo version prior to installing the professional version?  If so, is there an easy way to uninstall the demo version?

    Could this error have caused the full-text search to not work?

    Please help!!!

    Thanks!

    Peter Donker
    Veteran Member
    Veteran Member
    Posts:4536


    --
    12/05/2006 10:50 AM
    The error log doesn't look good. Something has gone terribly wrong during installation. Did you still have a DMX Lite before? Or did you change the module name? It seems that it tried to run all the SQL scripts from the start again.
    Peter
    You are not authorized to post a reply.