HomeHome Product Discus... Product Discus...SmithCartSmithCartIssue After MigrationIssue After Migration
Previous
 
Next
New Post
11/18/2013 5:28 AM
 
I am in the process of migrating my DNN Installation from a Window 2003 Server running MSSQL 2005 to a Windows 2012 Server running MSSQL 2012. After migrating everything over I am experiencing two issues.

First, it is no longer recognizing my license. the product is licensed to rumpussports.com. I am trying to access the portal on the new server using test.rumpussports.com

Second, the SmithCart is not pulling up my previously entered products and categories. I checked the database and everything is there, it's just not linking up.

Any help on these two issues would be greatly appreciated. Thanks.
 
New Post
11/18/2013 10:21 AM
 
Hi John,

Which version of the Cart and DNN are you running?

Have you updated the TabModuleID of your Products?

The issue is most likely the TabModuleID assigned to the data being migrated from your previous store. The reason that TabModuleID is saved with product is so you can run multiple stores in your portal with unique categories and products. Also if you delete a BuyNow module and add it again to the page DNN will assign a different TabModuleID.

The easiest/fastest way to import your data after a data migration would be to do the following:
  1. Add your buynow module on your new page, where you want it.
  2. Add a single item to the products, so that it shows up on your new BuyNow module.
  3. Look in SQL Management studio, and jot down the TabModuleID for the new item.
  4. Update the data so your old items (with the incorrect TabModuleID) match the new TabModuleID
For Example:
UPDATE Smith_Products SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Category SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Product_Variants SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Manufacturers SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Orders SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
so on and so forth.

Hope this helps!

 
New Post
11/18/2013 10:27 AM
 
I am running 5.6.8.

I don't think my TabModuleID would have changed since this was a full installation migration with a database restore. However, I will look at this.

Any thoughts on the License issue?
 
New Post
11/18/2013 10:30 AM
 
Hi John,

Is your Product Listing Page only displaying the licensing message and nothing else?

Are the Products showing in your Manage Products screen?

If you add a new Product via the Cart's UI, is the Product displayed?

Thanks!
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartIssue After MigrationIssue After Migration