Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 00:45
    github-actions[bot] edited #5970
  • Dec 01 00:48
    github-actions[bot] synchronize #5970
  • Dec 01 00:48
    github-actions[bot] edited #5970
  • Dec 01 00:48

    github-actions[bot] on 4.5.0

    Loacle Gen & Download on 2021-1… (compare)

  • Nov 30 09:49
    shihkuang converted_to_draft #5973
  • Nov 30 09:45
    shihkuang review_requested #5973
  • Nov 30 09:45
    shihkuang review_requested #5973
  • Nov 30 09:45
    shihkuang review_requested #5973
  • Nov 30 09:45
    shihkuang review_requested #5973
  • Nov 30 09:45
    shihkuang review_requested #5973
  • Nov 30 09:45
    shihkuang opened #5973
  • Nov 30 09:20
    julien-robert-github starred ChurchCRM/CRM
  • Nov 30 04:47
  • Nov 30 00:47
    github-actions[bot] synchronize #5970
  • Nov 30 00:47
    github-actions[bot] edited #5970
  • Nov 30 00:47

    github-actions[bot] on 4.5.0

    Loacle Gen & Download on 2021-1… (compare)

  • Nov 30 00:44
    ChurchCRMBugReport labeled #5972
  • Nov 30 00:44
    ChurchCRMBugReport opened #5972
  • Nov 29 00:46
    github-actions[bot] edited #5970
  • Nov 28 14:41
    jnfsjn12e23c commented #5957
brycedarmstrong
@brycedarmstrong
I can't get the database into mysql I guess is a better way of stating that.
Frankly, I'm probably doing it wrong.
James G
@MrClever
It depends on your hosting provider - some prevent database creation in phpmyadmin and have a separate process for db creation.
James G
@MrClever
If your hosting provider has enabled db creation in phpmyadmin, this guide should help:
https://www.wikihow.com/Create-a-Database-in-phpMyAdmin
This guide will show you how to add users to your db etc:
https://www.pipeten.com/support/general/adding-a-new-database-and-users-via-phpmyadmin/
brycedarmstrong
@brycedarmstrong
Ok, I've done both of those. Now how do I get the CRM-master folder into the new database I just created? Again, I'm sorry for what are probably stupid questions. I normally work with Python and this is very different and I don't know why I'm not understanding what to do.
George Dawoud
@DawoudIO
Create a blank db and the installer will do the rest
brycedarmstrong
@brycedarmstrong
Ok, but how do I get the installer to work? I feel like there are a bunch of steps in there that I'm missing.
James G
@MrClever

ChurchCRM is a PHP+MySQL web application. Your web server needs to be running PHP 7.3+ and have access to a MySQL database. Assuming those requirements can be met, installation is simply:

  1. Unpack the ChurchCRM zip file on your web server in a folder you can browse to and set the permissions on the files (see previous comments).
  2. Create an empty database (see previous comments)
  3. Open a browser and point it at the folder you unpacked the zip folder in (step 1 above).

There are some common snags we find people run into, but have an FAQ on our wiki to help. https://github.com/ChurchCRM/CRM/wiki/FAQs

If you’re still having problems, feel free to check in here and we will help where we can 👍🏻

Augustine Ranjan
@auga72_twitter
Is it possible to attach documents to individual members?
Augustine Ranjan
@auga72_twitter
We have documents like members signed GDPR documents and personal statement documents which and many other important documents from members we like to attach against every member. Is this possible?
James G
@MrClever
Hi @auga72_twitter - at the moment, this isn’t a feature in ChurchCRM. However, there’s an open ticket to build this which you are welcome to add your support for - see #350
1 reply
Anthony S.K. Chung
@shihkuang

Hi, this is related to issues #5971
I tested on demo.churchcrm.io.
Randomly select two people and put them into cart -> Select Empty to Family -> Create new family -->
Result: the new family record was created but there was no member added into the family. (the members are still in cart)

Can anyone confirm this?

James G
@MrClever
#5971 talks about a 500 error when attempting the operation. Can you check your Apache error.log and the ChurchCRM application log and see if there’s anything informative?
Anthony S.K. Chung
@shihkuang

'code'
[18-Oct-2021 20:11:23 America/Vancouver] PHP Fatal error: Uncaught Exception: Cannot execute query.

UPDATE person_per SET per_fam_ID = 170, per_fmr_ID = WHERE per_ID = 637

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE per_ID = 637' at line 1 in /home/rmdcc/webapps/app-crm-rmdcc/Include/Functions.php:189
Stack trace:

#0 /home/rmdcc/webapps/app-crm-rmdcc/CartToFamily.php(112): RunQuery()

#1 {main}

