Bug: Save doesn't work in family editor

[romdricks]

Description

Changes made in Family Editor doesn't save.

• ChurchCRM version: 5.7.0
• PHP version the server running: PHP 8.1
• DB Server and Version the server is running: MySQL

[respencer]

That is very odd.

What are the exact steps to trigger that behavior, and is there any errors in the logs?

[romdricks]

There is no specific step and no error in logs.

Also, for some families, when I try to save, either the page goes blank or refreshes.

You can try make changes to State or Classifications for members etc.. and see if you having the same issue.

Thanks.

[romdricks]

There is no specific step and no error in logs.

Also, for some families, when I try to save, either the page goes blank or refreshes.

You can try make changes to State or Classifications for members etc.. and see if you having the same issue.

Thanks.

Sorry @respencer I was checking for error in the wrong place.

This is the screenshot of when the page refreshes:

This is the screenshot of when the page goes blank:

[DawoudIO]

Check the logs directory on disk

[romdricks]

[14-May-2024 19:49:21 America/Jamaica] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'nte_DateEntered' cannot be null in /home/.../public_html/churchcrm/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:204
Stack trace:
#0 /home/.../public_html/churchcrm/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php(204): PDOStatement->execute()
#1 /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Base/Note.php(1131): Propel\Runtime\Connection\StatementWrapper->execute()
#2 /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert()
#3 /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave()
#4 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base{closure}()
#5 /home/.../public_html/churchcrm/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func()
#6 /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Base/Note.php(982): Propel\Runtime\Connection\ConnectionWrapper->transaction()
#7 /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#8 /home/.../public_html/churchcrm/FamilyEditor.php(421): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote()
#9 {main}

Next Propel\Runtime\Exception\PropelException: Unable to execute INSERT statement [INSERT INTO note_nte (nte_ID, nte_fam_ID, nte_Text, nte_DateEntered, nte_Type) VALUES (:p0, :p1, :p2, :p3, :p4)] in /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Base/Note.php:1134
Stack trace:
#0 /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert()
#1 /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave()
#2 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base{closure}()
#3 /home/.../public_html/churchcrm/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func()
#4 /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Base/Note.php(982): Propel\Runtime\Connection\ConnectionWrapper->transaction()
#5 /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#6 /home/.../public_html/churchcrm/FamilyEditor.php(421): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote()
#7 {main}
thrown in /home/.../public_html/churchcrm/ChurchCRM/model/ChurchCRM/Base/Note.php on line 1134

[DawoudIO]

Can you tell me what version of MySQL you are running as it is missing a default value

[romdricks]

10.11.7-MariaDB

[DAcodedBEAT]

@romdricks is this still an issue on 5.8.0 ?

[romdricks]

@romdricks is this still an issue on 5.8.0 ?

Yes it is.