Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Dec 13 21:44
    bkusiap edited #5111
  • Dec 13 21:39
    bkusiap edited #5111
  • Dec 13 21:35
    bkusiap opened #5111
  • Dec 13 16:10
  • Dec 11 02:22
  • Dec 09 21:41
    touke starred ChurchCRM/CRM
  • Dec 07 06:32
  • Dec 07 06:30
    eng-george1 edited #5110
  • Dec 07 06:29
    eng-george1 opened #5110
  • Dec 06 13:19
    crossan007 milestoned #5071
  • Dec 06 13:18
    crossan007 labeled #5071
  • Dec 06 13:18
    crossan007 commented #5071
  • Dec 06 07:30
    PhotoPaul commented #5071
  • Dec 05 13:38
    mc2grande opened #5109
  • Dec 05 00:01
    MrClever commented #5071
  • Dec 04 19:30
  • Dec 04 14:16
    PhotoPaul commented #5071
  • Dec 04 12:48
    crossan007 labeled #5107
  • Dec 04 12:48
    crossan007 labeled #5107
  • Dec 04 07:17
    emrekargi starred ChurchCRM/CRM
jshotton
@jshotton
I did a backup of the database and checked the sql statement, the default for Longitude and Lang is NULL. I changed the filterBYLongitude(0) to filterByLongitude(NULL) and it updated all the records. ran the missing families and it worked.
Charles Crossan
@crossan007
@jshotton good find - would you mind opening an issue on GitHub so we can track / resolve it?
James G
@MrClever
@jshotton - wow, nice catch! Like @crossan007 said, please drop all that in a ticket so we can merge it into a release soon! We’ve had a occasional “my lat/long don’t populate” reports but never enough information to replicate it! Wow. This is awesome!
James G
@MrClever

@mc2grande - I just had a quick look at IONOS and I couldn’t find any details about exactly “what” their hosting solution provides beyond broad marketing terms. Please ensure they are providing the standard Apache+PHP+MySQL(MariaDB) ChurchCRM relies on (we will be dropping support for PHP 7.0 soon). We have a number of PHP modules ChurchCRM relies on documented here https://github.com/ChurchCRM/CRM/wiki/Installation#php

Without any error messages, or logs there’s not a lot I can suggest at this stage. Please try to get hold of the web server error and access logs (ie, Apache error/access) as these often reveal problems you can’t see in a browser.

