Recommended and tested upgrade guide to Gummy Bear 1.1 from 1.0.4
Upgrade Overview
It is highly advised to backup both your site database and website before upgrading to Gummy Bear 1.1. It is also recommended to perform the upgrade in a development environment before applying to your production site.
The 1.0.4 to 1.1 upgrade process should be performed in the order listed and includes
- Download and unzip the Gummy Bear 1.1.0 Upgrade Package ZIP
- Run the Gummybear_1.1.0.sql script
- Copy over the 1.1.0-DIFF website files
- Update the SQL connection strings in the website .config files
- Follow-up Items
It is assumed that you first installed Gummy Bear using the Installation Page shown here.
Download and unzip the Gummy Bear 1.1 Upgrade Package ZIP¶
The Gummy Bear 1.1 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.1, 1) Full Release of Gummy Bear 1.1 (GummyBear.1.1.0.64x.ZIP), 2) Gummy Bear 1.1 Upgrade (GummyBear.1.1.Upgrade.ZIP) and 3) the Gallery Server Pro 32x-bit DLLs (GSP32x.DLLs.ZIP.) If you are upgrading from Gummy Bear 1.0.4 you will be using
GummyBear.1.1.Upgrade.ZIP.The GummyBear.1.1.Upgrade.ZIP contains the 1.0.4-to-1.1 website DIFF files and the 1.1 SQL upgrade script. Extract the contents of the upgrade package you downloaded from the Sueetie Media Gallery to a working directory.
Run the Gummybear_1.1.0.sql script
Gummy Bear 1.1 does not include a web-based SQL upgrade link to update the SQL Server database from 1.0.4 to 1.1. If you look through the SQL updates documented in the Gummybear_1.1.0.sql header notes you'll see a number of core structures are being modified, like Sueetie_Users and Sueetie_SiteSettings, the latter no longer used in 1.1 having been replaced by Sueetie_Settings. This is why it we are executing the SQL Server update script, then applying the website diff files, otherwise we would most likely encounter website errors.
Gummybear_1.1.0.sql is located in the 1.1.0-DIFF website files at
/install/sql/gummybear_1.1.0.sql in the 1.1.0-DIFF website files you extracted to a working location earlier.
Load Gummybear_1.1.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.1.0-DIFF website files
Copy over the files in your extracted 1.1.0-DIFF folder to your working website as shown below.
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
We'll list any follow-up items people have discovered they needed to do here. We will also link to any relevant Discussion threads.