Invalid object name 'Customer'.

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
12 years ago
Hi,

I am trying to run the upgrade script to move from 1.9 to 2.0 but I am getting the following errors:

Msg 208, Level 16, State 1, Line 3
Invalid object name 'Customer'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Address'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Country'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'StateProvince'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'ShippingMethod'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'TaxCategory'.
Msg 208, Level 16, State 1, Line 8
Invalid object name 'Setting'.
moving downloads
moving download. ID 11
Msg 1088, Level 16, State 11, Line 18
Cannot find the object "Download" because it does not exist or you do not have permissions.
moving pictures
moving picture. ID 82
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "Picture" because it does not exist or you do not have permissions.
moving languages
Msg 208, Level 16, State 1, Line 7
Invalid object name 'Language'.
moving campaigns
moving countries
moving country. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'Country'.
moving states
moving state. ID 4
Msg 208, Level 16, State 1, Line 19
Invalid object name 'StateProvince'.
moving affiliates
moving customer roles
moving customer role. ID 1
Msg 208, Level 16, State 1, Line 22
Invalid object name 'CustomerRole'.
moving customers
moving customer. ID 38
Msg 1088, Level 16, State 11, Line 23
Cannot find the object "Customer" because it does not exist or you do not have permissions.
moving customer addresses
moving addresses. ID 84
Msg 208, Level 16, State 1, Line 22
Invalid object name 'Address'.
moving blog posts
moving blog post. ID 7
Msg 1088, Level 16, State 11, Line 20
Cannot find the object "BlogPost" because it does not exist or you do not have permissions.
moving blog comments
moving news items
moving news item. ID 13
Msg 1088, Level 16, State 11, Line 20
Cannot find the object "News" because it does not exist or you do not have permissions.
moving news comments
moving polls
moving poll. ID 2
Msg 1088, Level 16, State 11, Line 20
Cannot find the object "Poll" because it does not exist or you do not have permissions.
moving poll answers
moving poll answer. ID 7
Msg 208, Level 16, State 1, Line 14
Invalid object name 'PollAnswer'.
moving poll voting records
moving forum groups
moving forum group. ID 2
Msg 1088, Level 16, State 11, Line 17
Cannot find the object "Forums_Group" because it does not exist or you do not have permissions.
moving forums
moving forum. ID 2
Msg 1088, Level 16, State 11, Line 21
Cannot find the object "Forums_Forum" because it does not exist or you do not have permissions.
moving forum topics
moving forum posts
moving forum subscriptions
moving private messages
moving newsletter subscriptions
moving newsletter subscription. ID 5
Msg 208, Level 16, State 1, Line 24
Invalid object name 'NewsLetterSubscription'.
moving queued emails
Msg 208, Level 16, State 1, Line 15
Invalid object name 'Setting'.
moving shipping methods
moving shipping method. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'ShippingMethod'.
moving tax categories
moving tax category. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "TaxCategory" because it does not exist or you do not have permissions.
moving categories
moving category. ID 29
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "Category" because it does not exist or you do not have permissions.
moving localized categories
moving manufacturers
moving manufacturer. ID 1
Msg 1088, Level 16, State 11, Line 22
Cannot find the object "Manufacturer" because it does not exist or you do not have permissions.
moving localized manufacturers
moving product tags
moving products
moving product. ID 91
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "Product" because it does not exist or you do not have permissions.
moving localized products
moving related products
moving related product. ID 85
Msg 208, Level 16, State 1, Line 25
Invalid object name 'RelatedProduct'.
moving crosssell products
moving crosssell product. ID 1
Msg 208, Level 16, State 1, Line 25
Invalid object name 'CrossSellProduct'.
moving specification attributes
moving specification attribute. ID 8
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "SpecificationAttribute" because it does not exist or you do not have permissions.
moving localized specification attributes
moving specification attribute options
moving specification attribute option. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "SpecificationAttributeOption" because it does not exist or you do not have permissions.
moving localized specification attribute option
moving checkout attributes
moving localized checkout attributes
moving checkout attribute values
moving localized checkout attribute value
moving product variants
moving product variant. ID 101
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "ProductVariant" because it does not exist or you do not have permissions.
moving localized product variants
moving product attributes
moving product attribute. ID 4
Msg 1088, Level 16, State 11, Line 23
Cannot find the object "ProductAttribute" because it does not exist or you do not have permissions.
moving localized product attribute
moving product variant attributes
moving product variant attribute. ID 29
Msg 1088, Level 16, State 11, Line 25
Cannot find the object "ProductVariant_ProductAttribute_Mapping" because it does not exist or you do not have permissions.
moving product variant attribute values
moving product variant attribute value. ID 65
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "ProductVariantAttributeValue" because it does not exist or you do not have permissions.
moving localized product variant attribute value
moving product variant attribute combinations
moving tier prices
moving discounts
moving discount. ID 2
Msg 1088, Level 16, State 11, Line 45
Cannot find the object "Discount" because it does not exist or you do not have permissions.
moving orders
moving order. ID 1
Msg 208, Level 16, State 1, Line 103
Invalid object name 'Address'.
moving order product variants
moving order product variant. ID 1
Msg 208, Level 16, State 1, Line 25
Invalid object name 'OrderProductVariant'.
moving order notes
moving order note. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'OrderNote'.
moving discount usage history
moving discount usage history. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'DiscountUsageHistory'.
moving gift cards
moving gift card usage history
moving recurring payments
moving recurring payment history
moving return requests
moving reward points history
moving product reviews
moving product review. ID 1
Msg 208, Level 16, State 1, Line 26
Invalid object name 'CustomerContent'.
moving product review helpfulness
updating product review totals
product review total. ID 91
Msg 208, Level 16, State 1, Line 43
Invalid object name 'Product'.



Thanks.

JT
12 years ago
Have you installed nopCommerce 2.0 (using wizard) before running the script?
P.S. There's a Readme.txt file in the upgrade script archive
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.