SQL error installing 07 beta

Jul 21, 2009 at 10:19 PM

Hi,

 

I tried to upgrade the store from 06 to 07 beta2, but got the error:

StartJob Start Sql execution: 01.01.07.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column or parameter #4: Cannot find data type xml. 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.syscolumns where id=object_id('NB_Store_ModelLang') and name='XMLData') alter table dbo.NB_Store_ModelLang add [XMLData] xml null System.Data.SqlClient.SqlException: Column or parameter #7: Cannot find data type xml. 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.syscolumns where id=object_id('NB_Store_ProductLang') and name='XMLData') alter table dbo.NB_Store_ProductLang add [XMLData] xml null System.Data.SqlClient.SqlException: Invalid column name 'XMLData'. 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.[NEvoweb_NB_Store_Model_Get] @ModelID int, @Lang nchar(5) AS begin select M.ModelID, M.ProductID, M.ListOrder, M.UnitCost, M.Barcode, M.ModelRef, M.Deleted, ML.Lang, ML.ModelName, QtyRemaining, QtyTrans, QtyTransDate, M.QtyStockSet, M.DealerCost, M.PurchaseCost, ML.[XMLData] from dbo.[NB_Store_Model] as M left outer join dbo.[NB_Store_ModelLang] as ML on ML.ModelID = M.ModelID and ML.Lang = @Lang where M.ModelID = @ModelID end System.Data.SqlClient.SqlException: Invalid column name 'XMLData'. 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.[NEvoweb_NB_Store_Model_GetByRef] @ProductID int, @ModelRef nvarchar(20), @Lang nchar(5) AS begin select top 1 M.ModelID, M.ProductID, M.ListOrder, M.UnitCost, M.Barcode, M.ModelRef, M.Deleted, ML.Lang, ML.ModelName, QtyRemaining, QtyTrans, QtyTransDate, M.QtyStockSet, M.DealerCost, M.PurchaseCost, ML.[XMLData] from dbo.[NB_Store_Model] as M left outer join dbo.[NB_Store_ModelLang] as ML on ML.ModelID = M.ModelID and ML.Lang = @Lang where M.ModelRef = @ModelRef and M.ProductID = @ProductID end System.Data.SqlClient.SqlException: Invalid column name 'XMLData'. 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.[NEvoweb_NB_Store_Model_GetInStockList] @ProductID int, @Lang nchar(5) AS begin select M.ModelID, M.ProductID, M.ListOrder, M.UnitCost, M.Barcode, M.ModelRef, M.Deleted, ML.Lang, ML.ModelName, QtyRemaining, QtyTrans, QtyTransDate, M.QtyStockSet, M.DealerCost, M.PurchaseCost, ML.[XMLData] from dbo.[NB_Store_Model] as M left outer join dbo.[NB_Store_ModelLang] as ML on ML.ModelID = M.ModelID and ML.Lang = @Lang where M.ProductID = @ProductID and (QtyRemaining > 0 or QtyRemaining < 0) order by M.ListOrder end System.Data.SqlClient.SqlException: Invalid column name 'XMLData'. 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.[NEvoweb_NB_Store_Model_GetList] @PortalID int, @ProductID int, @Lang nchar(5) AS begin select M.ModelID, M.ProductID, M.ListOrder, M.UnitCost, M.Barcode, M.ModelRef, M.Deleted, ML.Lang, ML.ModelName, QtyRemaining, QtyTrans, QtyTransDate, PL.ProductName, P.PortalID, isnull(SR.ProductWeight,0) as Weight, isnull(SR.ProductHeight,0) as Height, isnull(SR.ProductLength,0) as Length, isnull(SR.ProductWidth,0) as Width, M.QtyStockSet, M.DealerCost, M.PurchaseCost, ML.[XMLData] from dbo.[NB_Store_Model] as M inner join dbo.[NB_Store_Products] as P on P.ProductID = M.ProductID left outer join dbo.[NB_Store_ModelLang] as ML on ML.ModelID = M.ModelID and ML.Lang = @Lang left outer join dbo.[NB_Store_ProductLang] as PL on PL.ProductID = M.ProductID and PL.Lang = @Lang left outer join dbo.[NB_Store_ShippingRates] as SR on SR.ObjectID = M.ModelID and ShipType='PRD' and SR.[Disable]=0 where M.ProductID = @ProductID and (P.PortalID = @PortalID or @PortalID = -1) order by M.ListOrder end System.Data.SqlClient.SqlException: Invalid column name 'XMLData'. 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.[NEvoweb_NB_Store_Model_GetStockList] @PortalID int, @Filter nvarchar(50), @Lang nchar(5), @CategoryID int AS begin if @CategoryID = -1 begin select M.ModelID, M.ProductID, P.TaxCategoryID, M.ListOrder, M.UnitCost, M.Barcode, M.ModelRef, M.Deleted, ML.Lang, ML.ModelName, QtyRemaining, QtyTrans, QtyTransDate, PL.ProductName, P.PortalID, M.QtyStockSet, M.DealerCost, M.PurchaseCost, ML.[XMLData] from dbo.[NB_Store_Model] as M inner join dbo.[NB_Store_Products] as P on P.ProductID = M.ProductID left outer join dbo.[NB_Store_ProductLang] as PL on PL.ProductID = M.ProductID and PL.Lang = @Lang left outer join dbo.[NB_Store_ModelLang] as ML on ML.ModelID = M.ModelID and ML.Lang = @Lang where (ML.Modelname like '%' + @Filter + '%' or M.Modelref like '%' + @Filter + '%' or PL.ProductName like '%' + @Filter + '%' or M.Barcode like '%' + @Filter + '%') and P.PortalID = @PortalID and isnull(M.Deleted,0) = 0 and isnull(P.Archived,0) = 0 order by PL.ProductName,M.ListOrder,ML.ModelName,M.ModelRef end else begin select M.ModelID, M.ProductID, P.TaxCategoryID, M.ListOrder, M.UnitCost, M.Barcode, M.ModelRef, M.Deleted, ML.Lang, ML.ModelName, QtyRemaining, QtyTrans, QtyTransDate, PL.ProductName, P.PortalID, M.QtyStockSet, M.DealerCost, M.PurchaseCost from dbo.[NB_Store_Model] as M left outer join dbo.[NB_Store_ModelLang] as ML on ML.ModelID = M.ModelID and ML.Lang = @Lang inner join dbo.NB_Store_Products as P on P.ProductID = M.ProductID inner join dbo.NB_Store_ProductCategory as PC on PC.ProductID = P.ProductID left outer join dbo.[NB_Store_ProductLang] as PL on PL.ProductID = M.ProductID and PL.Lang = @Lang where PC.CategoryID = @CategoryID and (ML.Modelname like '%' + @Filter + '%' or M.Modelref like '%' + @Filter + '%' or PL.ProductName like '%' + @Filter + '%' or M.Barcode like '%' + @Filter + '%') and P.PortalID = @PortalID and isnull(M.Deleted,0) = 0 and isnull(P.Archived,0) = 0 order by PL.ProductName,M.ListOrder,ML.ModelName,M.ModelRef end end System.Data.SqlClient.SqlException: Column or parameter #16: Cannot find data type xml. Parameter '@XMLData' has an invalid data type. 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.[NEvoweb_NB_Store_Model_Update] ( @ModelID int, @ProductID int, @ListOrder int, @UnitCost money, @Barcode nvarchar(20), @ModelRef nvarchar(20), @Lang nchar(5), @ModelName nvarchar(50), @QtyRemaining int, @QtyTrans int, @QtyTransDate datetime, @Deleted bit, @QtyStockSet int, @DealerCost money, @PurchaseCost money, @XMLData xml ) AS BEGIN if not exists (select ModelID from dbo.[NB_Store_Model] where ModelID = @ModelID ) begin insert into dbo.[NB_Store_Model] ( ProductID, ListOrder, UnitCost, Barcode, ModelRef, QtyRemaining, QtyTrans, QtyTransDate, Deleted, QtyStockSet, DealerCost, PurchaseCost ) values ( @ProductID, @ListOrder, @UnitCost, @Barcode, @ModelRef, @QtyRemaining, @QtyTrans, @QtyTransDate, @Deleted, @QtyStockSet, @DealerCost, @PurchaseCost ) set @ModelID = @@Identity exec dbo.NEvoweb_NB_Store_ModelLang_Update @ModelID, @Lang, @ModelName, @XMLData end else begin Update dbo.[NB_Store_Model] set ProductID = @ProductID, ListOrder = @ListOrder, UnitCost = @UnitCost, Barcode = @Barcode, ModelRef = @ModelRef, QtyRemaining = @QtyRemaining, QtyTrans = @QtyTrans, QtyTransDate = @QtyTransDate, Deleted = @Deleted, QtyStockSet = @QtyStockSet, DealerCost = @DealerCost, PurchaseCost = @PurchaseCost where ModelID = @ModelID exec dbo.NEvoweb_NB_Store_ModelLang_Update @ModelID, @Lang, @ModelName, @XMLData end select @ModelID END System.Data.SqlClient.SqlException: Column or parameter #4: Cannot find data type xml. Parameter '@XMLData' has an invalid data type. 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.[NEvoweb_NB_Store_ModelLang_Update] ( @ModelID int, @Lang nchar(5), @ModelName nvarchar(50), @XMLData xml ) AS BEGIN if not exists (select ModelID from dbo.[NB_Store_ModelLang] where ModelID = @ModelID and Lang = @Lang) begin insert into dbo.[NB_Store_ModelLang] ( ModelID, Lang, ModelName, [XMLData] ) values ( @ModelID, @Lang, @ModelName, @XMLData ) end else begin Update dbo.[NB_Store_ModelLang] set ModelName = @ModelName, [XMLData] = @XMLData where ModelID = @ModelID and Lang = @Lang end END System.Data.SqlClient.SqlException: Column or parameter #7: Cannot find data type xml. Parameter '@XMLdata' has an invalid data type. 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.[NEvoweb_NB_Store_ProductLang_Update] ( @ProductID int, @Lang char(5), @Summary nvarchar(1000), @Description ntext, @Manufacturer nvarchar(50), @ProductName nvarchar(50), @XMLdata xml ) AS BEGIN if not exists (select ProductID from dbo.[NB_Store_ProductLang] where ProductID = @ProductID and Lang = @Lang) begin insert into dbo.[NB_Store_ProductLang] ( ProductID, Lang, Summary, Description, Manufacturer, ProductName, [XMLdata] ) values ( @ProductID, @Lang, @Summary, @Description, @Manufacturer, @ProductName, @XMLdata ) end else begin Update dbo.[NB_Store_ProductLang] set Summary = @Summary, Description = @Description, Manufacturer = @Manufacturer, ProductName = @ProductName, [XMLdata] = @XMLdata where ProductID = @ProductID and Lang = @Lang end END System.Data.SqlClient.SqlException: Invalid column name 'XMLData'. 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.[NEvoweb_NB_Store_Products_Get] @ProductID int, @Lang char(5) AS begin select P.ProductID, PortalID, P.TaxCategoryID, Featured, Archived, CreatedByUser, CreatedDate, IsDeleted, ProductRef, PL.Lang, Summary, Description, Manufacturer, dbo.NEvoWeb_NB_Store_FGetProductBasePrice(P.ProductID) as FromPrice, isnull((select sum(QtyRemaining) from dbo.NB_Store_Model where productid = P.ProductID and qtyremaining != 0),0) as QtyRemaining, isnull((select sum(QtyStockSet) from dbo.NB_Store_Model where productid = P.ProductID and qtyremaining != 0),0) as QtyStockSet, (select top 1 ImageID from dbo.NB_Store_ProductImage AS I where productid = P.ProductID order by listorder) as ImageID, (select top 1 ImageURL from dbo.NB_Store_ProductImage AS I where productid = P.ProductID order by listorder) as ImageURL, (select top 1 ImageDesc from dbo.NB_Store_ProductImage AS I inner join dbo.NB_Store_ProductImageLang as IL on IL.ImageID = I.ImageID and IL.Lang = PL.Lang where productid = P.ProductID order by listorder) as ImageDesc, PL.ProductName, PL.[XMLData] from dbo.[NB_Store_Products] as P inner join dbo.NB_Store_ProductLang as PL on P.ProductID = PL.ProductID and PL.Lang = @Lang where P.ProductID = @ProductID end System.Data.SqlClient.SqlException: Invalid column name 'XMLData'. 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.[NEvoweb_NB_Store_Products_GetByRef] @PortalID int, @ProductRef nvarchar(20), @Lang char(5) AS begin select top 1 P.ProductID, PortalID, P.TaxCategoryID, Featured, Archived, CreatedByUser, CreatedDate, IsDeleted, ProductRef, Lang, Summary, Description, Manufacturer, dbo.NEvoWeb_NB_Store_FGetProductBasePrice(P.ProductID) as FromPrice, isnull((select sum(QtyRemaining) from dbo.NB_Store_Model where productid = P.ProductID and qtyremaining != 0),0) as QtyRemaining, isnull((select sum(QtyStockSet) from dbo.NB_Store_Model where productid = P.ProductID and qtyremaining != 0),0) as QtyStockSet, (select top 1 ImageID from dbo.NB_Store_ProductImage AS I where productid = P.ProductID) as ImageID, (select top 1 ImageURL from dbo.NB_Store_ProductImage AS I where productid = P.ProductID) as ImageURL, (select top 1 ImageDesc from dbo.NB_Store_ProductImage AS I inner join dbo.NB_Store_ProductImageLang as IL on IL.ImageID = I.ImageID and IL.Lang = PL.Lang where productid = P.ProductID) as ImageDesc, PL.ProductName, PL.[XMLData] from dbo.[NB_Store_Products] as P inner join dbo.NB_Store_ProductLang as PL on P.ProductID = PL.ProductID and PL.Lang = @Lang where P.ProductRef = @ProductRef and P.PortalID = @PortalID end System.Data.SqlClient.SqlException: Column or parameter #15: Cannot find data type xml. Parameter '@XMLdata' has an invalid data type. 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.[NEvoweb_NB_Store_Products_Update] ( @ProductID int, @PortalID int, @TaxCategoryID int, @Featured bit, @Archived bit, @CreatedByUser nvarchar(100), @CreatedDate datetime, @IsDeleted bit, @ProductRef nvarchar(20), @Lang char(5), @Summary nvarchar(1000), @Description ntext, @Manufacturer nvarchar(50), @ProductName nvarchar(50), @XMLdata xml ) AS BEGIN if not exists (select ProductID from dbo.[NB_Store_Products] where ProductID = @ProductID ) begin insert into dbo.[NB_Store_Products] ( PortalID, TaxCategoryID, Featured, Archived, CreatedByUser, CreatedDate, IsDeleted, ProductRef ) values ( @PortalID, @TaxCategoryID, @Featured, @Archived, @CreatedByUser, @CreatedDate, @IsDeleted, @ProductRef ) set @ProductID = @@Identity exec dbo.NEvoweb_NB_Store_ProductLang_Update @ProductID, @Lang, @Summary, @Description, @Manufacturer, @ProductName, @XMLdata end else begin Update dbo.[NB_Store_Products] set PortalID = @PortalID, TaxCategoryID = @TaxCategoryID, Featured = @Featured, Archived = @Archived, CreatedByUser = @CreatedByUser, CreatedDate = @CreatedDate, IsDeleted = @IsDeleted, ProductRef = @ProductRef where ProductID = @ProductID exec dbo.NEvoweb_NB_Store_ProductLang_Update @ProductID, @Lang, @Summary, @Description, @Manufacturer, @ProductName, @XMLdata end exec dbo.NEvoweb_NB_Store_Products_Get @ProductID, @Lang END
EndJob End Sql execution: 01.01.07.SqlDataProvider file

 