jshotton
@jshotton
@crossan007 @mcclever already created a ticket through the dropdown in churchcrm
Charles Crossan
@crossan007
Ah yes - #5107
James G
@MrClever
@jshotton - perfect! Thanks 😊 I’m on my iPad today so don’t see the browser panel for new tickets.
VanBawiThang
@VanBawiThang
@MrClever it was on fresh installation. I skipped that file integrity and can log in to system. But it still showing in Notification. Let me try in the setting. Thanks you.
James G
@MrClever
@VanBawiThang - don’t worry too much about the file integrity warning; it wont affect the functionality of the system. We can work on figuring out what it is complaining about it but it is only a warning.
VanBawiThang
@VanBawiThang
@MrClever I have some other issue on report. "Database error or invalid data" whenever i open event attendance report and "Add New Pledges"
James G
@MrClever
@VanBawiThang - the pledge/finance module is not something I have any experience with so I’m not sure what might be causing that. There should be more information in the ChurchCRM logs/yyyy-mm-dd-app.log for the date you see the error.
VanBawiThang
@VanBawiThang
@MrClever event attendance report is also facing "Database error or invalid data"
James G
@MrClever
Sounds like there’s some underlying problem with your database set up. Please let us know what is in your logs - that error usually shows up when the application can’t use the database correctly, such as permissions etc.
VanBawiThang
@VanBawiThang
How to upload the log here?
James G
@MrClever
I would suggest removing anything that is local data (file paths, user names, etc). Then just cut-n-paste the cleaned log information here. We don’t need the full log, just the errors relating to the database errors.
VanBawiThang
@VanBawiThang
Finished background job processing [] []
[2019-12-04 16:18:49] defaultLogger.ERROR: Cannot execute query. INSERT INTO pledge_plg (plg_famID, plg_FYID, plg_date, plg_amount, plg_schedule, plg_method, plg_comment, plg_DateLastEdited, plg_EditedBy, plg_PledgeOrPayment, plg_fundID, plg_depID, plg_CheckNo, plg_scanString, plg_aut_ID, plg_NonDeductible, plg_GroupKey) VALUES ('3','23','2019-12-04','1000000','Once','CASH','','20191204161849',1,'Pledge',2,0,NULL,'','0','0','cash|0|3|2|2019-12-04') -|- Out of range value for column 'plg_amount' at row 1 [] []
[2019-12-04 16:18:53] defaultLogger.INFO: Starting background job processing [] []
[2019-12-04 16:18:53] defaultLogger.INFO: Not starting application integrity check. Last application integrity check run: 20191202-124815 [] []
[2019-12-04 16:18:53] defaultLogger.INFO: Finished background job processing [] []
[2019-12-04 16:18:54] defaultLogger.ERROR: Cannot execute query. INSERT INTO pledge_plg (plg_famID, plg_FYID, plg_date, plg_amount, plg_schedule, plg_method, plg_comment, plg_DateLastEdited, plg_EditedBy, plg_PledgeOrPayment, plg_fundID, plg_depID, plg_CheckNo, plg_scanString, plg_aut_ID, plg_NonDeductible, plg_GroupKey) VALUES ('3','23','2019-12-04','1000000','Once','CASH','','20191204161854',1,'Pledge',2,0,NULL,'','0','0','cash|0|3|2|2019-12-04') -|- Out of range value for column 'plg_amount' at row 1 [] []
[2019-12-04 10:09:32] defaultLogger.ERROR: ERROR connecting to database at ' ' on port '3306' as user '' - MySQL Error: 'Host 'ip-43-255-154-43.ip.secureserver.net' is not allowed to connect to this MySQL server' [] []
[2019-12-04 16:50:29] defaultLogger.INFO: Finished background job processing [] []
[2019-12-04 17:07:54] defaultLogger.ERROR: Cannot execute query. -|- [] []
jshotton
@jshotton
@MrClever @crossan007, I thought about the fix for the GPS, and I would suggest taking out the filter, and have it update all GPS records or change it to update the GPS anytime Address line has been changed. The reason for this is when a member moves, it won't change there address, nor will they realize it should be changed. and because the default is Null, it is pretty hard for someone updating the address to be able to change the GPS to Null
James G
@MrClever

@VanBawiThang - there are two errors in your log sample that seem to be relevant. One is saying a pledge amount of of 1 million (1000000) is out of range. Try using a lower amount and see if that changes anything.

Secondly, this error may be temporary, but the unless you have removed the database name and username, it was never going to succeed either:

[2019-12-04 10:09:32] defaultLogger.ERROR: ERROR connecting to database at ' ' on port '3306' as user '' - MySQL Error: 'Host 'ip-43-255-154-43.ip.secureserver.net' is not allowed to connect to this MySQL server' [] []

I’m going to double check the DB schema and make sure there aren’t any limits on table values etc.

James G
@MrClever

@VanBawiThang - the pledge_plg table has a limit of 8 digits with a precision of 2. This would limit pledge amounts to a maximum of 999,999.99. When. You nominated a pledge amount of 1,000,000 it is actually trying to be stored as 1000000.00 which is 9 digits. To work around this, you could nominated an in-range pledge or alter the schema to support more digits in the plg_amount column.

If local currency requires storing such large numbers, please file a ticket so we can adjust the schema for everyone :)

@VanBawiThang - the following SQL should fix the problem with out of range pledge amounts:

ALTER TABLE pledge_plg MODIFY COLUMN plg_amount decimal(9,2)

That will allow amount up to 9,999,999.99. If you need 10-99 million, change the (9,2) to (10,2).

