5,838
edits
Updating MX to new version: Difference between revisions
Updating MX to new version (view source)
Revision as of 15:01, 21 January 2021
, 15:01, 21 January 2021→If using a 3.5.x release
| Line 227: | Line 227: | ||
====If using a 3.5.x release ==== | ====If using a 3.5.x release ==== | ||
My advice is to update directly to 3.7.0 or any subsequent 3.7.x release available at | My advice is to update directly to 3.7.0 or any subsequent 3.7.x release available at [https://github.com/cumulusmx/CumulusMX/releases]. | ||
You should skip the intermediate releases because several 3.6.y releases have bugs in them, and you want to avoid those problems (the bugs vary in severity between mistakes in calculations done by MX to particular functionality not working). | You should skip the intermediate releases because several 3.6.y releases have bugs in them, and you want to avoid those problems (the bugs vary in severity between mistakes in calculations done by MX to particular functionality not working). | ||
| Line 236: | Line 236: | ||
**The updating database table features in MX will only work if all the columns named in each such upload update ''already exist'' in the database table it is trying to update. | **The updating database table features in MX will only work if all the columns named in each such upload 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 (read | ***At 3.6.0 the SQL was provided as a separate attachment to the release announcement (read [https://cumulus.hosiene.co.uk/viewtopic.php?p=142085#p142085 UpdateMYSQL-b3076.zip]) | ||
***At 3.7.0 the SQL was provided as part of the main zip (read [[https://cumulus.hosiene.co.uk/viewtopic.php?p=145048#p145048 AlterSQLTables3098.sql]]) | ***At 3.7.0 the SQL was provided as part of the main zip (read [[https://cumulus.hosiene.co.uk/viewtopic.php?p=145048#p145048 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). | ||