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 | *'''If you use database tables''', be aware that the schema (Column names that must be in a table) varies between 3.5.x versions and 3.7.y versions. | ||
**The updating | **The updating database table features in MX will only work if all the columns named in each such 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 SQL provided for adding the columns added at particular versions. | **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. | ||
**At 3.6.0 the SQL was provided as a separate attachment to the release announcement (UpdateMYSQL-b3076.zip) | ***At 3.6.0 the SQL was provided as a separate attachment to the release announcement (UpdateMYSQL-b3076.zip) | ||
**At 3.7.0 the SQL was provided as part of the main zip (AlterSQLTables3098.sql) | ***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). | ***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 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. | *'''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. | ||