Instructions on upgrading from Gummy Bear version 1.2 to version 1.3. As in previous updates, an Upgrade ZIP includes all updated web site files and a SQL update script to upgrade the database from 1.2 to 1.3. If upgrading from 1.1 be sure to execute the 1.1-to-1.2 SQL update script prior to upgrading to 1.3. All upgrade scripts are located in the /web/install/sql directory and named accordingly.
Determining your version of Gummy Bear
Your Gummy Bear version is listed in the page HTML header area as shown below. Look for the "CommunityFramework" metatag and the major release numbers of the version number as circled below.
Gummy Bear 1.2 to 1.3 is the Biggest Update...Evar!
This update is a huge one, with major restructuring of the website layout, new theming structure, and two applications (Sueetie Framework and YetAnotherForum.NET) converted from Website to WebApplication projects. There's a new Lucene global searching engine, localization, background tasks module, event log and exception capturing, updated versions of Gallery Server Pro and YetAnotherForum.NET, and
more. Huge.
It may be a better option to do a winmerge on your site changes, copy the change files to a safe location, blow away your current site, add the complete Gummy Bear 1.3 website contents, then execute the
gummybear_1.2.0_1.3.0_upgrade.sql script to upgrade the database from 1.2 to 1.3.
Another important issue to consider that in Gummy Bear 1.2, applications like forums and media gallery were optional. With more site-wide functions like global search, activity logging and other processes dependent on the existence of application SQL objects,
all applications are now REQUIRED. (Required applications: blog, forum, wiki, media gallery.) This means that if you had previously installed forums and the media gallery all should go swimmingly.
If you don't have forums or GSP installed, you will need to execute the YAF and/or GSP setup wizards BEFORE starting the upgrade process. One side-point on Gallery Server Pro setup. There's some data initialization that takes place upon loading GSP the first time, so go into the gallery before proceeding with the update process so all required data objects are populated.
Finally, Marketplace is no longer included in Gummy Bear.
Four Primary Upgrade Steps
Whether or not you apply the website DIFF contents ZIP to your existing site or load fresh from
GummyBear.Web.1.3.0.x64.ZIP, your upgrade process consists of three primary steps:
- Apply the website DIFFs or load fresh. (If forums or media gallery not installed, first run setup wizards.)
- Execute the upgrade script gummybear_1.2.0_1.3.0_upgrade.sql in MSQuery
- At this point your site is ready to roll, but we now have to update YetAnotherForum.NET SQL objects from YAF 1.9.3 to 1.9.4 RC2. Load your site and go to your Forums where YetAnotherForum.NET will automatically launch the upgrade wizard. Password is "admin."
- Cool. We're not done yet because we have a few SQL objects that depend on the updated YAF.NET schema. Our final update step is to execute gummybear_1.3.0_postupgrade.sql in MSQuery located in /install/sql.
Sueetie now a WebApplication in Version 1.3
Besides adding
cool features, a more robust framework, and one or two bug fixes, Gummy Bear v1.3 has two objectives: 1) Support the creation of Theme Packs, and 2) Lay the groundwork for more developer-focused features coming in Gummy Bear v1.4. Converting the Sueetie Web root from a Website Project format to a WebApplication enables us to support more development and customization tools planned for v1.4.
Upgrading your Gummy Bear v1.2 website to a webapplication will require more than dragging the updated files over your existing site files. Consider these upgrade steps as the best approach to upgrading your site to avoid unforeseen complications:
- Backup your website files to a safe location from which you can easily retrieve files you might need
- Delete EVERYTHING BUT the application folders and a few miscellaneous support folders. These would be for a typical Gummy Bear site
- blog
- forum
- media
- wiki
- scripts
- images
- aspnet_client (if exists)
Please note that Marketplace is no longer supported in Gummy Bear. It will be updated and made available in the future as a true eCommerce application and, optionally, as a Community Classifieds application, since that was it's original design. Also delete the Marketplace folder.YetAnotherForum.NET now a WebApplication.
YetAnotherForum.NET (1.9.4 RC2) is now also a WebApplication where it was previously a website project. So in the update of your forums, typically in your /forum directory, you will want to
remove all YAF contents with the exception of your /forum/upload folder and copy over the /forum contents from the v1.3 web site contents ZIP file. (Sidebar: The name of the YAF upload directory has been changed to "uploads" so remember to rename /forum/upload to /forum/uploads.)
WebApplication Structure and Content Changes¶
In general, here are the structural and content changes in the new Gummy Bear WebApplication.
- The Administrative area has been broken out by category: User management, Site management, Content, Applications, Reports and Add-ons
- Themes contents, including images, stylesheets, master files, etc are located in their own /themes/THEME area.
- A /util folder contains a number of new and relocated utility and support content. Below is an image of the /utils area contents. Notice that all .config files, including app.config and connections.config are located in /utils/config.

For a more detailed description of the new Sueetie WebApplication format see
WebApplication Overview. It contains information which will help you configure and customize your site.
In Summary
- Sueetie is now a WebApplication Project. Given that fact plus major restructuring between Gummy Bear 1.2 and 1.3, delete all folders other than the application folders (blog, forum, media and wiki) and those listed above.
- YetAnotherForum is also now a WebApplication Project, so delete all folder contents other than the /forum/upload folder.
- The Website ZIP contents includes complete web root files, complete forum contents, ScrewTurn wiki DIFFs, BlogEngine.NET blog DIFFs and Gallery Server Pro media DIFFs.
WebApplication Structure and Content Changes¶
In general, here are the structural and content changes in the new Gummy Bear WebApplication.
- The Administrative area has been broken out by category: User management, Site management, Content, Applications, Reports and Add-ons
- Themes contents, including images, stylesheets, master files, etc are located in their own /themes/THEME area.
- A /util folder contains a number of new and relocated utility and support content. Below is an image of the /utils area contents. Notice that all .config files, including app.config and connections.config are located in /utils/config.

For a more detailed description of the new Sueetie WebApplication format see
WebApplication Overview. It contains information which will help you configure and customize your site.
In Summary
- This upgrade is a huge one.
- Remember the four steps: 1) website files update, 2) sql upgrade script, 3) launch YAF.NET upgrade wizard in website, 4) execute post_upgrade SQL script
- Sueetie is now a WebApplication Project. Given that fact plus major restructuring between Gummy Bear 1.2 and 1.3, delete all folders other than the application folders (blog, forum, media and wiki) and those listed above.
- YetAnotherForum is also now a WebApplication Project, so delete all folder contents other than the /forum/upload folder.
- The Website ZIP contents includes complete web root files, complete forum contents, ScrewTurn wiki DIFFs, BlogEngine.NET blog DIFFs and Gallery Server Pro media DIFFs.