MySource Matrix Developer

MySource Matrix Developer Newsletter Issue 59
Friday 27th January 2006

covers versions 3.4.8 stable, 3.6.4 stable, 3.7.0 development

News

Third DB Connection

MySource Matrix 3.8 will use a third database connection in order to support replicated databases. The default connection will now be read-only and used by most frontend pages. The two connections will be used for updating the database, one for updates within transactions and one for immediate updates.

If you do not require database replication, it is suggest that you set the DB2 DSN to be the same as DB and use your second connection string for DB3. For example, if your connection strings currently look like this:

define('SQ_CONF_DB_DSN', 'pgsql://developers@db/matrix');
define('SQ_CONF_DB2_DSN', 'pgsql://developers_secondary@db/matrix');

Change them to look like this:

define('SQ_CONF_DB_DSN', 'pgsql://developers@db/matrix');
define('SQ_CONF_DB2_DSN', 'pgsql://developers@db/matrix');
define('SQ_CONF_DB3_DSN', 'pgsql://developers_secondary@db/matrix');

Harvest Control List To Be Removed

The HCL Page asset hasn't worked in a long time (it appears) and yet nobody has ever reported a problem with it. That seems to indicate that nobody has been using it. Instead of a complete rewrite to get it working again, the HCL Page is being removed as of 3.8.0 RC1 to ensure nobody tries to use the broken asset type. It will be rewritten and re-added in a future release if required.

Install Script Upgrades Not In Newsletter

I will no longer be including the "run step_02.php", "run_step03.php" or "run compile_locale.php" upgrade steps in the Upgrading section of this newsletter. Assume that you should always run these three install scripts for all upgrades, including weekly developer upgrades.

New Features

Triggers Executed Under Firing Asset

Added to: 3.7.0 development

Trigger actions that allowed you to select an asset using an asset finder can now be set to dynamically set the asset to the one that fired the event. For example, the create asset trigger action can now be set to create the new asset under the one that fired the event, such as a status change.

Planned Development

Roles System

To be added to : 3.7.0 development
Estimated start date: already in development
Estimated end date: 3.7.0 development

Upgrading

3.7.0 Development

Run step_02.php: No
Run step_03.php: No
Run compile_locale.php: No

No additional queries are required for upgrades.

Additional comments
Add the third database connection string:

- edit /path/to/matrix/data/private/conf/main.inc
- find the line defining SQ_CONF_DB2_DSN
- rename SQ_CONF_DB2_DSN to SQ_CONF_DB3_DSN
- find the line defining SQ_CONF_DB_DSN
- copy and paste the line
- change SQ_CONF_DB_DSN on the new line to SQ_CONF_DB2_DSN
- save the file

See the news item in this newsletter for before and after samples of these connection strings.

New Bugs Added To Bug Tracker

Notes:

Bug #1084 (Asset listing fails to list public items for logged in users) was submitted by James Hurst on the 13th of Jan 2006 but was marked as Can Not Replicate after a developer could not replicate the problem and the poster had not replied to comments.

Bug #1101 (Harvest Control List problems - XML_Tree 2.0, schemas with illegal element names) was submitted by Luke but was marked as Will Not Fix as the HCL Page is to be removed.

Bug #1102 (Harvest Control List - if metadata field does not contain a dot, first character is dropped) was submitted by Luke but was marked as Will Not Fix as the HCL Page is to be removed.

Bug #1103 (Listing Engine: Inline Asset selection JS printed when not required) was submitted by Tom but was marked as not being a bug as it has already been fixed and just required a code update.

New Feature Requests Added To Bug Tracker

Bugs Fixed In The Bug Tracker