Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 08:40
    ChurchCRMBugReport opened #5209
  • 08:33
    dleigh commented #5203
  • Apr 01 23:03
    hlicorish commented #5120
  • Apr 01 12:42
    crossan007 milestoned #5204
  • Apr 01 12:42
    crossan007 labeled #5204
  • Apr 01 12:42
    crossan007 labeled #5204
  • Apr 01 12:41
    crossan007 milestoned #5208
  • Apr 01 12:41
    crossan007 labeled #5208
  • Apr 01 12:41
    crossan007 labeled #5208
  • Apr 01 12:41
    crossan007 labeled #5208
  • Apr 01 12:40
    crossan007 labeled #5207
  • Apr 01 12:40
    crossan007 labeled #5207
  • Apr 01 12:40
    crossan007 labeled #5207
  • Apr 01 08:58
    dleigh commented #5208
  • Apr 01 08:53
    ChurchCRMBugReport opened #5208
  • Apr 01 08:38
    ChurchCRMBugReport opened #5207
  • Apr 01 07:38
    dleigh commented #5174
  • Apr 01 01:17
    Travis ChurchCRM/CRM (4.0.3) passed (18750)
  • Apr 01 01:17
    crossan007 milestoned #5178
  • Apr 01 01:17
    crossan007 commented #5174
Martin Karari Maina
@gablex
Hi fam, I installed ChurchCRM and i is superb. Modern UI and great features. I would like to extend certain features, is there any developers manual....
justmax54
@justmax54
Can I add a column to the Group list? We would like to see members of the church and friends of the church but be able to tell which category they are in.
James G
@MrClever
@gablex - we have an entire section of our wiki devoted to development :) https://github.com/ChurchCRM/CRM/wiki/Development - it’s not “complete” but it should be enough to get you started! Also, star and follow the ChurchCRM project on GitHub https://github.com/ChurchCRM/CRM
@justmax54 - that would require some coding, but feel free to add a feature request via a ticket so we can flesh out what is needed and how to possibly implement it :+1:
Charles Crossan
@crossan007
@MrClever what's your level of DBA-savviness?
Charles Crossan
@crossan007
@MrClever asking about db savviness to see what you think of this join table: https://github.com/ChurchCRM/CRM/blob/feature/files/propel/schema.xml#L919
It feels kludgey, but I'm not sure how else to approach joining "one table" to many other tables of different types
Charles Crossan
@crossan007
Heh. playing around with creating a virtual webdav folder heirarchy.
image.png
yep - opened up my (Demo) ChurchCRM Families list via WinSCP :boom:
James G
@MrClever
Hi @crossan007 - sorry about the lag...been running cables to ensure solid internet at my wife's office. Too much wifi congestion for reliable tele-health consultations without a hard-wired connection ¯\_(ツ)_/¯
That schema tweak looks ok to me. There may be some benefit to creating an index on the 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.
Charles Crossan
@crossan007
Ah, nice of you to help!
Good call on the indexes. I need to take a course on MySQL DBA stuff
Charles Crossan
@crossan007
@MrClever it looks like the pirmary key is always indexexd in MySQL: https://stackoverflow.com/questions/1071180/is-the-primary-key-automatically-indexed-in-mysql
So, I think adding that index is not necessary.
James G
@MrClever
Good point - yes, the primary is always indexed :) I didn’t even look at which field was primary!
James G
@MrClever
I was thinking I might be able to do some query profiling now that our production site is self-hosted. There's possibly some other tables/columns that could benefit from indexes or tweaks.
Charles Crossan
@crossan007
Good idea
Thomas Dilts
@thomasdilts
Plans for a new release anytime soon? I see all the nice things getting fixed and I just wonder when I will see them in a release. I don't really dare to put a develop branch directly in a production environment...
Charles Crossan
@crossan007
@thomasdilts yes! It's basically ready, I was just having some trouble with updating the language translation files from POEditor. I'll try to get it out by the end of this week
Bob
@rbeerster
Just installed a test of 4.0.2 on CentOS 8 with mysql-server-8.0.17-3.module_el8.0.0+181+899d6349.x86_64. In mysql version 8.0.2+ Groups is a reserved word. This is an issue in both GroupsDashboardItem.php and DashboardService.php.
Charles Crossan
@crossan007
@rbeerster thanks for the heads up - can you open a GitHub issue for this?
Bob
@rbeerster
Just created #5205.
Charles Crossan
@crossan007
Excellent. Thank you
Charles Crossan
@crossan007
@MrClever I wonder if your query profiling may yeild any results that help with the resource usage of the smaller shared hosting providers.
Bob
@rbeerster
Just submitted a PR. I hope I did it correctly. Gentle correction gladly accepted :-).
Charles Crossan
@crossan007
Looking now @rbeerster
MErged
Charles Crossan
@crossan007

@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
@rbeerster congrats on your first contribution :-)
@smehrbrodt thanks for the additional German translations! they'll be included in 4.0.3
Charles Crossan
@crossan007
image.png
I'm always amazed at how many folks are contributing to the project on POEditor for locale updates
Charles Crossan
@crossan007
upgrading my production systems to 4.0.3 now
Looks like a success on 2 out of 2 systems upgraded.
@MrClever I'll wait for your update to remove the "pre-release" flag from 4.0.3
@DawoudIO if you're around and have time to test - that would be good too :-)
James G
@MrClever
@crossan007 - the connection saturation issue is one I’m hoping to get some more insight into when I do the profiling. I’ll take a run at the 4.0.3 release on the weekend probably, because I wont have time before then. I’ve tested each of the changes separately, but not in combination, so I’m 99.9% confident the real ease is good to go 👍🏻
Charles Crossan
@crossan007
:thumbsup:
Thomas Dilts
@thomasdilts
@crossan007 Thanks so much for the release. I installed it and it looks great. Everything works now that I was needing. Of course, most of the problems I was having were simply my own misunderstandings of how it works.
Thomas Dilts
@thomasdilts
Is there a way to trigger the "integrity control." Or does anyone know how long I have to wait before it remakes the cached integrityCheck.json? I of course tried removing the file and that didn't help :(
Charles Crossan
@crossan007
@thomasdilts there's a system configuration 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
diogomenezes22
@diogomenezes22

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?

Thomas Dilts
@thomasdilts
@crossan007 Integrity check reset worked like a charm! thanks.
James G
@MrClever

@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

Charles Crossan
@crossan007
(I've been working on the docker container the last three days - I want to use it for dev and to host my church's instance)
but, it's not "really" supported yet
James G
@MrClever
@crossan007 - that’s good to hear. I really “want” the Docker container to get some lurv, but it’s just not something I have a personal need for (yet) so I haven’t really bothered to look into it much.