MySource Matrix Developer

MySource Matrix Developer Newsletter Issue 183
Friday 20th June 2008

covers versions 3.16.9 stable, 3.18.2 stable, 3.19.0 development

News

No News Is Good News

There is no general MySource Matrix developer news this week.

New Features

Prevent Cascade of Workflow Schemas, Metadata Schemas, and Permissions

Added to: 3.19.0 development

This development will add the ability to designate certain permissions, workflow schemas and metadata schemas with the ability to not cascade to lower assets, regardless of the normal asset-level "Cascade" setting. When this option is selected, new children of the asset (whether created or linked/moved) will not have those settings cascaded to them.

(Workflow schemas and permissions will still cascade to their dependent children, to be consistent with current practices of adding these with cascading to existing assets turned off.)

This development is also expected to be added to 3.18.3 stable next week.

Planned Development

Remove Metadata Schema Trigger Action

To be added to : 3.19.0 development, 3.18.3 stable
Estimated start date: already in development
Estimated end date: soon

Upgrading

3.19.0 Development

Additional queries:

Additional comments: 

• Disable rollback on your system. If you need help with this, please consult the Rollback Management Guide on the MySource Matrix web site.
• Run the following queries on your database:

  DROP VIEW sq_vw_ast_perm;
  
  DROP VIEW sq_rb_vw_ast_perm;
  
  ALTER TABLE sq_ast_perm ADD COLUMN cascades CHAR(1) NOT NULL DEFAULT '1';
  
  ALTER TABLE sq_ast_mdata ADD COLUMN cascades CHAR(1) NOT NULL DEFAULT '1';
  
  ALTER TABLE sq_ast_wflow ADD COLUMN cascades CHAR(1) NOT NULL DEFAULT '1';
  
  ALTER TABLE sq_rb_ast_perm ADD COLUMN cascades CHAR(1) NOT NULL DEFAULT '1';
  
  ALTER TABLE sq_rb_ast_mdata ADD COLUMN cascades CHAR(1) NOT NULL DEFAULT '1';
  
  ALTER TABLE sq_rb_ast_wflow ADD COLUMN cascades CHAR(1) NOT NULL DEFAULT '1';

  (NB: The dropping of views is required since views cannot be modified to change the number of columns they contain, at least in PostgreSQL. They will be regenerated later.)
• Enable rollback. Again, consult the Rollback Management Guide if you don't know how to do this.
• Run step_02.php. This will re-create the dropped views, and also the new triggers for these tables so they reflect the new column.
• Continue with your normal upgrade procedure.

New Bugs Added To Bug Tracker

Notes:

Bug #3073 ("errors when accessing Matrix from different networks", submitted June 10th by gmutale) was marked Not a Bug. MySource Matrix is set by default to end sessions where the IP changes for security reasons, unless "Allow IP changes" is turned on.

Bug #3075 ("Problems with directory cleanup when Bulkmail job placed Under Construction", submitted June 11th by Melanie Rooney) was marked Can Not Replicate. Bulkmail Jobs cannot be changed to Under Construction while they are in the job queue. Their status is automatically changed to Under Construction after completion, to stop it from running again.

Bug #3090 ("Matrix sees _ and - as wildcards in web paths", submitted June 18th by Avi Miller) was closed as it was a duplicate of bug #2980 ("Underscore "_" and Dash "-" in webpaths treated as same character", submitted April 22nd by Owen Windsor), which was already fixed in 3.16.8 and 3.18.1. The issue related to underscores not being properly escaped in the query to determine whether a web path was being used, resulting in the underscore acting as an SQL single character wildcard.

New Feature Requests Added To Bug Tracker

Bugs Fixed In The Bug Tracker

View Comments