Updating MX to new version: Difference between revisions

From Cumulus Wiki
Jump to navigationJump to search
m
 
But there are actions you need to do depending on what features you use in MX:
*'''If you use database tables''', be aware that the schema (Column names that must be in a table) varies between different versions in this range.
**The updating feature in MX will only work if all the columns named in that update already exist in the database table it is trying to update.
**Look at individual release announcements for both 3.6.0 and 3.7.0, to see the toolsSQL provided for adding the columns added at particular versions.
**At 3.6.0 the SQL was provided as a separate attachment to the release announcement (UpdateMYSQL-b3076.zip)
*If you have your own customised web pages, then there are changes to web tags that might lead to you needing to edit your web pages.
**At 3.7.0 the SQL was provided as part of the main zip (AlterSQLTables3098.sql)
*If you use commas to separate integer and decimal parts of real numbers, then these releases give you useful extra functionality that will let you do more with scripts, so you need to consider different ways of using MX.
**In both cases, the SQL provided assumes you are using the default names for database tables, it does not read [[Cumulus.ini]] to see whether you have selected different names for the tables (unlike ExportMySQL.exe and standard CumulusMX.exe uploads which check what tables names you have selected for updates).
*'''If you have your own customised web pages''', then there are changes to web tags that might lead to you needing to edit your web pages.
*'''If you use commas to separate integer and decimal parts of real numbers''', then various releases from 3.6.0 to 3.7.0 add "rc=y" to various web tags, that option will replace the decimal commas you use by decimal points that are required for some script languages (like the JavaScript used by HighCharts), and that makes it easier if you want to customise your web site.
 
= Recommended Actions when Updating =
5,838

edits

Navigation menu