VanBawiThang
@VanBawiThang
@MrClever This is working now after updating the table.
Where to remove database name and username . "[2019-12-04 10:09:32] defaultLogger.ERROR: ERROR connecting to database at ' ' on port '3306' as user '' - MySQL Error: 'Host 'ip-43-255-154-43.ip.secureserver.net' is not allowed to connect to this MySQL server' [] []",
James G
@MrClever
The username/database error may be an intermittent or temporary error. If the app is working, then there’s nothing to do 👍🏻
mc2grande
@mc2grande
@MrClever Hi Again... apologise.. the problem is the .htaccess we tried to change it but it won't allow us. under .htaccess = 'deny from all' please help
VanBawiThang
@VanBawiThang
Hello, Is there any place to add weekly offertory receipt.
shanmukag
@shanmukag
hi
I am getting below issue:
This server isn't quite ready for ChurchCRM
How can I check which one is not installed properly
version 3.5.5
James G
@MrClever
@mc2grande - I don’t quite understand what you’re saying. Where is that “deny from all” ? The .htaccess files are only parsed by the web server and shouldn’t be accessible remotely; this is expected. The instructions I gave are file operations within the hosting environment. So whether you use shell access or some other file manager on your hosting environment (FTP etc) you should try replacing the htaccess file with the one corresponding to the release you are running.
@shanmukag - it should show you during the setup process which modules are missing.
jshotton
@jshotton
k, i have been trying to figure this one out all night. I am running churchcrm on a raspberry pi, I am able to access it on the local ip address 192.168.0.95 and also on the external address. I tried to change the external address and thats when it slows down. I get the login prompt quickly. then it hangs for 30 seconds before it enters the website. then when i click on anything it takes 30s again. I am currently just using ip address to test before I setup the SSL cert.
jshotton
@jshotton
i have changed Config.php to the new address, and it doesn't make a difference, including a reboot
James G
@MrClever
@jshotton - sounds like some sort of DNS time out. Make sure you add an entry into your local (ie client) hosts file that resolves both the internal and external addresses. Depending on how you’re connecting, you may need to add it to the Pi’s /etc/hosts file too.
eng-george1
@eng-george1
I tried the Arabic language but the system not change the UI to RTL , can anyone help me?
mc2grande
@mc2grande
@MrClever I've reached the setup page however, include/config is writable failed, images directory failed and file integrity failed. Is there something wrong with the 3.5.5 file?
James G
@MrClever

@mc2grande - the 3.5.5 release is fine. The problem sounds very much like permissions on your web server. Please ensure the permissions are set correctly: https://github.com/ChurchCRM/CRM/wiki/FAQs#internal-server-error-500

Even though you’re not getting 500 errors, the link above has the permissions you need to set. Unfortunately ZIP files don’t carry permission information and consequently are often not correct after unpacking on your web host.

jshotton
@jshotton
still having issues when the site is accessed externally, and I opened the developer console on google and when accessed externally versus internally, I get a 404 not found on /churchcrm/skin/external/bootstrap-timepicker/bootstrap-timepicker.min.css I have checked, and the bootstrap-timepicker folder doesn't exist in the external folder
James G
@MrClever
The time picker is only used in the calendar and I’m pretty sure there’s already a ticket for it. It wont stop the core functionality from operating normally though.
jshotton
@jshotton
is there a older version that I can download it form, I am trying to find what's causing the delayed login
looks like 3.3.2 had it in it, I will try and add it to my local copy to see what happens
James G
@MrClever
All the releases are on the “releases” page on Github. Including the file wont hurt, but I doubt it will fix the problem; my dev instance throws a 404 on that JS asset but otherwise it works fine.
jshotton
@jshotton
still working on it, jquery.min.js seems to be what is causing the slow login. gives a err_connection_reset
restdev
@restdev
I have just started looking at Church CRM and am in the planning stages to use it for church database
I also need to do a database for a sports club who do gradings and tournaments all for individuals
Both use the principle of children and parents
will it be possible to have some of the menu names changed to fit the environment
Do you have a manual that can be downloaded