Upgrading from BV5 SP1 to SP2 breaks most of site - missing database items - General Support

Welcome Guest! To enable all features please Login or Register.

Notification

Error

BV Commerce Forum » BV Commerce Support » General Support » Upgrading from BV5 SP1 to SP2 breaks most of site - missing database items

Upgrading from BV5 SP1 to SP2 breaks most of site - missing database items

Options

Previous Topic Next Topic

Outdoor Ed		#1 Posted : Monday, April 16, 2007 1:59:08 PM(UTC)
Rank: Member Joined: 3/4/2006(UTC) Posts: 121		Also filed a Help Ticket, but for those eager to upgrade you might wait a little bit. I seem to have been too eager. From the error messages it appears that SP2 requires some new database fields. However. there are no instructions in the SP2 installer about how to upgrade an existing database and no SQL file except the original ones to create and populate the database. Tech Support - I mentioned this before when SP1 came out, can you all just write a simple Readme.txt file with some instructions for upgrading? Rick ERROR 1 - opening a product page Column 'SmallImageAlternateText' does not belong to table Table. ERROR 2 - opening sitemap page Column 'metadescription' does not belong to table Table. ERROR 3 - opening MyAccount_Orders.aspx or after logging in to BVAdmin/Default.aspx Column 'ThirdPartyOrderId' does not belong to table Table


User Profile View All Posts by User View Thanks

jetheredge		#2 Posted : Monday, April 16, 2007 3:14:31 PM(UTC)
Rank: Member Joined: 3/1/2006(UTC) Posts: 1,142		The patches automatically apply the database updates. How did you apply your upgrade?
		Justin Etheredge Senior Software Engineer BVSoftware


User Profile View All Posts by User View Thanks