thrown in /home/rmdcc/webapps/app-crm-rmdcc/Include/Functions.php on line 189

This is something I found in error.log and posted in #5971. I am not sure how to debug that.

James G
@MrClever
Wrap pre-formatted text in triple back-ticks 😉
Anthony S.K. Chung
@shihkuang
Sorry I am not familiar with this code thing.. @@
James G
@MrClever
Hehe - Gitter uses the same markdown as GitHub, if that helps 👍🏻
BTW, it looks like this is the same code branch in #5971, where the per_fmr_ID part of the SQL isn’t getting populated resulting with an invalid UPDATE query.
Triple back-tick, new line, pre-formatted text, new line, triple back-tick
Anthony S.K. Chung
@shihkuang
[18-Oct-2021 20:11:23 America/Vancouver] PHP Fatal error: Uncaught Exception: Cannot execute query.

UPDATE person_per SET per_fam_ID = 170, per_fmr_ID = WHERE per_ID = 637

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE per_ID = 637' at line 1 in /home/rmdcc/webapps/app-crm-rmdcc/Include/Functions.php:189
Stack trace:
#0 /home/rmdcc/webapps/app-crm-rmdcc/CartToFamily.php(112): RunQuery()
#1 {main}
thrown in /home/rmdcc/webapps/app-crm-rmdcc/Include/Functions.php on line 189
Let me try...
James G
@MrClever
Hey! There you go 😁
Anthony S.K. Chung
@shihkuang
haha thanks~~
back to #5971, I wonder if you can duplicate same result as I did on https://demo.churchcrm.io
samisons
@samisons
hi
is there a feature where by i can integrate payment of dues? like using VISA, and mobile money transfer integration
George Dawoud
@DawoudIO
No I'm afraid online payment is not a core feature
samisons
@samisons
can i build one and integrate into this
like what tables would be affected
George Dawoud
@DawoudIO
Sure we just heed developers are have none active as this point in time
I would build new tables
samisons
@samisons
i don't understand, are you saying developers are currently not active in ChurchCRM ?
and you will create a table for this integration?
George Dawoud
@DawoudIO
Yes I am afraid we are focused on compliance, security and localization updates until we get new devs or I get time which has been hard
Augustine Ranjan
@auga72_twitter

@DawoudIO That's fully understandable. You guys have spent so much of time on this already and it's much appreciated.
Unfortunately I am not a developer, but I am an Infrastructure Engineer and I manage Cloud servers.

Since our church is looking to use this on a hosted server, we are thinking to PAY to someone to add a module of FILE Storage (Document (s) attachment) for individual members, which is very important for our church in the UK.

I am already in discussion with a developer and negotiating price and time frame ATM.

Of course, when the above MOULE is made, I will POST that it for the community and everyone can be benefitted from that as I am sure lot of them will want such facility.

I have the current version installed ( https://www.weconline.co.uk/ ) and have created a project document to discuss this with the developer I am hiring.
Do you have any suggestions for this? Since you are the main developer of this Software, you will be the best person to tell us the best route for this.

Augustine Ranjan
@auga72_twitter

Below document will give you an idea of what my suggestion to the developer... @DawoudIO What's your opinion on this?

https://drive.google.com/file/d/1bM8j5tiwyJoNdT2DQifticdDz1wTO54E/view?usp=sharing

Please could you share your thoughts - Thank you!

George Dawoud
@DawoudIO
Let me read when I get to a desktop
Anything you add would be great
samisons
@samisons
@DawoudIO understood!
samisons
@samisons
@DawoudIO is there a location i can find the database schema for churchcrm to understand how i could include a new table for integrations for payment or finance management like handling dues through integration
James G
@MrClever
This might not be 100% up-to-date, but it will help explain the schema in a little more detail - https://github.com/ChurchCRM/CRM/wiki/default.schema
samisons
@samisons
@MrClever thank you for this i will take a look at it
Anthony S.K. Chung
@shihkuang

I found a bug in CartToFamily.php related to issue #5971
Line 182: <form method="post"> is written too late for the cart post value. Therefore the familyrole id was returned empty _POST value.

Solution: move line 182 <form method="post"> to line 130.
Problem will be solved.

James G
@MrClever
@shihkuang - feel free to create a PR so we can review it :) Sounds like a workable solution to me, but I'd love to see the code 👍🏻
Anthony S.K. Chung
@shihkuang
found another bug... the redirection back to v2/family/171&Action=EmptyCart
The cart does not empty.....
Anthony S.K. Chung
@shihkuang
I really forgot how to upload the codes... so sorry.
Anthony S.K. Chung
@shihkuang
okay, somehow I added another PR. hopefully that works.
James G
@MrClever
Cool, thanks 😊