5,838
edits
Updating MX to new version: Difference between revisions
m
→If you use a 3.5.x release
| Line 146: | Line 146: | ||
But there are actions you need to do depending on what features you use in MX: | 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. | *'''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. | **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 to see the | **Look at individual release announcements for both 3.6.0 and 3.7.0, to see the SQL provided for adding the columns added at particular versions. | ||
*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.6.0 the SQL was provided as a separate attachment to the release announcement (UpdateMYSQL-b3076.zip) | ||
*If you use commas to separate integer and decimal parts of real numbers, then | **At 3.7.0 the SQL was provided as part of the main zip (AlterSQLTables3098.sql) | ||
**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 = | = Recommended Actions when Updating = | ||