JoeB		#3 Posted : Monday, April 23, 2007 3:19:23 PM(UTC)
Rank: Member Joined: 2/3/2004(UTC) Posts: 111		Outdoor Ed, Did you ever figure this out? I'm trying to run the scripts on a database and I'm getting script errors. The odd thing is that I can update an older backed up copy of this same database. thanks in advance! Joe I've noticed I can run the datascript.sql without a problem. I receive errors when I run the schemascript.sql. Here is my log: Dropping constraints from [dbo].[bvc_WishList] Altering [dbo].[bvc_EventLog_SQL_i] Creating [dbo].[bvc_RMAItem_ByLineItemBvin_s] Altering [dbo].[bvc_Product] Creating index [IX_Product_ManufacturerId] on [dbo].[bvc_Product] Creating index [IX_Product_ProductName] on [dbo].[bvc_Product] Creating index [IX_Product_Status] on [dbo].[bvc_Product] Creating index [IX_Product_VendorId] on [dbo].[bvc_Product] Altering [dbo].[bvc_LineItemModifier] Altering [dbo].[bvc_LineItemModifier_ByLineItem_s] Altering [dbo].[bvc_Country] Altering [dbo].[bvc_Order] Altering [dbo].[bvc_ProductChoices] Altering [dbo].[bvc_ProductChoice_u ] Altering [dbo].[bvc_CustomPage] Altering [dbo].[bvc_UserQuestions] Altering [dbo].[bvc_UserQuestion_s] Altering [dbo].[bvc_Country_ByISOCode_s] Altering [dbo].[bvc_Order_ByCoupon_s] Altering [dbo].[bvc_Country_Active_s] Altering [dbo].[bvc_ProductInputs] Altering [dbo].[bvc_ProductInput_ByProduct_s] Altering [dbo].[bvc_Country_All_s] Altering [dbo].[bvc_ProductModifier] Altering [dbo].[bvc_ProductModifier_ByProduct_s] Altering [dbo].[bvc_ProductInventory_UpdateParent_u] Altering [dbo].[bvc_LineItem] Altering [dbo].[bvc_Product_ByFile_s] Altering [dbo].[bvc_ProductModifier_u ] Altering [dbo].[bvc_ProductInput_i ] Altering [dbo].[bvc_Product_ByCrossSellId_Admin_s] Altering [dbo].[bvc_Order_ByLineItemStatus_s] Altering [dbo].[bvc_Order_Range_s] Altering [dbo].[bvc_Product_Light_s] Altering [dbo].[bvc_WishList] Creating primary key [PK_bvc_WishList_1] on [dbo].[bvc_WishList] Msg 1505, Level 16, State 1, Line 1 CREATE UNIQUE INDEX terminated because a duplicate key was found for object name 'dbo.bvc_WishList' and index name 'PK_bvc_WishList_1'. The duplicate key value is (1196f91d-1af2-4ed3-8255-8ee9ace4adbe). Msg 1750, Level 16, State 0, Line 1 Could not create constraint. See previous errors. (1 row(s) affected) Altering [dbo].[bvc_WishList_d] Altering [dbo].[bvc_ShippingMethod_FindNotCountries_s] Msg 207, Level 16, State 1, Procedure bvc_ShippingMethod_FindNotCountries_s, Line 9 Invalid column name 'ISOAlpha3'. Msg 207, Level 16, State 1, Procedure bvc_ShippingMethod_FindNotCountries_s, Line 9 Invalid column name 'ISONumeric'. (1 row(s) affected) Altering [dbo].[bvc_Product_ByUpSellId_Admin_s] Msg 207, Level 16, State 1, Procedure bvc_Product_ByUpSellId_Admin_s, Line 67 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByUpSellId_Admin_s, Line 68 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByUpSellId_Admin_s, Line 70 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByUpSellId_Admin_s, Line 71 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_LineItemInput] Altering [dbo].[bvc_CustomPage_i] Msg 207, Level 16, State 1, Procedure bvc_CustomPage_i, Line 21 Invalid column name 'MetaDescription'. Msg 207, Level 16, State 1, Procedure bvc_CustomPage_i, Line 21 Invalid column name 'MetaKeywords'. (1 row(s) affected) Altering [dbo].[bvc_LineItemInput_i] Msg 207, Level 16, State 1, Procedure bvc_LineItemInput_i, Line 15 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_RMA] Altering [dbo].[bvc_OrderNote_ByOrderId_s] Altering [dbo].[bvc_LineItemInput_ByLineItem_s] Msg 207, Level 16, State 1, Procedure bvc_LineItemInput_ByLineItem_s, Line 16 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_Product_ByOrder_s] Msg 207, Level 16, State 1, Procedure bvc_Product_ByOrder_s, Line 57 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByOrder_s, Line 58 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByOrder_s, Line 60 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByOrder_s, Line 61 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_ProductInput_u ] Msg 207, Level 16, State 1, Procedure bvc_ProductInput_u , Line 0 Invalid column name 'InputDisplayName'. (1 row(s) affected) Altering [dbo].[bvc_ProductChoice_ByProduct_s] Msg 207, Level 16, State 1, Procedure bvc_ProductChoice_ByProduct_s, Line 26 Invalid column name 'ChoiceName'. (1 row(s) affected) Altering [dbo].[bvc_LineItem_u] Msg 207, Level 16, State 1, Procedure bvc_LineItem_u, Line 0 Invalid column name 'AdminPrice'. (1 row(s) affected) Altering [dbo].[bvc_LineItem_i] Msg 207, Level 16, State 1, Procedure bvc_LineItem_i, Line 54 Invalid column name 'AdminPrice'. (1 row(s) affected) Creating [dbo].[bvc_Order_ByThirdPartyOrderId_s] Msg 207, Level 16, State 1, Procedure bvc_Order_ByThirdPartyOrderId_s, Line 44 Invalid column name 'ThirdPartyOrderId'. Msg 207, Level 16, State 1, Procedure bvc_Order_ByThirdPartyOrderId_s, Line 40 Invalid column name 'ThirdPartyOrderId'. (1 row(s) affected) Altering [dbo].[bvc_Taxes_s] Altering [dbo].[bvc_LineItem_s] Msg 207, Level 16, State 1, Procedure bvc_LineItem_s, Line 28 Invalid column name 'AdminPrice'. (1 row(s) affected) Altering [dbo].[bvc_Product_ByChoiceId_s] Msg 207, Level 16, State 1, Procedure bvc_Product_ByChoiceId_s, Line 56 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByChoiceId_s, Line 57 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByChoiceId_s, Line 59 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByChoiceId_s, Line 60 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_LineItemInput_u] Msg 207, Level 16, State 1, Procedure bvc_LineItemInput_u, Line 0 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_CustomPage_All_s] Msg 207, Level 16, State 1, Procedure bvc_CustomPage_All_s, Line 8 Invalid column name 'MetaDescription'. Msg 207, Level 16, State 1, Procedure bvc_CustomPage_All_s, Line 8 Invalid column name 'MetaKeywords'. (1 row(s) affected) Altering [dbo].[bvc_Product_Children_s] Msg 207, Level 16, State 1, Procedure bvc_Product_Children_s, Line 58 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_Children_s, Line 59 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_Children_s, Line 61 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_Children_s, Line 62 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_ProductModifier_SharedByProduct_s ] Msg 207, Level 16, State 1, Procedure bvc_ProductModifier_SharedByProduct_s , Line 21 Invalid column name 'Name'. (1 row(s) affected) Altering [dbo].[bvc_ProductChoice_AllShared_s ] Msg 207, Level 16, State 1, Procedure bvc_ProductChoice_AllShared_s , Line 17 Invalid column name 'ChoiceName'. (1 row(s) affected) Altering [dbo].[bvc_AffiliateQuestions] Altering [dbo].[bvc_AffiliateQuestion_i] Altering [dbo].[bvc_CustomPage_ByShowInBottomMenu_s] Msg 207, Level 16, State 1, Procedure bvc_CustomPage_ByShowInBottomMenu_s, Line 10 Invalid column name 'MetaDescription'. Msg 207, Level 16, State 1, Procedure bvc_CustomPage_ByShowInBottomMenu_s, Line 10 Invalid column name 'MetaKeywords'. (1 row(s) affected) Altering [dbo].[bvc_Category_AllVisible_s] Altering [dbo].[bvc_CustomPage_s] Msg 207, Level 16, State 1, Procedure bvc_CustomPage_s, Line 12 Invalid column name 'MetaDescription'. Msg 207, Level 16, State 1, Procedure bvc_CustomPage_s, Line 12 Invalid column name 'MetaKeywords'. (1 row(s) affected) Altering [dbo].[bvc_ContactUsQuestions] Altering [dbo].[bvc_ContactUsQuestion_u] Altering [dbo].[bvc_ProductChoice_CountByProduct_s] Altering [dbo].[bvc_ShippingMethod_FindCountries_s] Msg 207, Level 16, State 1, Procedure bvc_ShippingMethod_FindCountries_s, Line 9 Invalid column name 'ISOAlpha3'. Msg 207, Level 16, State 1, Procedure bvc_ShippingMethod_FindCountries_s, Line 9 Invalid column name 'ISONumeric'. (1 row(s) affected) Altering [dbo].[bvc_UserQuestion_All_s] Msg 207, Level 16, State 1, Procedure bvc_UserQuestion_All_s, Line 12 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_UserQuestion_u] Msg 207, Level 16, State 1, Procedure bvc_UserQuestion_u, Line 0 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_Order_u] Msg 207, Level 16, State 1, Procedure bvc_Order_u, Line 0 Invalid column name 'ThirdPartyOrderId'. (1 row(s) affected) Altering [dbo].[bvc_ProductInventory_AllLowStock_s] Altering [dbo].[bvc_Product_i] Msg 207, Level 16, State 1, Procedure bvc_Product_i, Line 96 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_i, Line 97 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_i, Line 99 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_i, Line 100 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_Product_u] Msg 207, Level 16, State 1, Procedure bvc_Product_u, Line 0 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_u, Line 0 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_u, Line 0 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_u, Line 0 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_ProductChoice_i ] Msg 207, Level 16, State 1, Procedure bvc_ProductChoice_i , Line 22 Invalid column name 'ChoiceName'. (1 row(s) affected) Altering [dbo].[bvc_ContactUsQuestion_All_s] Msg 207, Level 16, State 1, Procedure bvc_ContactUsQuestion_All_s, Line 13 Invalid column name 'Order'. (1 row(s) affected) Creating [dbo].[bvc_WishList_u] Msg 207, Level 16, State 1, Procedure bvc_WishList_u, Line 0 Invalid column name 'Userid'. Msg 207, Level 16, State 1, Procedure bvc_WishList_u, Line 0 Invalid column name 'Quantity'. Msg 207, Level 16, State 1, Procedure bvc_WishList_u, Line 0 Invalid column name 'Modifiers'. Msg 207, Level 16, State 1, Procedure bvc_WishList_u, Line 0 Invalid column name 'Inputs'. (1 row(s) affected) Altering [dbo].[bvc_ProductModifier_CountByProduct_s] Altering [dbo].[bvc_AffiliateQuestion_All_s] Msg 207, Level 16, State 1, Procedure bvc_AffiliateQuestion_All_s, Line 12 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_ProductModifier_s ] Msg 207, Level 16, State 1, Procedure bvc_ProductModifier_s , Line 17 Invalid column name 'Name'. (1 row(s) affected) Altering [dbo].[bvc_ProductChoices_ForProduct_s] Msg 207, Level 16, State 1, Procedure bvc_ProductChoices_ForProduct_s, Line 20 Invalid column name 'ChoiceName'. (1 row(s) affected) Altering [dbo].[bvc_ProductInventory_ByProductId_s] Altering [dbo].[bvc_Country_s] Msg 207, Level 16, State 1, Procedure bvc_Country_s, Line 12 Invalid column name 'ISOAlpha3'. Msg 207, Level 16, State 1, Procedure bvc_Country_s, Line 12 Invalid column name 'ISONumeric'. (1 row(s) affected) Altering [dbo].[bvc_LineItemModifier_u] Msg 207, Level 16, State 1, Procedure bvc_LineItemModifier_u, Line 0 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_LineItem_ByOrderId_s] Msg 207, Level 16, State 1, Procedure bvc_LineItem_ByOrderId_s, Line 32 Invalid column name 'AdminPrice'. (1 row(s) affected) Altering [dbo].[bvc_ProductInventory_i] Altering [dbo].[bvc_AffiliateQuestion_s] Msg 207, Level 16, State 1, Procedure bvc_AffiliateQuestion_s, Line 15 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_ProductInventory_u] Altering [dbo].[bvc_ProductChoiceAndOptionPairs_ByProductCombinationBvin_s ] Msg 207, Level 16, State 1, Procedure bvc_ProductChoiceAndOptionPairs_ByProductCombinationBvin_s , Line 20 Invalid column name 'ChoiceName'. (1 row(s) affected) Altering [dbo].[bvc_ProductInventory_s] Altering [dbo].[bvc_Country_i] Msg 207, Level 16, State 1, Procedure bvc_Country_i, Line 17 Invalid column name 'ISOAlpha3'. Msg 207, Level 16, State 1, Procedure bvc_Country_i, Line 17 Invalid column name 'ISONumeric'. (1 row(s) affected) Altering [dbo].[bvc_ProductInventory_All_s] Altering [dbo].[bvc_ProductInput_AllShared_s ] Msg 207, Level 16, State 1, Procedure bvc_ProductInput_AllShared_s , Line 17 Invalid column name 'InputDisplayName'. (1 row(s) affected) Altering [dbo].[bvc_Product_All_s] Msg 207, Level 16, State 1, Procedure bvc_Product_All_s, Line 58 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_All_s, Line 59 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_All_s, Line 61 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_All_s, Line 62 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_AffiliateQuestion_u] Msg 207, Level 16, State 1, Procedure bvc_AffiliateQuestion_u, Line 0 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_Country_u] Msg 207, Level 16, State 1, Procedure bvc_Country_u, Line 0 Invalid column name 'ISOAlpha3'. Msg 207, Level 16, State 1, Procedure bvc_Country_u, Line 0 Invalid column name 'ISONumeric'. (1 row(s) affected) Altering [dbo].[bvc_ProductChoice_s ] Msg 207, Level 16, State 1, Procedure bvc_ProductChoice_s , Line 17 Invalid column name 'ChoiceName'. (1 row(s) affected) Altering [dbo].[bvc_ProductInput_s ] Msg 207, Level 16, State 1, Procedure bvc_ProductInput_s , Line 19 Invalid column name 'InputDisplayName'. (1 row(s) affected) Altering [dbo].[bvc_LineItemModifier_i] Msg 207, Level 16, State 1, Procedure bvc_LineItemModifier_i, Line 13 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_UserQuestion_i] Msg 207, Level 16, State 1, Procedure bvc_UserQuestion_i, Line 18 Invalid column name 'Order'. Msg 207, Level 16, State 1, Procedure bvc_UserQuestion_i, Line 29 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_ContactUsQuestion_i] Msg 207, Level 16, State 1, Procedure bvc_ContactUsQuestion_i, Line 19 Invalid column name 'Order'. Msg 207, Level 16, State 1, Procedure bvc_ContactUsQuestion_i, Line 30 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_ProductChoice_SharedByProduct_s ] Msg 207, Level 16, State 1, Procedure bvc_ProductChoice_SharedByProduct_s , Line 21 Invalid column name 'ChoiceName'. (1 row(s) affected) Altering [dbo].[bvc_CustomPage_u] Msg 207, Level 16, State 1, Procedure bvc_CustomPage_u, Line 0 Invalid column name 'MetaDescription'. Msg 207, Level 16, State 1, Procedure bvc_CustomPage_u, Line 0 Invalid column name 'MetaKeywords'. (1 row(s) affected) Altering [dbo].[bvc_ContactUsQuestion_s] Msg 207, Level 16, State 1, Procedure bvc_ContactUsQuestion_s, Line 16 Invalid column name 'Order'. (1 row(s) affected) Altering [dbo].[bvc_Order_i] Msg 207, Level 16, State 1, Procedure bvc_Order_i, Line 88 Invalid column name 'ThirdPartyOrderId'. (1 row(s) affected) Altering [dbo].[bvc_RMA_All_s] Msg 207, Level 16, State 1, Procedure bvc_RMA_All_s, Line 31 Invalid column name 'DateOfReturn'. (1 row(s) affected) Altering [dbo].[bvc_ProductModifier_AllShared_s ] Msg 207, Level 16, State 1, Procedure bvc_ProductModifier_AllShared_s , Line 17 Invalid column name 'Name'. (1 row(s) affected) Altering [dbo].[bvc_Order_s] Msg 207, Level 16, State 1, Procedure bvc_Order_s, Line 43 Invalid column name 'ThirdPartyOrderId'. (1 row(s) affected) Altering [dbo].[bvc_ProductModifier_i ] Msg 207, Level 16, State 1, Procedure bvc_ProductModifier_i , Line 23 Invalid column name 'Name'. (1 row(s) affected) Altering [dbo].[bvc_ProductAvailableAndActive] Msg 207, Level 16, State 1, Procedure bvc_ProductAvailableAndActive, Line 17 Invalid column name 'OutOfStockMode'. (1 row(s) affected) Altering [dbo].[bvc_ProductCrossSell_Count_s] Msg 8144, Level 16, State 2, Procedure bvc_ProductCrossSell_Count_s, Line 18 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. (1 row(s) affected) Altering [dbo].[bvc_Product_ByUpSellId_s] Msg 8144, Level 16, State 2, Procedure bvc_Product_ByUpSellId_s, Line 21 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. Msg 207, Level 16, State 1, Procedure bvc_Product_ByUpSellId_s, Line 67 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByUpSellId_s, Line 68 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByUpSellId_s, Line 70 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByUpSellId_s, Line 71 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_Product_ByCrossSellId_s] Msg 8144, Level 16, State 2, Procedure bvc_Product_ByCrossSellId_s, Line 21 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCrossSellId_s, Line 67 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCrossSellId_s, Line 68 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCrossSellId_s, Line 70 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCrossSellId_s, Line 71 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_WishList_i] Msg 207, Level 16, State 1, Procedure bvc_WishList_i, Line 12 Invalid column name 'UserId'. Msg 207, Level 16, State 1, Procedure bvc_WishList_i, Line 12 Invalid column name 'Quantity'. Msg 207, Level 16, State 1, Procedure bvc_WishList_i, Line 12 Invalid column name 'Modifiers'. Msg 207, Level 16, State 1, Procedure bvc_WishList_i, Line 12 Invalid column name 'Inputs'. (1 row(s) affected) Altering [dbo].[bvc_RMA_i] Msg 207, Level 16, State 1, Procedure bvc_RMA_i, Line 35 Invalid column name 'DateOfReturn'. (1 row(s) affected) Altering [dbo].[bvc_ProductCount_ByCategory_s] Msg 8144, Level 16, State 2, Procedure bvc_ProductCount_ByCategory_s, Line 18 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. (1 row(s) affected) Altering [dbo].[bvc_RMA_s] Msg 207, Level 16, State 1, Procedure bvc_RMA_s, Line 27 Invalid column name 'DateOfReturn'. (1 row(s) affected) Altering [dbo].[bvc_Product_s] Msg 207, Level 16, State 1, Procedure bvc_Product_s, Line 71 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_s, Line 72 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_s, Line 74 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_s, Line 75 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_Product_SuggestedItems] Msg 8144, Level 16, State 2, Procedure bvc_Product_SuggestedItems, Line 10 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. (1 row(s) affected) Altering [dbo].[bvc_ProductUpSell_Count_s] Msg 8144, Level 16, State 2, Procedure bvc_ProductUpSell_Count_s, Line 18 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. (1 row(s) affected) Creating [dbo].[bvc_WishList_s] Msg 8144, Level 16, State 2, Procedure bvc_WishList_s, Line 8 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. Msg 207, Level 16, State 1, Procedure bvc_WishList_s, Line 8 Invalid column name 'UserId'. Msg 207, Level 16, State 1, Procedure bvc_WishList_s, Line 8 Invalid column name 'Quantity'. Msg 207, Level 16, State 1, Procedure bvc_WishList_s, Line 8 Invalid column name 'Modifiers'. Msg 207, Level 16, State 1, Procedure bvc_WishList_s, Line 8 Invalid column name 'Inputs'. (1 row(s) affected) Altering [dbo].[bvc_Product_ProductsOrderedCount_s] Msg 8144, Level 16, State 2, Procedure bvc_Product_ProductsOrderedCount_s, Line 17 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. (1 row(s) affected) Altering [dbo].[bvc_WishList_ForUser_s] Msg 207, Level 16, State 1, Procedure bvc_WishList_ForUser_s, Line 14 Invalid column name 'UserId'. Msg 8144, Level 16, State 2, Procedure bvc_WishList_ForUser_s, Line 14 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. Msg 207, Level 16, State 1, Procedure bvc_WishList_ForUser_s, Line 8 Invalid column name 'UserId'. Msg 207, Level 16, State 1, Procedure bvc_WishList_ForUser_s, Line 8 Invalid column name 'Quantity'. Msg 207, Level 16, State 1, Procedure bvc_WishList_ForUser_s, Line 8 Invalid column name 'Modifiers'. Msg 207, Level 16, State 1, Procedure bvc_WishList_ForUser_s, Line 8 Invalid column name 'Inputs'. (1 row(s) affected) Creating [dbo].[bvc_Product_BySkuAll_s] Altering [dbo].[bvc_Product_ByCategory_s] Msg 8144, Level 16, State 2, Procedure bvc_Product_ByCategory_s, Line 16 Procedure or function dbo.bvc_ProductAvailableAndActive has too many arguments specified. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCategory_s, Line 69 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCategory_s, Line 70 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCategory_s, Line 72 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCategory_s, Line 73 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_Product_ByCriteria_s] Msg 207, Level 16, State 1, Procedure bvc_Product_ByCriteria_s, Line 100 Invalid column name 'SmallImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCriteria_s, Line 101 Invalid column name 'MediumImageAlternateText'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCriteria_s, Line 103 Invalid column name 'OutOfStockMode'. Msg 207, Level 16, State 1, Procedure bvc_Product_ByCriteria_s, Line 104 Invalid column name 'CustomProperties'. (1 row(s) affected) Altering [dbo].[bvc_Order_ByCriteria_s] Msg 207, Level 16, State 1, Procedure bvc_Order_ByCriteria_s, Line 64 Invalid column name 'ThirdPartyOrderId'. Msg 207, Level 16, State 1, Line 2 Invalid column name 'UserId'. (1 row(s) affected) Creating index [IX_bvc_RMAItem_LineItemBvin] on [dbo].[bvc_RMAItem] Adding constraints to [dbo].[bvc_ProductChoices] Adding constraints to [dbo].[bvc_ProductInputs] Adding constraints to [dbo].[bvc_ProductModifier] The database update failed
		Joe Bailey [email protected] 866.630.9876 Click here to build your BV Commerce website


User Profile View All Posts by User View Thanks

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.