MySource Matrix Developer

MySource Matrix Developer Newsletter Issue 17
Friday 1st April 2005

covers versions 3.4.0 stable, 3.5.0 development

News

3.4.1 Stable Release Next Week

A bug fix release of MySource Matrix will be released on Monday the 4th of April. MySource Matrix 3.4.1 will not contain any new features. There will also be no beta release this month.

4 Step Installation

The new backend translation changes have introduced a fourth step to the CLI installation for the development version of MySource Matrix. Step 4 pre-processes and caches the XML edit interface files for each install language to ensure backend screen loading times to not increase due to the additional overhead of string translations.

Step4 does take quite a while to run, especially for system with a large number of asset types installed, but it only needs to be run when editing interfaces have changed or new assets are installed.

New Features

Asset Map Support For Java 1.5

Added to: 3.4.0 stable

The changes made to the Java asset map last week to support JVM 1.5 on the current development version of MySource Matrix have now been made to 3.4.0 stable. The next stable release on Monday will contain these changes.

Backend Translation (Stage One)

Added to: 3.5.0 development

The first stage of the backend translation project has been completed. This stage has allowed for the translation of the XML editing interfaces, although no translations (other than the default English) have been completed. Over the new week, error messages and all other strings within MySource Matrix will be converted to use the new translation system.

Planned Development

Search Logging

To be added to : 3.5.0
Estimated start date: already in development
Estimated end date : 15th Apr 2005

Oracle Support

To be added to : 3.5.0
Estimated start date: already in development
Estimated end date : 15th Apr 2005

Backend Translation (stage 2)

To be added to : 3.5.0 development
Estimated start date: 4th Apr 2005
Estimated end date : 15th Apr 2005

Upgrading

3.5.0 Development

Run step_02.php: no Run step_03.php: yes Run step_04.php: yes

Additional queries:

ALTER TABLE sq_trig_hash DROP COLUMN active;

ALTER TABLE sq_trig ADD COLUMN t_name VARCHAR(100); UPDATE sq_trig SET t_name = name;
ALTER TABLE sq_trig ALTER COLUMN t_name SET NOT NULL; ALTER TABLE sq_trig DROP COLUMN name;
ALTER TABLE sq_trig RENAME COLUMN t_name TO name;

ALTER TABLE sq_trig ADD COLUMN t_description VARCHAR(255);
UPDATE sq_trig SET t_description = description;
ALTER TABLE sq_trig DROP COLUMN description;
ALTER TABLE sq_trig RENAME COLUMN t_description TO description;

ALTER TABLE sq_rb_trig ADD COLUMN t_name VARCHAR(100);
UPDATE sq_rb_trig SET t_name = name;
ALTER TABLE sq_rb_trig ALTER COLUMN t_name SET NOT NULL;
ALTER TABLE sq_rb_trig DROP COLUMN name;
ALTER TABLE sq_rb_trig RENAME COLUMN t_name TO name;

ALTER TABLE sq_rb_trig ADD COLUMN t_description VARCHAR(255);
UPDATE sq_rb_trig SET t_description = description;
ALTER TABLE sq_rb_trig DROP COLUMN description;
ALTER TABLE sq_rb_trig RENAME COLUMN t_description TO description;

ALTER TABLE sq_trig_hash ADD COLUMN t_event VARCHAR(100);
UPDATE sq_trig_hash SET t_event = event;
ALTER TABLE sq_trig_hash ALTER COLUMN t_event SET NOT NULL;
ALTER TABLE sq_trig_hash ALTER COLUMN t_event SET DEFAULT '';
ALTER TABLE sq_trig_hash DROP COLUMN event;
ALTER TABLE sq_trig_hash RENAME COLUMN t_event TO event;

ALTER TABLE sq_trig_hash ADD COLUMN t_assetid VARCHAR(15);
UPDATE sq_trig_hash SET t_assetid = assetid;
ALTER TABLE sq_trig_hash ALTER COLUMN t_assetid SET NOT NULL;
ALTER TABLE sq_trig_hash ALTER COLUMN t_assetid SET DEFAULT '';
ALTER TABLE sq_trig_hash DROP COLUMN assetid;
ALTER TABLE sq_trig_hash RENAME COLUMN t_assetid TO assetid;

ALTER TABLE sq_trig_hash ADD COLUMN t_parentid VARCHAR(15);
UPDATE sq_trig_hash SET t_parentid = parentid;
ALTER TABLE sq_trig_hash ALTER COLUMN t_parentid SET NOT NULL;
ALTER TABLE sq_trig_hash ALTER COLUMN t_parentid SET DEFAULT '';
ALTER TABLE sq_trig_hash DROP COLUMN parentid;
ALTER TABLE sq_trig_hash RENAME COLUMN t_parentid TO parentid;

ALTER TABLE sq_trig_hash ADD COLUMN t_childid VARCHAR(15);
UPDATE sq_trig_hash SET t_childid = childid;
ALTER TABLE sq_trig_hash ALTER COLUMN t_childid SET NOT NULL;
ALTER TABLE sq_trig_hash ALTER COLUMN t_childid SET DEFAULT '';
ALTER TABLE sq_trig_hash DROP COLUMN childid;
ALTER TABLE sq_trig_hash RENAME COLUMN t_childid TO childid;

Additional comments: Once you have run step 3 of the install, ensure the following entry has been added to your data/private/conf/main.inc file (manually add the line if it has not):

define('SQ_CONF_DEFAULT_BACKEND_LOCALE', 'en_AU');

New Bugs Added To Bug Tracker

New Feature Requests Added To Bug Tracker

No new feature requests were added the the MySource Matrix bug tracker.

Bugs Fixed In The Bug Tracker

View Comments