I tried to update a client's DMX 6.0.4 installation to 6.1.3 and got this error:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): No item by the name of 'DMXDAV_Numbers' could be found in the current database 'Spectracom_DNN', given that @itemtype was input as '(null)'. 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() 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) /****** Remove DMXDAV_ qualifier in favor of DMX_ ******/ EXEC sp_rename 'DMXDAV_Numbers', 'DMX_Numbers' System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_fn_GetExtension' 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() 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 FUNCTION dbo.DMX_fn_GetExtension (@Filename NVARCHAR(200)) RETURNS NVARCHAR(10) AS BEGIN IF @Filename IS NOT NULL IF @Filename<>'' DECLARE @POS INT SELECT @POS = LEN(@Filename)-1 DECLARE @CHR NVARCHAR(1) SELECT @CHR = SUBSTRING(@Filename,@POS,1) WHILE @CHR<>'.' AND @POS>1 BEGIN SELECT @POS = @POS-1 SELECT @CHR = SUBSTRING(@Filename,@POS,1) END IF @POS > 1 RETURN SUBSTRING(@Filename,@POS,LEN(@Filename)-@POS+1) RETURN '' END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_fn_URLEncode' 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() 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 FUNCTION dbo.DMX_fn_URLEncode(@String NVARCHAR(4000)) RETURNS VARCHAR(8000) AS BEGIN DECLARE @URLEncodedString VARCHAR(8000) SELECT @URLEncodedString='' SELECT @URLEncodedString=@URLEncodedString + CASE WHEN theChar LIKE '[A-Za-z0-9()''*-._!/]' THEN theChar ELSE '%' + substring ('0123456789ABCDEF',(ASCII(theChar) / 16)+1,1) + SUBSTRING('0123456789ABCDEF',(ASCII(theChar) % 16)+1,1) END FROM (SELECT [theChar]=SUBSTRING(@string,number,1) FROM dbo.DMX_Numbers WHERE Number <= LEN(@String)) CHARACTERARRAY RETURN @URLEncodedString END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_fn_GetPath' 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() 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 FUNCTION dbo.DMX_fn_GetPath (@EntryId INT, @PortalId INT, @Locale NVARCHAR(10)) RETURNS NVARCHAR(4000) AS BEGIN DECLARE @res NVARCHAR(4000) IF EXISTS (SELECT EntryId FROM dbo.DMX_Entries WHERE EntryId=@EntryId AND PortalId=@PortalId) BEGIN DECLARE @collection INT, @name NVARCHAR(2000), @orig NVARCHAR(300); WITH x AS ( SELECT e.CollectionId, e.OriginalFileName, ISNULL(el.Title, e.Title) Title FROM dbo.DMX_Entries e LEFT JOIN dbo.DMX_EntriesML el ON e.EntryId=el.EntryId AND el.Locale=@Locale WHERE e.EntryId=@EntryId AND e.PortalId=@PortalId) SELECT @collection = CollectionId, @name = Title, @orig = OriginalFilename FROM x; SELECT @res = dbo.DMX_fn_GetPath(@collection, @PortalId, @Locale)+'/'+@name+dbo.DMX_fn_GetExtension(@orig) END ELSE SELECT @res = '' RETURN @res END

What might have gone wrong? The client has a lot of files in DMX.

I just realized that DMX is now broken on the site, returning this error:


Error loading bring2mind/dmx/views/templateview.ascx DotNetNuke.Services.Exceptions.ModuleLoadException: The file '/DesktopModules/bring2mind/dmx/views/templateview.ascx' does not exist. ---> System.Web.HttpException: The file '/DesktopModules/bring2mind/dmx/views/templateview.ascx' does not exist. at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean ensureIsUpToDate) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at Bring2mind.DNN.Modules.DMX.Dispatch.ᜀ(Object A_0, EventArgs A_1) --- End of inner exception stack trace ---

I'm going to have to roll back the site to the backup I made this morning.

Hi Noah,

The error begins with this: "No item by the name of 'DMXDAV_Numbers' could be found in the current database 'Spectracom_DNN". The upgrade was expecting this to be there and it should have been if version 6.0.4 was properly installed on this. So you'll need to reexamine this closer. Is the database connection string correct? Is that table there, or not?

Peter