https://www.wikihow.com/Create-a-Database-in-phpMyAdmin
https://www.pipeten.com/support/general/adding-a-new-database-and-users-via-phpmyadmin/
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:
- 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).
- Create an empty database (see previous comments)
- 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 👍🏻
1 reply
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?
error.log and the ChurchCRM application log and see if there’s anything informative?
'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.
per_fmr_ID part of the SQL isn’t getting populated resulting with an invalid UPDATE query.
[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
@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.
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!
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.