(No, really, make a full backup of everything)

Always backup your existing website files and database prior to attempting an upgrade. Backing up your database can be done using your web host's database management tool which is often available through their control panel,  'phpMyAdmin' is typically available. Some hosts offer more advanced or alternative backup methods via their control panels, speak with your host if you have any questions about performing backups of your site or databases.

Important! If you are upgrading from a version of OR v2 prior to v2.1, make sure your existing listing fields setup includes a 'type' field (all lowercase) and that all of your listings have been edited and assigned to one of the types you have defined, such as commercial, residential, land, and etc. Failure to do this will result in the upgrade script being unable to convert your listings to use the new Property Class system which replaced property types after OR v2.1

Please note that templates and add-ons created for OR v2.x will not work or work completely with OR v3 unless or until they are modified. To prevent any unnecessary problems occurring during the upgrade process we suggest that all previous OR v2.x add-ons are removed before proceeding.

Obtaining the upgrade

  1. Download the latest official Open-Realty release. 

If you do not already have a copy available to download in your customer area at Transparent Technologies, visit to order a license.

Preparing for the upgrade

  1. From the OR v2.x Site Configuration, make sure your Administration template is set to 'OR_small' and the Site Template is set to 'lazuli'.

  1. Delete the OR v2.x /admin/ folder. This will be replaced by the upgrade.

  1. Access your OR v2.x /template/ folder and rename or remove the following template folders if present:

  1. Access your OR v2.x. /addons/ folder and delete any sub-folders. OR v2.x add-ons are not compatible with OR v3 and should be removed prior to upgrading. You may restore any add-ons later after you can obtain upgraded versions that work with OR v3.

Extract and upload the upgrade

  1. Extract the OR v3 .ZIP file you downloaded to your local computer and upload the OR v3 program files to your web hosting account, overwriting your previous OR program files.

Running the installer

  1. Using your web browser, access the OR installer:, replacing INSTALLPATH with the sub-folder OR is installed in (if applicable).

Installer URL syntax:

Replace '' with your actual domain name and INSTALLPATH with the sub-folder name (if applicable) where OR was installed.

For example, if you installed OR to a hosting account that uses the domain name: '' and placed the files in a sub-folder of the document root named "open-realty" you would use "open-realty" as the INSTALLPATH and navigate to:

If you installed OR to the document root of your hosting account, and not a sub-folder, you would omit the INSTALLPATH entirely. This is the most common installation location.

  1. Read the license agreement and click the "Agree" button to continue.

  1. Select the default language for your site and click submit. NOTE:English is the only language file that is regularly maintained by the Development team. If you have difficulty installing due to blank pages in another language it is likely due to an incomplete or missing lang file for your selected language. To fix that you can open the /install/lang/en/ folder and replace the file from your configured lang folder with the one from the 'en' folder.

  1. The next screen verifies the file permissions. If it finds any permission problems correct them and refresh the page. When all permissions are correct; Click "Click to Continue Installation".

  1. You now need to select the type of installation you are performing. You should be selecting "Upgrade from Open-Realty 2.x (Beta 1 or higher)

  1. Verify all of your database and configuration information is correct. This information is automatically populated from the existing common.php file. Click next.

  1. This step updates the common.php file, which stores the database configuration information for Open-Realty® to use. Click "Continue to setup the database."

  1. This step will create and populate the Open-Realty database tables.

  1. Click "Click here to configure your installation". This will take you to the OR administration area login page. Your username and password information will be unchanged from the prior version you had installed. Log in as the administrator: 'admin' or an account with admin privileges, and you will be asked to enter and save your OR v3 license key.

  1. You must delete the /install folder or rename /install/index.php before the public site will be accessible.

  1. Make sure you have any necessary CRON jobs setup as described in Automating Tasks

  1. You may wish to review the blog post: Upgrading Open-Realty® 2.x Templates For Open-Realty® 3.x for information about upgrading old OR v2.x templates to work with OR v3.

Congratulations, your Open-Realty v3 database and core software upgrade is complete!

Related Topics:
Upgrading from existing v3.x installation
Upgrading/Updating Templates
Creating a public site Template
Troubleshooting templates
Featured/Random Template Tags
Search Page Template Tags
Single Use Hooks