Site Search
Content Tools
Main Content
MySource Matrix Developer Newsletter Issue 76
Friday 26th May 2006
covers versions 3.6.8 stable, 3.8.2 stable, 3.9.0 development
News
No News is Good News
There is no general MySource Matrix developer news this week.
New Features
Foreign Key System Integrity Script
Added to: 3.9.0 development
A new system integrity script has been added to the development version to report on the integrity of foreign keys within a MySource Matrix database. This script defines relations between certain key fields (for instance, the assetid field in the sq_ast table) and fields in other tables. If it finds a field in any table with the same name as one defined as related, it will report any values in that table that does not exist in the key table.
Please note that this script does not attempt to fix the integrity of the database, rather it reports on said invalid foreign keys, as well as the number of invalid rows. This information could then be used by the user to write an SQL query to remove the invalid rows if desired.
New Options for Unknown Keywords
Added to: 3.8.3 stable, 3.9.0 development
A new option has been added to the System Configuration screen that controls what happens to keywords on the frontend when they do not exist and the 'Disable Keywords' bodycopy setting is not set. This option gives System Administrators a choice between leaving the keyword intact, or replacing the keyword with an empty string ('').
This switch is represented in code by the SQ_CONF_HIDE_UNKNOWN_KEYWORDS constant. Note that global keywords - those starting with "%globals_" - will still be blanked out if the keyword specified does not exist, regardless of this setting.
Planned Development
No new generic features are currently scheduled for development.
Upgrading
3.9.0 Development
Additional queries:
No additional queries are required for upgrades.Additional comments:
No additional upgrade steps are required.
New Bugs Added To Bug Tracker
| Bug ID | 3.6.x | 3.8.x | Dev | Description |
| 1376 | N | Y | Y | Online Poll - Past Questions List Format bodycopy - make asset keywords available |
| 1377 | N | Y | Y | Online Poll - questions appear to be independant assets and so they cannot have their own status |
| 1378 | N | Y | Y | Black, undecorated links = poor usability |
| 1380 | N | N | Y | Email format attribute on send email action broken |
| 1383 | N | N | Y | Pagination on Pending Account validation screen |
| 1385 | N | N | Y | Email form field does not allow + (plus) sign |
| 1387 | N | Y | N | Word Docs having wrong content type in http headers |
| 1389 | Y | N | N | Backend users sent to login screen after changing status in Simple Edit mode (not confirmed) |
Notes:
Bug #1374 (First Field in Remote contented form Post Value missing) was submitted by Karl Davidson but was marked as Can Not Replicate after two developers were unable to reproduce the bug.
Bug #1375 (Online Poll - Select Keyword drop down list - only show keywords relevant to the current bodycopy) was submitted by Deborah Braithwaite but was marked as a duplicate of bug #1357 (Online Poll Keywords lists are same for all formats), which was fixed in 3.8 branch or development versions. The bug has been closed.
Bug #1384 (SQ_DESIGN_NAME remembered if logged in) was submitted by Stewart Heckenberg but was marked as not being a bug as the functionality already exists in the SQ_DESIGN_NAME request variable in MySource Matrix.
Bug #1388 (Creating child under Remote Content pages) was submitted by choy0g but was marked as Can Not Replicate after it could not be reproduced by a developer in either the 3.8 branch or development versions.
New Feature Requests Added To Bug Tracker
| Bug ID | Description |
| 1378 | Black, undecorated links = poor usability |
| 1379 | FR: Asset Builder forms should be customisable |
| 1381 | Script to purge internal messages |
| 1382 | Prefix Asset Lineage with Index page name |
| 1386 | Remap Manager's detail screen needs pagination |
| 1390 | Send 500 Internal Server Error when blank response is being sent |
Bugs Fixed In The Bug Tracker
| Bug ID | 3.6.x | 3.8.x | Dev | Description |
| 1376 | N | Y | Y | Online Poll - Past Questions List Format bodycopy - make asset keywords available |
| 1377 | N | Y | Y | Online Poll - questions appear to be independant assets and so they cannot have their own status |
| 1378 | N | Y | Y | Black, undecorated links = poor usability |
| 1380 | N | N | Y | Email format attribute on send email action broken |
| 1383 | N | N | Y | Pagination on Pending Account validation screen |
| 1385 | N | N | Y | Email form field does not allow + (plus) sign |
| 1387 | N | Y | N | Word Docs having wrong content type in http headers |
View Comments
There are currently no comments for this newsletter.