I receive the following while installing the DMX 05.02.00 update on DNN version 4.9  It does say the installation was successful. (End Job   Installation successful)

StartJob   Start Sql execution: 05.02.00.SqlDataProvider file

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near '%'. 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) CREATE PROCEDURE dbo.DMX_LimitSearch @PortalId Int, @SearchId nvarchar(50), @CollectionId Int, @OnlyLastVersion BIT, @HideDeleted BIT, @OnlyApproved BIT AS BEGIN IF @CollectionId > -1 BEGIN DECLARE @entrypath VARCHAR(4000) SET @entrypath = (SELECT [Path] FROM dbo.DMX_Entries WHERE EntryId = @CollectionId); DELETE FROM dbo.DMX_SearchResults FROM dbo.DMX_SearchResults sr INNER JOIN dbo.DMX_Entries e ON sr.EntryId=e.EntryId WHERE NOT e.[Path] LIKE @entrypath'%'; END IF @OnlyLastVersion = 1 BEGIN DELETE FROM dbo.DMX_SearchResults FROM dbo.DMX_SearchResults sr INNER JOIN dbo.DMX_Entries e ON sr.EntryId=e.EntryId WHERE NOT e.LastVersionId = e.EntryId; END IF @HideDeleted = 1 BEGIN DELETE FROM dbo.DMX_SearchResults FROM dbo.DMX_SearchResults sr INNER JOIN dbo.DMX_Entries e ON sr.EntryId=e.EntryId WHERE e.Deleted = 1; END IF @OnlyApproved = 1 BEGIN DELETE FROM dbo.DMX_SearchResults FROM dbo.DMX_SearchResults sr INNER JOIN dbo.DMX_Entries e ON sr.EntryId=e.EntryId WHERE e.IsApproved = 0; END END System.Data.SqlClient.SqlException: Incorrect syntax near '%'. Incorrect syntax near '%'. 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) CREATE PROCEDURE dbo.DMX_ResetFolderSizes @PortalId Int, @EntryId Int = -1 AS BEGIN DISABLE TRIGGER dbo.DMX_EntryUpdatePath ON dbo.DMX_Entries; IF @EntryId > -1 BEGIN DECLARE @entrypath VARCHAR(4000) SET @entrypath = (SELECT [Path] FROM dbo.DMX_Entries WHERE EntryId = @EntryId); UPDATE dbo.DMX_Entries SET FileSize=0 WHERE PortalId=@PortalId AND @entrypath LIKE [Path]'%' AND EntryType LIKE 'Collection%'; END UPDATE dbo.DMX_Entries SET FileSize= (SELECT ISNULL(SUM(e1.FileSize), 0) FROM dbo.DMX_Entries e1 WHERE e1.EntryType LIKE 'File%' AND e1.[Path] LIKE e.Path'%' AND e1.PortalId=e.PortalId AND e1.LastVersionId=e1.EntryId) FROM dbo.DMX_Entries e WHERE e.EntryType LIKE 'Collection%' AND e.FileSize=0 AND (e.PortalId=@PortalId OR @PortalId=-1); ENABLE TRIGGER dbo.DMX_EntryUpdatePath ON dbo.DMX_Entries; END System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.DMX_ResetFolderSizes'. 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) EXEC dbo.DMX_ResetFolderSizes -1, -1; System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'Convert'. Incorrect syntax near ' l.*, u.DisplayName'. Incorrect syntax near ' FROM dbo.Users u INNER JOIN dbo.DMX_Log l ON u.UserID = l.UserId'. Incorrect syntax near ' WHERE l.EntId = '. 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) CREATE PROCEDURE dbo.DMX_GetLogsByEntry @EntId INT, @MaxRecords INT AS IF @MaxRecords > 0 BEGIN DECLARE @SQL varchar(max); SET @SQL = 'SELECT TOP ' Convert(varchar, @MaxRecords); SET @SQL = @SQL ' l.*, u.DisplayName'; SET @SQL = @SQL ' FROM dbo.Users u INNER JOIN dbo.DMX_Log l ON u.UserID = l.UserId'; SET @SQL = @SQL ' WHERE l.EntId = ' Convert(varchar, @EntId) ' ORDER BY l.Datime DESC'; EXEC(@SQL); END ELSE SELECT l.*, u.DisplayName FROM dbo.Users u INNER JOIN dbo.DMX_Log l ON u.UserID = l.UserId WHERE l.EntId = @EntId ORDER BY l.Datime DESC; System.Data.SqlClient.SqlException: Incorrect syntax near '?'. 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) -- change to attribute keys and naming UPDATE dbo.DMX_Attributes SET [Key]='att'?(AttributeId AS NVARCHAR(10)) WHERE ISNULL([Key], '')='' System.Data.SqlClient.SqlException: Incorrect syntax near '?'. 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) CREATE PROCEDURE dbo.DMX_AddAttribute @Addon NVarChar (50), @CollectionId Int, @ControlToLoad NVarChar (255), @IsPrivate Bit, @Key NVarChar (50), @PortalId Int, @Required Bit, @ResourceFile NVarChar (255), @ShowInUI Bit, @Values NVarChar (255), @ValueType NVarChar (30), @ViewOrder Int AS INSERT INTO dbo.DMX_Attributes ( [Addon], [CollectionId], [ControlToLoad], [IsPrivate], [Key], [PortalId], [Required], [ResourceFile], [ShowInUI], [Values], [ValueType], [ViewOrder] ) VALUES ( @Addon, @CollectionId, @ControlToLoad, @IsPrivate, @Key, @PortalId, @Required, @ResourceFile, @ShowInUI, @Values, @ValueType, @ViewOrder ); UPDATE dbo.DMX_Attributes SET [Key]='att'?(AttributeId AS NVARCHAR(10)) WHERE ISNULL([Key], '')=''; select SCOPE_IDENTITY() System.Data.SqlClient.SqlException: Incorrect syntax near '*'. 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) CREATE PROCEDURE dbo.DMX_GetPortal @PortalId INT, @Locale NVARCHAR(6) AS DECLARE @DNNVersion INT SET @DNNVersion = (SELECT MAX(v) FROM (SELECT Major * 10000 Minor * 100 Build AS v FROM dbo.Version WHERE ISNULL([Name], 'DNNCORP.CE') LIKE 'DNNCORP%') AS x) IF @DNNVersion > 50200 BEGIN IF EXISTS(SELECT * FROM dbo.PortalLocalization WHERE PortalId=@PortalId AND CultureCode=@Locale) SELECT * FROM dbo.Portals p INNER JOIN dbo.PortalLocalization pl ON p.PortalId=pl.PortalId WHERE p.PortalId=@PortalId AND pl.CultureCode=@Locale ELSE SELECT * FROM dbo.Portals p INNER JOIN dbo.PortalLocalization pl ON p.PortalId=pl.PortalId WHERE p.PortalId=@PortalId AND pl.CultureCode=p.DefaultLanguage END ELSE BEGIN SELECT * FROM dbo.Portals WHERE PortalId=@PortalId END

