Jethro v2.20.0
This release adds a few new features, fixes several bugs, and makes Jethro PHP7 compatible.
Enhancements
- Custom fields of type "select" can now support an "other" option with textual value entry.
- When adding a family, you can now select a group to add each member to. (Each group has a new property to control whether it's available in the add-family form)
- In the note-listing pages, you can now filter by keyword
- In the note-listing pages, you can now display full notes instead of summary listing
- Family contact list DOCX export now includes family photos
- Photos are now visible and editable in the mobile interface, including access to the phone's camera and photo library.
- Script to email a report (@s4069b)
- In service component credits, (c) is now converted to © on save
- Jethro no longer relies on the legacy MDB2 database library, which simplifies installation (@vanoudt)
- Entering database details into the config file now uses a simpler format (@vanoudt)
- Jethro is now compatible with PHP7
Bugfixes
- Issue #364 - wrong filename extension for DOCX download in safari
- Issue #361 - importer failed silently when it encountered an invalid age bracket
- Issue #368 - Microsoft Excel was interpreting Jethro's CSV exports as incorrect file type sometimes
- Issue #370 - Family CSV export was failing
- Issue #372 - Non-congregational roster roles were not being displayed in the listing
- Issue #377 - The mailchimp sync script now uses Mailchimp API v3, resolving various issues
- Issue #351 - personnel were not updated when an old service run sheet was copied
- Issue #382 - congregations were being duplicated on install
- Issue #378 - task-notification settings were missing from the system-configuration page
- Issue #373 - family photo upload from add-family form was not working
- Issue #360 - error message about timezone during install
- Issue #301 - no-phone icon was being shown on rosters when SMS gateway wasn't even configured.
- Bible readings were sometimes getting squashed in wide rosters
- Errors with the smsbroadcast SMS gateway were not being detected properly (@vanoudt)
Upgrade Procedure - if upgrading from a version OLDER than 2.19.0
- Log out of Jethro
- Take a backup of your mysql database. Really, do it.
- Apply all applicable upgrade SQL files from the upgrades folder to your mysql database, including upgrades/2017-upgrade-to-2.19.sql
- Move away your old Jethro files (eg. rename your jethro folder to jethro_old)
- Unzip the new files into the right place (don't just overwrite the old files)
- 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 - 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)
- 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)
- Rename conf.php.sample to conf.php
- 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. - Log in to Jethro and check your system configuration at Admin > System Configuration
Upgrade Procedure - if upgrading from v2.19.x
- Log out of Jethro
- Take a backup of your mysql database
- Apply all applicable upgrade SQL files from the upgrades folder to your mysql database, including upgrades/2016-upgrade-to-2.20.sql
- Move away your old Jethro files (eg. rename your jethro folder to jethro_old)
- Unzip the new files into the right place (don't just overwrite the old files)
- Move your old conf.php and files/ subdirectory (if not empty) back into your jethro folder.
- 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
- Note: Although there is a new format for database settings in conf.php.sample, the old DSN format still works.
- Log in and test.
Credits
Thanks to @vanoudt for work on the MDB2 replacement and SMS integration and to @s4069b for the send-report script.