Symptoms
When attempting to run the initial installation script against a clean database during the initial instalation, the script produces a large number of errors regarding missing objects (see example below).
Cause
This is caused by using a case-sensitive database collation setting.
Solution
Select a different collation setting for your database. AspDotNetStorefront recommends using SQL_Latin1_General_CP1_CI_AS (this is the default collation for most standard SQL installations). Assistance with this is outside the bounds of the free Help Desk. Please consult a knowledgeable Database Administrator/Technician for assistance if necessary.
Example Msg 208, Level 16, State 1, Procedure ProductEntity, Line 3
Invalid object name 'dbo.productcategory'.
Msg 207, Level 16, State 1, Procedure GetQtyDiscountPct, Line 24
Invalid column name 'name'.
Msg 207, Level 16, State 1, Procedure GetQtyDiscountPct, Line 24
Invalid column name 'configvalue'.
Msg 207, Level 16, State 1, Procedure GetQtyDiscountPct, Line 25
Invalid column name 'name'.
Msg 207, Level 16, State 1, Procedure GetQtyDiscountPct, Line 31
Invalid column name 'quantitydiscountid'.
Msg 137, Level 15, State 2, Procedure Split, Line 13
Must declare the scalar variable "@STRING".
Msg 137, Level 15, State 2, Procedure Split, Line 16
Must declare the scalar variable "@STRING".
Msg 137, Level 15, State 2, Procedure Split, Line 18
Must declare the scalar variable "@STRING".
Msg 137, Level 15, State 2, Procedure Split, Line 22
Must declare the scalar variable "@STRING".
Msg 137, Level 15, State 2, Procedure Split, Line 24
Must declare the scalar variable "@STRING".
Msg 137, Level 15, State 2, Procedure GetIndexColumns, Line 30
Must declare the scalar variable "@colNames".
Msg 207, Level 16, State 1, Procedure aspdnsf_MoveToShoppingCart, Line 19
Invalid column name 'ShoppingCartRecId'.
Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 116
Must declare the table variable "@tblsubtotal".
Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 137
Must declare the table variable "@tblsubtotal".
Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 142
Must declare the table variable "@tblsubtotal".
Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 155
Must declare the table variable "@tblsubtotal".
Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 160
Must declare the table variable "@tblsubtotal".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 9
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 16
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 23
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 30
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 37
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 44
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 51
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 58
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 65
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 72
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 79
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 86
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 93
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 100
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 107
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 114
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 121
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 128
Must declare the scalar variable "@productid".
Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 135
Must declare the scalar variable "@productid".
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 83
Invalid column name 'categoryID'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 85
Invalid column name 'sectionID'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 87
Invalid column name 'manufacturerID'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 89
Invalid column name 'distributorID'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 91
Invalid column name 'genreID'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 93
Invalid column name 'vectorID'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 103
Invalid column name 'categoryID'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 103
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 103
Invalid column name 'displayorder'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 106
Invalid column name 'sectionId'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 106
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 106
Invalid column name 'displayorder'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 109
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 109
Invalid column name 'displayorder'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 112
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 112
Invalid column name 'displayorder'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 115
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 115
Invalid column name 'displayorder'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 118
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 118
Invalid column name 'displayorder'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 121
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 374
Invalid column name 'ProductID'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 382
Invalid column name 'quan'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 325
Invalid column name 'ImageFileNameOverride'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 346
Invalid column name 'inventory'.
Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 371
Invalid column name 'productid'.
Msg 4104, Level 16, State 1, Procedure aspdnsf_SearchCategories, Line 11
The multi-part identifier "category.name" could not be bound.
Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 40
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 40
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 81
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 81
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 121
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 121
Invalid column name 'productid'.
Msg 137, Level 15, State 2, Procedure aspdnsf_ExportProductList, Line 61
Must declare the scalar variable "@DistributorID".
Msg 137, Level 15, State 2, Procedure aspdnsf_ExportProductList, Line 63
Must declare the scalar variable "@GenreID".
Msg 137, Level 15, State 2, Procedure aspdnsf_ExportProductList, Line 65
Must declare the scalar variable "@VectorID".
Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 8
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 9
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 10
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 11
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 12
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 12
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 12
Invalid column name 'published'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 25
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 25
Invalid column name 'published'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 38
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 38
Invalid column name 'published'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 51
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 51
Invalid column name 'published'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 65
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 65
Invalid column name 'published'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 78
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 78
Invalid column name 'published'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 89
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 89
Invalid column name 'published'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 100
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 100
Invalid column name 'published'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 113
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 113
Invalid column name 'published'.
Msg 207, Level 16, State 1, Procedure aspdnsf_SearchManufacturers, Line 13
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_SearchManufacturers, Line 14
Invalid column name 'name'.
Msg 207, Level 16, State 1, Procedure aspdnsf_SearchDistributors, Line 14
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_SearchDistributors, Line 15
Invalid column name 'name'.
Msg 207, Level 16, State 1, Procedure aspdnsf_SearchGenres, Line 13
Invalid column name 'deleted'.
Msg 207, Level 16, State 1, Procedure aspdnsf_SearchGenres, Line 14
Invalid column name 'name'.
Msg 137, Level 15, State 2, Procedure aspdnsf_GetSimpleObjectEntityList, Line 35
Must declare the scalar variable "@CustomerLevelID".
Msg 137, Level 15, State 2, Procedure aspdnsf_GetSimpleObjectEntityList, Line 57
Must declare the scalar variable "@CustomerLevelID".
Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 49
Invalid column name 'customerid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 49
Invalid column name 'carttype'.
Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50
Invalid column name 'customerid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50
Invalid column name 'carttype'.
Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50
Invalid column name 'variantid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50
Invalid column name 'chosencolor'.
Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50
Invalid column name 'chosensize'.
Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50
Invalid column name 'textoption'.
Msg 137, Level 15, State 1, Procedure aspdnsf_PageQuery, Line 69
Must declare the scalar variable "@symbol".
Msg 137, Level 15, State 2, Procedure aspdnsf_PageQuery, Line 73
Must declare the scalar variable "@colList".
Msg 207, Level 16, State 1, Procedure aspdnsf_BestSellers, Line 28
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_BestSellers, Line 28
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_BestSellers, Line 29
Invalid column name 'variantid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_BestSellers, Line 29
Invalid column name 'variantid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_RecentAdditions, Line 21
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Procedure aspdnsf_RecentAdditions, Line 21
Invalid column name 'productid'.
Msg 207, Level 16, State 1, Line 335
Invalid column name 'groupName'.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'dbo.customer'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.DocumentType'.
Msg 8107, Level 16, State 1, Line 3
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.KitGroupType'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.LOG_Event'.
Msg 8107, Level 16, State 1, Line 1
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.PollSortOrder'.
Msg 8107, Level 16, State 1, Line 3
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.ProductType'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.TaxClass'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.SalesPrompt'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.ShippingCalculation'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.ShippingMethod'.
Msg 208, Level 16, State 1, Line 42
Invalid object name 'dbo.topic'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Category'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Section'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Manufacturer'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Product'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.ProductVariant'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.KitItem'.
Msg 8107, Level 16, State 1, Line 3
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Country'.
Msg 8107, Level 16, State 1, Line 4
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.AffiliateActivityReason'.
Msg 8107, Level 16, State 1, Line 2
IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Currency'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'SkuSuffix'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'SkuSuffix'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'SkuSuffix'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'SkuSuffix'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'SkuSuffix'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'SkuSuffix'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'SkuSuffix'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'SkuSuffix'.
Msg 208, Level 16, State 1, Line 4
Invalid object name 'dbo.category'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.section'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.library'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.manufacturer'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.distributor'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.product'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.product'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.product'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.document'.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'customer'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'name'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'name'.
Msg 1911, Level 16, State 1, Procedure aspdnsf_CreateIndexes, Line 5
Column name 'GIftRegistryGUID' does not exist in the target table or view.