Database for AbleCommerce Gold vs. Gold R2

[KenPalmer]

Is the database the same for AbleCommerce Gold and AbleCommerce Gold R2? I installed AbleCommerce Gold, and need to replace that with files from AbleCommerce Gold R2. What I'd like to do is replace the files and then point them to my existing database, since I've already loaded products to it. Thanks.

[jmestep]

I did an upgrade from R1 to R2 by just running the sql script in the upgrade folder since I didn't have access to the readme for the upgrade. The only difference in the scripts for the upgrade was that the upgrade to R2 had an extra query to run having to do with kit component. The database stayed the same.

[KenPalmer]

Thanks Judy.

[Logan Rhodehamel]

There were no database changes between Gold and Gold R2. The change that I think Judy is referring to was an improvement to the upgrade script for 707 stores. It was an added query to eliminate old bad data that may have been hanging around from an even earlier version than AC7x. If you upgraded from 707 to Gold and you want to make sure you don't have this old data, the following query is all that has to be run on the database. Although if you had this bad data, you would probably know it as editing your kit products would fail.

Code: Select all

DELETE FROM ac_ProductKitComponents WHERE ProductId NOT IN (SELECT DISTINCT ProductId FROM ac_Kits)

Going forward (R3 and beyond) the upgrade process should be simplified with respect to database changes.