-
Notifications
You must be signed in to change notification settings - Fork 448
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Bug: Save doesn't work in family editor #7025
Comments
That is very odd. What are the exact steps to trigger that behavior, and is there any errors in the logs? |
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. |
Check the logs directory on disk |
[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 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 |
Can you tell me what version of MySQL you are running as it is missing a default value |
10.11.7-MariaDB |
@romdricks is this still an issue on 5.8.0 ? |
Yes it is. |
+1 facing the same issue while updating the family
|
I was able to fix this by changing the default value to current_timestamp in the database |
@milanmenezes can you please explain more? |
My apologies, i'm still facing this issue. To avoid shared hosting issues, I started a fresh installation on a linux server with docker (dockerised churchcrm, mariadb, redis). MySQL version: 5.5.5-10.11.8-MariaDB through PHP extension MySQLi Using Collation utf8mb3_unicode_ci Even with the fresh installation, creating a family works fine, updating a family errors out. This is the error seen in the logs:
|
Same issue with mariadb:latest MySQL version: 11.4.2-MariaDB-ubu2404 through PHP extension MySQLi |
The issue is limited to mariadb https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html The automatic initialization of timestamp is offered to timestamp and datetime types in mysql In mariadb, this is only offered on timestamp type. I was able to fix this issue by altering the table note_nte and changing the type of nte_DateEntered to timestamp and setting the default value to be current_timestamp() |
@respencer @milanmenezes Thanks for sharing. I made the alteration too and it fixed the note issue and the page reloads successfully. Save working for everything except Country, State and Classification fields |
We seem to be having a similar issue attempting to update the address for a family through the I'm attaching our info just in case it may be of some help to troubleshoot this issue. The fatal error seems to coming from a null value in the
2024-06-27-php.log:
|
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. |
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. |
@milanmenezes @respencer @DAcodedBEAT @DawoudIO @brimarq This was fixed by #7120 & #7150 |
Description
Changes made in Family Editor doesn't save.
The text was updated successfully, but these errors were encountered: