OPEN SOURCE CONTENT MANAGEMENT and CUSTOM WEBSITE DEVELOPMENT MADE EASY

Breeze Website Builder™ Upgrade Instructions

Note: Upgrades must be performed incrementally.  You cannot skip a version.

Automatic Update (Version 6.0.04 and later)

As long as your Breeze installation is not more than one version behind the latest, you can simply click the Update Now button that appears a few seconds after logging in, and your Breeze will update automatically. If your installation is two or more version behind, you will need to use the Update Wizard as described below.

Update Wizard (version 5.0.02 and later)

1. After downloading the update file from the downloads page, log into the Breeze Website Builder™ with admin privileges. 
2. Click on SITE MANAGEMENT, Manage Users & Site Options, then Install Update. 
3. Enter the password for the user admin, and click Login. Note: You may be logged in as a different user with admin privileges, but you will need to use the password for the username admin.
4. Browse to the update file you downloaded.  Note: It is not necessary to unzip this file.
5. Click on Install to install the updates.  The process will complete automatically.

---

Special instructions to update existing website from version 6.0.x to version 6.1.x

You can still edit the content after upgrading from version 6.0.x to 6.1.x and your sites function will not be affected, but the border area assignment console and head assignment console along with much of the page attributes console will no longer work until you refresh your page-template layout files.  Here are the steps to accomplish that:

1. Use Edit File to examine the border area and head assignment:Look for the section that looks like this:

$query = "SELECT title FROM " . BWB_TABLE_PREFIX . "page_titles WHERE page_name='mypage'";
    $result = $bwb_dbh->query($query);
    if ($row = $result->fetch(PDO::FETCH_ASSOC))
    {
        $title = $row["title"];
        $title = stripslashes($title);
    }
    else
    {
        $query = "SELECT title FROM " . BWB_TABLE_PREFIX . "page_titles WHERE page_name='_default_'";
        $result = $bwb_dbh->query($query);
        $row = $result->fetch(PDO::FETCH_ASSOC);
        $title = $row["title"];
        $title = stripslashes($title);
    }
    
    $query = "SELECT head_content FROM " . BWB_TABLE_PREFIX . "head WHERE head_name='head_mypage'";
    $result = $bwb_dbh->query($query);
    $row = $result->fetch(PDO::FETCH_ASSOC);
    $head = $row["head_content"];
    $head = stripslashes($head);
    
    $query = "SELECT page_content FROM " . BWB_TABLE_PREFIX . "page_data_special WHERE page_name='top'";
    $result = $bwb_dbh->query($query);
    $row = $result->fetch(PDO::FETCH_ASSOC);
    $top = $row["page_content"];
    $top= stripslashes($top);
    
    $query = "SELECT page_content FROM " . BWB_TABLE_PREFIX . "page_data_special WHERE page_name='bottom'";
    $result = $bwb_dbh->query($query);
    $row = $result->fetch(PDO::FETCH_ASSOC);
    $bottom = $row["page_content"];
    $bottom= stripslashes($bottom);
    
    $query = "SELECT page_content FROM " . BWB_TABLE_PREFIX . "page_data_special WHERE page_name='left'";
    $result = $bwb_dbh->query($query);
    $row = $result->fetch(PDO::FETCH_ASSOC);
    $left = $row["page_content"];
    $left= stripslashes($left);
    
    $query = "SELECT page_content FROM " . BWB_TABLE_PREFIX . "page_data_special WHERE page_name='right'";
    $result = $bwb_dbh->query($query);
    $row = $result->fetch(PDO::FETCH_ASSOC);
    $right = $row["page_content"];
    $right= stripslashes($right);
    
    $query = "SELECT page_content FROM " . BWB_TABLE_PREFIX . "page_data_special WHERE page_name='header'";
    $result = $bwb_dbh->query($query);
    $row = $result->fetch(PDO::FETCH_ASSOC);
    $header = $row["page_content"];
    $header= stripslashes($header);

    $query = "SELECT page_content FROM " . BWB_TABLE_PREFIX . "page_data_special WHERE page_name='footer_mypage'";
    $result = $bwb_dbh->query($query);
    $row = $result->fetch(PDO::FETCH_ASSOC);
    $footer = $row["page_content"];
    $footer= stripslashes($footer);

Take note of any area that is not of the standard head, header, top, left, right, bottom or footer assignments.  You will need to re-assign these areas.

2. Next, got to CONTENT/Manage Border Areas/Manage Custom Border Areas, and assign the areas as noted.  Then go to STYLES & HEAD CONTENT/Manage Head Code and assign the appropriate head as noted.
3. Go to PAGE MANAGEMENT/Manage Page Attributes and assign the correct Layout Template to your pages.  If your pages use table structures, be sure to check the Use Page Table Structures checkbox.
4. Go to PAGE MANAGEMENT/Copy or Rename Pages and copy each page to itself by cilcking the Discard old page template and create new checkbox and clicking the Copy/Rename button.
5. Test your pages to see how the work.  If there were any pages that have inserted plugin code in the page-template layout file, you will need to go to PAGE MANAGEMENT/Install Prugin Into Page and re-apply the plugin.  You may also need to remove any duplicate plugin code from the content by using the page editor and the border areas edtitor.

---

 

Manual Update

Files:

Extract the files to a folder on your hard drive and FTP all of these files in their perspective subfolders EXCEPT the SQL folder to web root-level of your website hosting.

 

