Jethro v2.21.1

This release adds a few bugfixes to version 2.20.0

Bugfixes

• Issue #397 - SMTP_PORT setting is now visible in conf file and system-config page
• Issue #399 - you can now change a person's congregation from something to 'none'
• Issue #390 - groups that should be hidden now are
• Issue #395 - users with only 'view' permission for services can now view run sheets
• Issue #396 - mailchimp sync script now works on linux again

Enhancements

See the version 2.20.0 release notes for the new features introduced there.

Upgrade Procedure - if upgrading from a version OLDER than 2.19.0

1. Log out of Jethro
2. Take a backup of your mysql database. Really, do it.
3. Apply all applicable upgrade SQL files from the upgrades folder to your mysql database, including upgrades/2017-upgrade-to-2.21.sql
4. Move away your old Jethro files (eg. rename your jethro folder to jethro_old)
5. Unzip the new files into the right place (don't just overwrite the old files)
6. Move your old conf.php and files/ subdirectory (if not empty) back into your jethro folder.
   1 Note: Jethro no longer needs the MDB2 libary, so if you have the MDB2 dropin in your old system, don't copy it to your new one
7. Important extra step: Open Jethro in your browser. You should see a bunch of messages saying "The setting XYZ has been migrated to the database and can/should be removed from conf.php". (Alternative option: Instead of opening Jethro in the browser you can run scripts/migrate_settings.php)
8. Once you've seen the messages above, rename your conf.php to conf-OLD.php. (Make sure you keep the .php extension - otherwise you'll expose your database credentials to the world)
9. Rename conf.php.sample to conf.php
10. Edit conf.php and for each setting that's in there, copy its value from conf-OLD.php.
    NB a) many settings will no longer be in conf.php because they've migrated to the database
    NB b) SMTP and SMS related settings will NOT have been automatically migrated to the database, so either leave them in the conf.php file or enter them manually into the web interface
    NB c) There are new settings for DB_DATABASE, DB_USERNAME etc, but the old PUBLIC_DSN etc still work.
11. Log in to Jethro and check your system configuration at Admin > System Configuration

Upgrade Procedure - if upgrading from v2.19.x or 2.20.x

1. Log out of Jethro
2. Take a backup of your mysql database
3. Apply all applicable upgrade SQL files from the upgrades folder to your mysql database, including upgrades/2016-upgrade-to-2.21.sql
4. Move away your old Jethro files (eg. rename your jethro folder to jethro_old)
5. Unzip the new files into the right place (don't just overwrite the old files)
6. Move your old conf.php and files/ subdirectory (if not empty) back into your jethro folder.
7. Note: Jethro no longer needs the MDB2 libary, so if you have the MDB2 dropin in your old system, don't copy it to your new one
8. Note: Although there is a new format for database settings in conf.php.sample, the old DSN format still works.
9. Log in and test.