Ok, now after installing DMX 05.02.01 update I receive the following error in the detail section of the document repository.

The stored procedure 'dbo.DMX_GetLogsByEntry' doesn't exist.

at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Bring2mind.DNN.Modules.DMX.Data.SqlDataProvider.GetLogsByEntry(Int32 EntryId, Int32 MaxRecords) at Bring2mind.DNN.Modules.DMX.Controls.EntryLog.ᜀ(Object A_0, EventArgs A_1) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at ComponentArt.Web.UI.PageViewCollection.Add(Control child) at Bring2mind.DNN.Modules.DMX.ViewCollection.ᜁ(String A_0) at Bring2mind.DNN.Modules.DMX.ViewCollection.DetailsCallBack_Callback(Object sender, CallBackEventArgs e)

Hi Joy,

Please the release notes for 05.02.00:
http://www.bring2mind.net...w/topic/Default.aspx

Run the SQL even now you've installed 05.02.01.

Peter

Hi Peter,

I get the following error running the SQL statement from the release notes.

System.Data.SqlClient.SqlException: Invalid column name 'Name'. 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) CREATE PROCEDURE dbo.DMX_GetPortal @PortalId INT, @Locale NVARCHAR(6) AS DECLARE @DNNVersion INT SET @DNNVersion = (SELECT MAX(v) FROM (SELECT Major * 10000 + Minor * 100 + Build AS v FROM dbo.Version WHERE ISNULL([Name], 'DNNCORP.CE') LIKE 'DNNCORP%') AS x) IF @DNNVersion > 50200 BEGIN IF EXISTS(SELECT * FROM dbo.PortalLocalization WHERE PortalId=@PortalId AND CultureCode=@Locale) SELECT * FROM dbo.Portals p INNER JOIN dbo.PortalLocalization pl ON p.PortalId=pl.PortalId WHERE p.PortalId=@PortalId AND pl.CultureCode=@Locale ELSE SELECT * FROM dbo.Portals p INNER JOIN dbo.PortalLocalization pl ON p.PortalId=pl.PortalId WHERE p.PortalId=@PortalId AND pl.CultureCode=p.DefaultLanguage END ELSE BEGIN SELECT * FROM dbo.Portals WHERE PortalId=@PortalId END

Thanks,

Joy

Hi Joy,
That part has also been repaired. It should be

CREATE PROCEDURE dbo.DMX_GetPortal @PortalId INT, @Locale NVARCHAR(6) AS DECLARE @DNNVersion INT SET @DNNVersion = (SELECT MAX(v) FROM (SELECT Major * 10000 + Minor * 100 + Build AS v FROM dbo.Version) AS x) IF @DNNVersion > 50200 BEGIN IF EXISTS(SELECT * FROM dbo.PortalLocalization WHERE PortalId=@PortalId AND CultureCode=@Locale) SELECT * FROM dbo.Portals p INNER JOIN dbo.PortalLocalization pl ON p.PortalId=pl.PortalId WHERE p.PortalId=@PortalId AND pl.CultureCode=@Locale ELSE SELECT * FROM dbo.Portals p INNER JOIN dbo.PortalLocalization pl ON p.PortalId=pl.PortalId WHERE p.PortalId=@PortalId AND pl.CultureCode=p.DefaultLanguage END ELSE BEGIN SELECT * FROM dbo.Portals WHERE PortalId=@PortalId END

Peter

That worked.

Thanks Peter.

Joy