Upgrade from V1.9 to V.2.2

anyone has experience upgrade v1.9 to v2.2?
any step instruction ?

thanks in advance

This video should be useful. If you upgrade from 1.9 to 2.0 then you need only to execute upgrade scripts from 2.0 > 2.1 and 2.1 > 2.2

I am running upgrade script for 2.0, and getting following error..

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 campaign. ID 1
Msg 1088, Level 16, State 11, Line 22
Cannot find the object "Campaign" because it does not exist or you do not have permissions.
moving countries
moving country. ID 41
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 affiliate. ID 1
Msg 208, Level 16, State 1, Line 22
Invalid object name 'Address'.
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 37
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 79
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 blog comment. ID 1
inserting guest customer for blog comment
Msg 208, Level 16, State 1, Line 23
Invalid object name 'Customer'.
moving news items
moving news item. ID 11
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 poll voting record. ID 1
Msg 208, Level 16, State 1, Line 15
Invalid object name 'CustomerContent'.
moving forum groups
moving forum group. ID 3
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 topic. ID 1
Msg 1088, Level 16, State 11, Line 21
Cannot find the object "Forums_Topic" because it does not exist or you do not have permissions.
moving forum posts
moving forum post. ID 1
Msg 1088, Level 16, State 11, Line 21
Cannot find the object "Forums_Post" because it does not exist or you do not have permissions.
moving forum subscriptions
moving forum subscription. ID 1
Msg 208, Level 16, State 1, Line 32
Invalid object name 'Forums_Subscription'.
moving private messages
moving newsletter subscriptions
moving newsletter subscription. ID 1
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 5
Msg 208, Level 16, State 1, Line 24
Invalid object name 'ShippingMethod'.
moving tax categories
moving tax category. ID 10
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 product tag. ID 17
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "ProductTag" because it does not exist or you do not have permissions.
moving products
moving product. ID 45
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 35
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 4
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 checkout attribute. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "CheckoutAttribute" because it does not exist or you do not have permissions.
moving localized checkout attributes
moving checkout attribute values
moving checkout attribute value. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "CheckoutAttributeValue" because it does not exist or you do not have permissions.
moving localized checkout attribute value
moving product variants
moving product variant. ID 54
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 16
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 29
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 product variant attribute combination. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "ProductVariantAttributeCombination" because it does not exist or you do not have permissions.
moving tier prices
moving tier price. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "TierPrice" because it does not exist or you do not have permissions.
moving discounts
moving discount. ID 1
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. ID 1
Msg 208, Level 16, State 1, Line 34
Invalid object name 'GiftCard'.
moving gift card usage history
moving gift card usage history. ID 1
Msg 208, Level 16, State 1, Line 25
Invalid object name 'GiftCardUsageHistory'.
moving recurring payments
moving recurring payment history
moving return requests
moving return request. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'ReturnRequest'.
moving reward points history
moving reward points history. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'RewardPointsHistory'.
moving product reviews
moving product review. ID 2
Msg 208, Level 16, State 1, Line 26
Invalid object name 'CustomerContent'.
moving product review helpfulness
moving product review helpfulness. ID 2
Msg 208, Level 16, State 1, Line 15
Invalid object name 'CustomerContent'.
updating product review totals
product review total. ID 45
Msg 208, Level 16, State 1, Line 43
Invalid object name 'Product'.


Please help

did you install v2.00 in the same DB where 1.9 already exist? you need to do this before you execute upgrade script.

We have just done three. (actually a 1.5 t0 2.2, 1.7 to 2.2 and a 1.4 to 2.2) We upgraded them all becuase of the excel import with images etc etc

Actually step by step is quite simple - read the readme files that come with the SQL upgrade scripts quite important.

Make a backup of your files.
Delete all the files form your website folder
copy in all of the files from 2.0 new install (we use no source)
copy all of the images files from /images folder of the old site to /content/images folder in the new website
THEN run the website using vs2010 or browse to it if its on a server.
It will come up with install screen - Choose install to a existing database (UNCHECK INSTALL SAMPLE DATA)
Put the name of your existing database
it will then say finished and none of your informaiton will be in. Dont panic :)
You then need to run the SQL script (nopCommerce_2.00_UpgardeScripts) and follow the instructions in the readme file.
Dont worry about themeing or design at this stage

Then MAKE A COPY OF InstalledPlugins.txt and settings.txt from the App_Data folder

Delete all of the files from your website folder again.

Run the SQL upgrade scripts against the database for 2.0-2.1 and then 2.1-2.2

Copy in all of the files from a new 2.2 install. Add the files you copied (InstalledPlugins.txt and settings.txt) into the App_Data and run the website!

See quite easy.


Couple of things we found.

If your images are stored in the database do not chnage it before the upgrade! You need to change it after successful upgrade (it will then copy all the files into the correct folder....much easier)

If you're files are stored in the file system MAKE SURE you copy all of the photos into the correct images folder before you run the website. This will help keep the link. (we lost all the images when we forgot to copy across the images first)

The upgrade process doesnt keep your topics so make a note of those (machine names) and content. If you can run a version of your old website just do what we did and cut and paste across - keeps all the formatting.

It doesnt even copy across your store name, SEO, or other basic shop info so make a note of all ot these. (the READEME file tells you this, but didnt realise just how much it doesnt copy. Most importantly all products, categories, mappings and news ARE automactically copied.

THe rest should just be a themeing issue. (duplicate one of the others, change the theme.config file rename the folder, overwrite the styles.css with the one from your old site. Everthing should be aas close as it gets. Just a few tweaks.

But the above made it VERY simple for us. Just a lot of work for the themeing. ( and by that I mean about 4 hours) due to different class names and some custom work we had done.

Hope it helps. Sorry not a technical guy here (by that I mean compared to the dev gurus on the site) but if I can do it anybody can!


Hope it helps. Havent slept for a day so will check again in the morning. But sure its right.......:)

Forgot to mention. If you have your images stored in database. Once you have run all the upgrades you can change it to be stored in the file system and you wont loose all of the images of your categories .... unlike 1.x

Is it required that if i am upgrading from 1.9 to 2.2, I frist upgrade to 2.0, then 2.1 and fianlly to 2.2?

kakoli wrote:
Right

Is there no way i upgrade directly to Nop2.2 from 1.9 :( ?

it really does take all of about 20 minutes to do the upgrade right through to 2.2 and is very easy. But no there isnt a direct to 2.2 as such.