MySource Matrix Resources

MySource Matrix has been superseded by Squiz Matrix. This site will remain available for archival purposes only; it is not intended as a current source of Matrix information. For all the latest on Matrix, including documentation and release information, visit the Squiz Matrix site.

Content Tools

Main Content

Upgrading MySource Matrix from v3.28.2 to v3.28.3

Introduction

This guide will help you upgrade an existing MySource Matrix version 3.28.2 installation to version 3.28.3.

This upgrade requires you to have access to:

  • update the MySource Matrix source code
  • edit the 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.

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.

Disable Rollback

At this point, you need to ensure that rollback is disabled before continuing. For help with disabling rollback, see the MySource Matrix rollback management guide.

Get the New Source Code

Now, you need to 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 to 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-28-2
$ tar -xzvf new_source.tar.gz
$ cd mysource_matrix
$ cp -pr /home/websites/mysource_matrix_3-28-2/data .
$ cp -pr /home/websites/mysource_matrix_3-28-2/core/lib/DAL/Oven core/lib/DAL
$ cp -pr /home/websites/mysource_matrix_3-28-2/core/lib/DAL/QueryStore core/lib/DAL

Queries for Creating/Deleting Links for LDAP Users

The following queries are required to support creating and deleting links for LDAP users (Bug fix #4522).

Please run the following queries on your Matrix database before running step_02.php. These queries are applicable for both PostGres and Oracle databases.

DROP VIEW sq_vw_ast_perm;

DROP VIEW sq_vw_ast_role;

DROP VIEW sq_vw_ast_lnk_minor;

DROP VIEW sq_vw_ast_lnk_major;

DROP VIEW sq_rb_vw_ast_perm;

DROP VIEW sq_rb_vw_ast_role;

DROP VIEW sq_rb_vw_ast_lnk_minor;

DROP VIEW sq_rb_vw_ast_lnk_major;

ALTER TABLE sq_shdw_ast_lnk ADD locked CHAR(1) DEFAULT '0' NOT NULL;

ALTER TABLE sq_rb_shdw_ast_lnk ADD locked CHAR(1) DEFAULT '0' NOT NULL;

Full System Upgrade

Now, 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/compile_locale.php /home/websites/mysource_matrix
$ php install/step_03.php /home/websites/mysource_matrix
$ php install/compile_locale.php /home/websites/mysource_matrix

Re-enable Rollback

If you needed to disable rollback at the beginning of this upgrade, you may now re-enable it. For help with enabling rollback, see the MySource Matrix rollback management guide.

Upgrade Complete

The upgrade of your MySource Matrix system from version 3.28.2 to 3.28.3 is now complete.