emptying cart to family returns ERROR 500

[ChurchCRMBugReport]

ChurchCRM Software Version | 4.4.5

I encountered a HTTP ERROR 500 when emptying the cart to family.

The result is that the system creates a new Family record, but the members are not in the new record. Then system output an ERROR 500.

Collected Value Title	Data
Page Name	/v2/dashboard
Screen Size	864x1536
Window Size	722x1536
Page Size	1049x1536
Platform Information	Linux racknerd-e5bd49 5.4.0-28-generic #32-Ubuntu SMP Wed Apr 22 17:40:10 UTC 2020 x86_64
PHP Version	7.4.23
SQL Version	5.5.5-10.4.21-MariaDB-1:10.4.21+maria~focal-log
ChurchCRM Version	4.4.5
Reporting Browser	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36
Prerequisite Status	Missing Prerequisites: ["Mod Rewrite or Equivalent"]
Integrity check status	{"status":"success"}

[MrClever]

It would be really helpful to see the error from the Apache error.log and the ChurchCRM application logs. Please review our logging and diagnostics wiki page for more information on what these logs are and where to find them.

[shihkuang]

[18-Oct-2021 20:11:23 America/Vancouver] PHP Deprecated: Function get_magic_quotes_gpc() is deprecated in /home/rmdcc/webapps/app-crm-rmdcc/ChurchCRM/utils/InputUtils.php on line 32 [18-Oct-2021 20:11:23 America/Vancouver] PHP Deprecated: Function get_magic_quotes_gpc() is deprecated in /home/rmdcc/webapps/app-crm-rmdcc/ChurchCRM/utils/InputUtils.php on line 32 [18-Oct-2021 20:11:23 America/Vancouver] PHP Notice: Undefined variable: bError in /home/rmdcc/webapps/app-crm-rmdcc/CartToFamily.php on line 98 [18-Oct-2021 20:11:23 America/Vancouver] PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/rmdcc/webapps/app-crm-rmdcc/CartToFamily.php on line 101 [18-Oct-2021 20:11:23 America/Vancouver] PHP Warning: Use of undefined constant key - assumed 'key' (this will throw an Error in a future version of PHP) in /home/rmdcc/webapps/app-crm-rmdcc/CartToFamily.php on line 102 [18-Oct-2021 20:11:23 America/Vancouver] PHP Notice: Undefined index: role637 in /home/rmdcc/webapps/app-crm-rmdcc/CartToFamily.php on line 109 [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

[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?

[github-actions[bot]]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

[DawoudIO]

still an issue

[05-Nov-2023 20:52:26 America/Detroit] PHP Fatal error:  Uncaught mysqli_sql_exception: 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 '' at line 1 in /var/www/html/Include/Functions.php:193
Stack trace:
#0 /var/www/html/Include/Functions.php(193): mysqli_query()
#1 /var/www/html/CartToFamily.php(105): RunQuery()
#2 {main}
  thrown in /var/www/html/Include/Functions.php on line 193

[github-actions[bot]]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.