Gummy Bear 1.1 to 1.2 Upgrade Guide

Upgrade Overview¶

It is highly advised to backup both your site database and website before upgrading to Gummy Bear 1.2. It is also recommended to perform the upgrade in a development environment before applying to your production site.

The 1.1 to 1.2 upgrade process should be performed in the order listed and includes

1. Download and unzip the Gummy Bear 1.2.0 Upgrade Package ZIP
2. Run the Gummybear_1.2.0.sql script
3. Copy over the 1.2.0-DIFF website files
4. Update the SQL connection strings in the website .config files
5. Follow-up Items
   

Determining Your Current Gummy Bear Version¶

You can find out what version of Gummy Bear you're running by viewing the source of any web page on your site where you'll see a "CommunityFramework" meta tag as shown here. To be safe, check the meta tag on your site home page (there are several applications in Gummy Bear and the meta tag could be missing on more isolated pages.) The CommunityFramework tag below tells us that this version of Gummy Bear is 1.1. If your home page contains no CommunityFramework tag then your site was a pre-1.1 release when the tag was added, mostly likely version 1.0.4.



It is assumed that you ARE RUNNING VERSION 1.1 and have previous experience installing Gummy Bear using the Installation Page shown here.

Download and unzip the Gummy Bear 1.2 Upgrade Package ZIP¶

The Gummy Bear 1.2 Upgrade Package is located in the Gummy Bear folder of the Sueetie Media Gallery. You must be logged-in to view and access the Gummy Bear folder contents. There are three ZIPs related to Gummy Bear 1.2, 1) Full Release of Gummy Bear 1.2 (GummyBear.1.2.0.64x.ZIP), 2) Gummy Bear 1.2 Upgrade (GummyBear.1.2.Upgrade.ZIP) and 3) the Gallery Server Pro 32x-bit DLLs (GSP32x.DLLs.ZIP.) If you are upgrading from Gummy Bear 1.1 you will be using GummyBear.1.2.Upgrade.ZIP.

The GummyBear.1.2.Upgrade.ZIP contains the 1.1-to-1.2 website DIFF files and the 1.2 SQL upgrade script. Extract the contents of the upgrade package you downloaded from the Sueetie Media Gallery to a working directory.

If currently using Gummy Bear 1.0.4¶

You'll need to perform an incremental upgrade from 1.0.4 to 1.1, then from 1.1 to 1.2. This should consist of nothing more than copying over the Gummy 1.1 upgrade package website files and executing the Gummy 1.1 upgrade SQL script. Then you can upgrade to Gummy 1.2 normally.

Breaking Issue between Gummy 1.1 and 1.2¶

Before going further, there's a breaking issue between Gummy Bear 1.1 and 1.2. Content Part HTML is no longer Encoded when stored. This means that your existing Content Parts will be mucked-up and potentially lost if you don't preserve them prior to upgrading Gummy Bear from 1.1 to 1.2. Go to your existing pages containing content parts or to the Content Part Administrative Page where all content parts are listed. For each content part, go into HTML mode and copy the content to a safe location. Then post-upgrade to 1.2 you will be able to restore the orginal content.

Run the Gummybear_1.2.0.sql script¶

Because of the extensive SQL modifications from 1.1 to 1.2, Gummy Bear 1.2 does not include a web-based SQL upgrade link to update the SQL Server database. We will thus be executing the SQL Server update script, then applying the website diff files.

Gummybear_1.2.0.sql is located in the 1.2.0-DIFF website files at /install/sql/gummybear_1.2.0.sql in the 1.2.0-DIFF website files you extracted to a working location earlier.

Load Gummybear_1.2.0.sql into MS-Sql. It will look like the following.



The output of a successful sql update should look like this:

Copy over the 1.2.0-DIFF website files¶

Copy over the files in your extracted 1.2.0-DIFF folder to your working website as shown below. I made every effort to not write over existing data files in \blog\app_data and \wiki\public, but it's in your best interest to walk through those folders so you don't lose any data. Of course, you already made a backup of your 1.1 website, so it's not an issue.

If using the Lollipop theme, the Lollipop contents of the DIFFs will overwrite any CSS changes you may have made, so be sure you've preserved those before proceeding.

Update the SQL connection strings in the website .config files¶

Update the connection strings in the website .config files. Below is how the process would be performed in Visual Studio if you were using the default connection type and updating the name of the database only. "initial catalog=gummybear" to be replaced by "initial catalog=yourdatabase." The connection string is the same on all site .config files, so even if you would search/replace on a different string, the traversal should take one time only.

Follow-up Items¶

Global Site Menu Control¶

The change in Gummy 1.2 which will have the most immediate impact on you is the new Global Site Menu. Please see the Global Site Menu Control wiki page for complete setup instructions.

Sueetie.Config Changes¶

The Site Menu Control Tabs Settings have been added to the Gummy Bear 1.2 Sueetie.Config as well as a new "SiteUniqueName" property in the CORE config area. Be sure to add it or you will encounter an error.

----

We'll list any follow-up items people have discovered they needed to do here. We will also link to any relevant Discussion threads.