MySource Matrix Resources

Content Tools

Main Content

Upgrading MySource Matrix from v3.12.2 to v3.12.3

Introduction

This guide will help you upgrade an existing MySource Matrix version 3.12.2 installation to version 3.12.3.

This upgrade requires you to have access to:

  • update the MySource Matrix source code
  • upgrade MySource Matrix configuration files

This guide assumes that your MySource Matrix installation is located at /home/websites/mysource_matrix. Please change any commands to the appropriate location if your installation is located elsewhere.

If your system contains the commercial or premium modules, please contact Squiz for updated versions of the modules before proceeding with the upgrade.

The modules must be upgraded at the same time as the core system.

Backup

Before starting any upgrade, always backup your MySource Matrix installation. See the MySource Matrix backup management guide for information on how to backup your MySource Matrix system.

Getting the New Source Code

The first thing you need to do is update the MySource Matrix source code. You can find out how to download the latest stable version of MySource Matrix on the installation page.

Once you have downloaded the source code, you need replace the existing code with the newer version. This will not reset any configuration options or remove any content from your system.

These steps assume MySource Matrix is installed at /home/websites/mysource_matrix and that a tar.gz archive with the new source code exists within /home/websites 
$ cd /home/websites
$ mv mysource_matrix mysource_matrix_3-12-2
$ tar -xzvf new_source.tar.gz
$ cd mysource_matrix
$ cp -r /home/websites/mysource_matrix_3-12-2/data .

Full System Upgrade

First, the system's installation scripts should be run to ensure the asset types and language translations are up to date.

$ php install/step_02.php /home/websites/mysource_matrix
$ php install/step_03.php /home/websites/mysource_matrix
$ php install/compile_locale.php /home/websites/mysource_matrix

Fix Data Directories

There was a bug found in the data directory upgrade script, used between version 3.10 and 3.12, that caused some data files to be given the wrong data path (essentially, the new hash part of the path was being calculated incorrectly). You will need to run the upgrade script with the --fix-lookups switch to re-generate the correct data paths. Only run the data dir upgrade again if your system is suffering from this specific problem. Running this option on a valid system may invalidate some file URLs.

$ php scripts/upgrade_data_dirs.php -s /home/websites/mysource_matrix --fix-lookups

Deny Public Read Access to Form Submissions

It is strongly recommended that you run the following query to deny public read access to submissions created by Custom Form assets. Submissions created following the upgrade will also have read permission denied to the public.

This query should be run in the appropriate command-line interface (psql for PostgreSQL systems, sqlplus for Oracle systems).

UPDATE sq_ast_perm SET granted = 0
    WHERE assetid IN (
        SELECT assetid FROM sq_ast
            WHERE type_code = 'form_submission'
    ) AND userid = (
        SELECT assetid FROM sq_ast
            WHERE type_code = 'public_user'
    ) AND granted = 1;

Upgrade Complete

Your upgrade to MySource Matrix version 3.12.3 should now be complete.