Well I upgraded www.AbleMods.com to 7.0.7 AbleCommerce yesterday.  Ran into a few minor issues but nothing major.  The upgrade did break the abandoned baskets detail report though.

The new look to the admin side is nice.  Beats the dead-blue we’ve been staring at for 3 years now.

The install scripts worked well and the only error I had was self-inflicted.  My Returns Manager module had a foreign-key constraint against ac_Orders which the upgrade script didn’t like.  To work around it, here’s what I did:

1.   Load SQL Manager, expand your db, expand Tables and expand the Keys for ac_OrderReturns

2.   Right-click the FK that references ac_Orders and choose “SCRIPT-CREATE to New Window”.  This will make a new SQL command that will rebuild the FK once the upgrade is done.

3.   Now Right-click the FK and delete it.

4.   Run the upgrade.

5.   After the upgrade is completely done, switch back to SQL Manager and execute the new script you created earlier.  This will automatically recreate the FK necessary on ac_OrderReturns.

Not major, but still a hassle nonetheless.  One of these days AbleCommerce is going to quit doing DROP-CREATEs to make their upgrade table changes.  Drop-Create fails if there are FK constraints against the table being modified.

Sometime soon I’ll need to upgrade www.Solunar.com but that can wait.  For now I want to stay focused on projects.