file_id in both the files table and the file_associations tables because as the number of attachments grows (I'm thinking in the thousands, not the hundreds), this could be a bottle neck for some sites. The only overhead for the index would be a little slower inserts and some additional disk space, but adding them later could be painful.
@MrClever I just pushed locale updates for 4.0.3. When 1d4379e69c4fa8d6d1eba1896d8dbd9a3c685a79 finishes building, I'm going to tag and pre-release it as 4.0.3.
Notes
4.0.3 Release Notes
This is a bugfix release which addresses the following issues:
#5205 - Groups is a reserved keyword in MySQL 8.0
#5107 - Latitude / Longitude refreshes don't always work
#5184 - Self-verification URLs missing a slash between segments
#5174 - Google Maps now uses different keys for Geocoding vs JS Maps API
#5178 - Self-service password reset works again after the 4.x.x upgrade. (Password reset logging is better too)
#5175 - Deleting users shows an error message
#5175 - Added a new system config to control whether deleted users are sent a confirmation email (defaults to FALSE)
#5141 - Updated the "Admin Task Help Links" - specifically around the "Secrets" configuration introduced with 4.x.x
NOTE: If you are using the Google Maps API keys, you will need to re-enter your API keys after installing this release. Previous versions of ChurchCRM did not separate the geocoding keys from the JavaScript maps keys (which is against Google's best practice recommendations). Please review the ChurchCRM geographic wiki for more details: https://github.com/ChurchCRM/CRM/wiki/Geographic
1d4379e69c4fa8d6d1eba1896d8dbd9a3c685a79
sLastIntegrityCheckTimeStamp, which when it is further in the past than sIntegrityCheckInterval hours, the integrity check is executed. To re-trigger it, just set the timestamp value to null, and refresh the page. Integrity checks run as part of the AJAX call to timerjobs
Hello good afternoon
I will install ChurchCRM in my church in Brazil.
I have little experience with WEB tools
I would like to see some suggestions:
1) Is DigitalOcean Server recommended?
2) Can I install from Docker Image and get all these updates?
Or do I have to install manually to get updates?
@diogomenezes22 - we don’t really recommend one hosting provider over another as there are too many variables between providers and user’s needs to do that. Provided the hosting provider can support Apache web server with the required PHP version and modules needed to run ChurchCRM, the rest comes down to cost and performance.
As for installation, the Docker image isn’t something we officially support but it does have a number of active contributors from the community. Generally, we recommend installing from the latest release in your hosting environment. There’s some documentation on what you need to do here https://github.com/ChurchCRM/CRM/wiki/Installation . Also, have a look at the FAQ as it will often help make the installation and initial setup process a lot easier: https://github.com/ChurchCRM/CRM/wiki/FAQs