Database:

From the main menu, click on Manage Users and Site Options, then click on Upgrade Table Structures.  Enter the password for the admin user account to the Breeze Website Builder™ and click Submit to log into the database upgrade console.  Copy and paste the contents of upgrade.sql into the window and click Submit.

 

---

 

Updating Legacy Versions

 

Upgrading from 3.6.0.7 to 4.0.0

You will need to copy your credentials from the old database connection file to the new one.  To do this look for the followings lines in connect/db_connection.php:

$hostname = "localhost";
$bwb_database = "cpanelid_cms";
$db_username = "cpanelid_website";
$db_password = "xxxxx";

and paste these over the corresponding lines in connect/db_connect.php.  Do not delete db_connection.php at this point.  Your website will continue to run using the db_connection.php while the Breeze Website Builder itself uses the new db_connect.php.  New pages that you create will be created using the updated page layout templates which run off of the new db_connect.php.

You may also want to refresh your pages to the new template layouts if your server is going to be upgraded to PHP 5.5.  To do this, simply copy your page to itself in the Breeze Website Builder™ with the Discard old page template and create new checkbox checked.  Note: If your page was created using a plugin, many of these plugins embed PHP into the file.  Using this technique will not carry over the plugin PHP. You will need to instead create a new page using the same plugin, then copy your content out of the original page and copy it into the new page.  Then simply rename your pages to complete the process.

 

Upgrading from 2.1.3 to 2.2.0:

Upgrading from older versions to this version requires manual editing of the db_connection.php and db_connection_2.php files in the connect folder.  To upgrade, change the db_connection.php file from:

$hostname = "localhost";
$database = "cpaneluserid_cms";
$db_username = "cpaneluserid_website";
$db_password = "pppppppp";
$link = mysql_pconnect($hostname, $db_username, $db_password) or die(mysql_error());

 if (!$link)
 {
     echo "We are sorry, we not able to connect right now.  Please try again later.";
        exit;
 }
    
    mysql_select_db($database);

to:

$hostname = "localhost";
$bwb_database = "cpaneluserid_cms";
$db_username = "cpaneluserid_website";
$db_password = "pppppppp";
$bwb_link = mysql_pconnect($hostname, $db_username, $db_password) or die(mysql_error());

 if (!$bwb_link)
 {
     echo "We are sorry, we not able to connect right now.  Please try again later.";
        exit;
 }
    
    mysql_select_db($bwb_database);

---------------------------------------------------------------------------------

Optionally, you may want to change db_connection_2.php if you are planning on using the Zen Cart Art Gallery plugin from:

$hostname = "localhost";
$database = "cpaneluserid_zc1";
$db_username = "cpaneluserid_zc1";
$db_password = "pppppppp";
$link = mysql_pconnect($hostname, $db_username, $db_password) or die(mysql_error());

 if (!$link)
 {
     echo "We are sorry, we not able to connect right now.  Please try again later.";
        exit;
 }
    
    mysql_select_db($database);

to:

$hostname = "localhost";
$zen_database = "cpaneluserid_zc1";
$db_username = "cpaneluserid_zc1";
$db_password = "pppppppp";
$zen_link = mysql_pconnect($hostname, $db_username, $db_password) or die(mysql_error());

 if (!$zen_link)
 {
     echo "We are sorry, we not able to connect right now.  Please try again later.";
        exit;
 }
    
    mysql_select_db($zen_database);

 

Upgrading from 1.3.02 to 2.0.0:

Edit connect/config.php and set BWB_TABLE_PREFIX = '';

The new menu generator uses a new file which will not be referenced in your old pages, thus you will see an error where your menus would normally be.  To fix this, you need to refresh your webpage template files.  Fortunately, this is easy to do and usually only takes about 1/2 hour. First, take note of which heads are assigned to which pages.  To do this, select Manage Head Code from the main menu, then select Manage Head Content. An easy way to note the settings is to take a screenshot of the assignments.  You will be re-assigning the heads to your pages after you are done upgrading your page template files.

Also take note of which border areas are assigned to which pages and if there are any  layouts used that are not the default layout. To do this, select Manage Border Areas from the main menu, then select Manage Custom Border Areas. An easy way to note the settings is to take a screenshot of the assignments.  You will need to set to site default layout to the same as the page you are about to refresh.  Quite often this step will not be required as many sites do not use more than one layout.  If your site does use different layouts, then this is done in Change Site Options under Manage Users and Site Options.  Select the template for the page(s) you want to upgrade which are different from the rest, and click Submit.  Then update your page template files as described below.  You will need to repeat this for every layout variation used on your site.  After you are done with the pages of different layout, you will need to go back into the site options one more time to set the layout back to your website default.

Click on Copy or Rename Pages from the main menu.  Then, for each page do the following: Make sure that the Copy option is checked.  (It is by default.)  Check the checkbox Discard old page template and create new.  Enter the name of the page your are copying into the new page name box. (You are going to copy the page onto itself, but while doing so, you are discarding the old template and building a new one.)  Then click the Copy/Rename button.  Do this for all of the pages except those that have calendar, events or shopping cart plugins installed.  Those pages will need to be recreated using Create Page because the copy function will overwrite the embedded PHP code for the plugin.

If you need to upgrade without any down time, contact me and I will provide instructions.