I attempted to install on a virgin copy of DNN 7.4.0. The install failed with an SQL error...
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'searchitem'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:eebdab43-c867-4db1-b0ff-4ea17d7d296d create view dbo.[Publish_vwArticleSearchIndexingUpdated] as select name, va.itemId, ArticleText, DisplayTabID, IsCurrentVersion, Disabled, va.Description, MetaKeywords, MetaDescription, MetaTitle, AuthorUserId, LastUpdated, si.ModuleDefId, va.PortalId from publish_vwArticles va join ( select PubDate, Cast(SUBSTRING(guid, 8,8000) as Int) as 'ItemId', dm.ModuleDefId from searchitem dsi join modules dm on (dsi.ModuleId = dm.ModuleId) where guid like 'ItemId=%' ) si on (si.ItemId = va.ItemId) where IsCurrentVersion = 1 and va.LastUpdated > si.PubDate
I attempted to install on a virgin copy of DNN 7.4.0. The install failed with an SQL error...
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'searchitem'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:eebdab43-c867-4db1-b0ff-4ea17d7d296d create view dbo.[Publish_vwArticleSearchIndexingUpdated] as select name, va.itemId, ArticleText, DisplayTabID, IsCurrentVersion, Disabled, va.Description, MetaKeywords, MetaDescription, MetaTitle, AuthorUserId, LastUpdated, si.ModuleDefId, va.PortalId from publish_vwArticles va join ( select PubDate, Cast(SUBSTRING(guid, 8,8000) as Int) as 'ItemId', dm.ModuleDefId from searchitem dsi join modules dm on (dsi.ModuleId = dm.ModuleId) where guid like 'ItemId=%' ) si on (si.ItemId = va.ItemId) where IsCurrentVersion = 1 and va.LastUpdated > si.PubDate