And after that - when t.ex clicking shop I get the error:

Error: Products is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'XMLData'. ---> System.Data.SqlClient.SqlException: Invalid column name 'XMLData'. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at NEvoWeb.Modules.NB_Store.SqlDataProvider.GetNB_Store_Productss(Int32 PortalID, Int32 CategoryID, String Lang, String SearchText, Boolean GetArchived, Boolean FeaturedOnly, String OrderBY, Boolean OrderDESC, Int32 ReturnLimit) at NEvoWeb.Modules.NB_Store.ProductController.GetProductList(Int32 PortalID, Int32 CategoryID, String Lang, String SearchText, Boolean GetArchived, Boolean FeaturedOnly, String OrderBY, Boolean OrderDESC, Int32 ReturnLimit) at NEvoWeb.Modules.NB_Store.ProductList.populateList(Int32 CatID) at NEvoWeb.Modules.NB_Store.ProductList.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

May someone help me fix this issue?

 

 

Coordinator
Jul 22, 2009 at 8:02 AM

Hi,

The problem is that you seem to be running SQL2000.  v1.1.7 uses an xml datatype for the custom fields, which is not compatible with SQL2000.  The solution is to upgrade to SQL2005.

If you can't upgrade to SQL2005, you'll have to stay with v1.1.6

Regards,

Dave.

Jul 22, 2009 at 2:19 PM

As Dave earlier said there are customized productlist fields those need xmldata form,
but if y don't need those productlist fields y must change those xml based fields referrals to ntext using for example NotePad replacing funtion ('xml', 'ntext')
in 01.01.07.SqlDataProvider file and using DNN Host SQL option to manually run that 01.01.07.SqlDataProvider file.
Then y have all others properties left and y do not need to install sql server 2005 at this time.
i want also to keep alive  sql server 2000, but perharps in future i had to transfer my database to sql server 2005 .

Best Regards,

Markku