Skip to content
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

Closed
romdricks opened this issue May 13, 2024 · 20 comments
Closed

Bug: Save doesn't work in family editor #7025

romdricks opened this issue May 13, 2024 · 20 comments
Assignees
Labels

Comments

@romdricks
Copy link
Contributor

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
@romdricks romdricks added the bug label May 13, 2024
@respencer
Copy link
Contributor

That is very odd.

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

@respencer respencer added the status: needs information Further information is requested label May 14, 2024
@romdricks
Copy link
Contributor Author

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
Copy link
Contributor Author

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:
Screenshot 2024-05-14 124442

This is the screenshot of when the page goes blank:
Screenshot 2024-05-14 125044

@DawoudIO
Copy link
Contributor

Check the logs directory on disk

@romdricks
Copy link
Contributor Author

[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
Copy link
Contributor

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

@romdricks
Copy link
Contributor Author

10.11.7-MariaDB

@DAcodedBEAT
Copy link
Contributor

@romdricks is this still an issue on 5.8.0 ?

@romdricks
Copy link
Contributor Author

@romdricks is this still an issue on 5.8.0 ?

Yes it is.

@milanmenezes
Copy link

+1 facing the same issue while updating the family

Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'nte_DateEntered' cannot be null in /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:204 Stack trace: #0 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php(204): PDOStatement->execute(NULL) #1 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Base/Note.php(1131): Propel\Runtime\Connection\StatementWrapper->execute() #2 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert(Object(Propel\Runtime\Connection\ConnectionWrapper)) #3 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave(Object(Propel\Runtime\Connection\ConnectionWrapper)) #4 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base\{closure}() #5 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func(Object(Closure)) #6 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction(Object(Closure)) #7 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save() #8 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/FamilyEditor.php(418): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote('edit') #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/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Base/Note.php:1134 Stack trace: #0 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert(Object(Propel\Runtime\Connection\ConnectionWrapper)) #1 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave(Object(Propel\Runtime\Connection\ConnectionWrapper)) #2 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base\{closure}() #3 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func(Object(Closure)) #4 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction(Object(Closure)) #5 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save() #6 /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/FamilyEditor.php(418): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote('edit') #7 {main} thrown in /home/vol16_1/infinityfree.com/if0_36717673/htdocs/crm/ChurchCRM/model/ChurchCRM/Base/Note.php on line 1134

@milanmenezes
Copy link

I was able to fix this by changing the default value to current_timestamp in the database

@respencer respencer self-assigned this Jun 17, 2024
@respencer respencer removed the status: needs information Further information is requested label Jun 17, 2024
@romdricks
Copy link
Contributor Author

I was able to fix this by changing the default value to current_timestamp in the database

@milanmenezes can you please explain more?

@milanmenezes
Copy link

milanmenezes commented Jun 22, 2024

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:

[22-Jun-2024 08:27:33 America/New_York] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'nte_DateEntered' cannot be null in /var/www/html/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:204
Stack trace:
#0 /var/www/html/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php(204): PDOStatement->execute()
#1 /var/www/html/ChurchCRM/model/ChurchCRM/Base/Note.php(1131): Propel\Runtime\Connection\StatementWrapper->execute()
#2 /var/www/html/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert()
#3 /var/www/html/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 /var/www/html/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func()
#6 /var/www/html/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction()
#7 /var/www/html/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#8 /var/www/html/FamilyEditor.php(382): 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 /var/www/html/ChurchCRM/model/ChurchCRM/Base/Note.php:1134
Stack trace:
#0 /var/www/html/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert()
#1 /var/www/html/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 /var/www/html/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func()
#4 /var/www/html/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction()
#5 /var/www/html/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#6 /var/www/html/FamilyEditor.php(382): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote()
#7 {main}
  thrown in /var/www/html/ChurchCRM/model/ChurchCRM/Base/Note.php on line 1134

Screenshot 2024-06-22 at 6 13 37 PM

@milanmenezes
Copy link

Same issue with mariadb:latest

MySQL version: 11.4.2-MariaDB-ubu2404 through PHP extension MySQLi

@milanmenezes
Copy link

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()

@romdricks
Copy link
Contributor Author

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

@brimarq
Copy link

brimarq commented Jun 30, 2024

We seem to be having a similar issue attempting to update the address for a family through the FamilyEditor.php page. Tried 3x, got 500 errors, and gave up. On each attempt, it would give the error and reject the change. What's strange is... upon checking again on the following day, the info had been updated as intended.

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 nte_DateEntered column of the note_nte table. In our database, that column is of datetime type, and has a default of 1970-01-01 00:00:00.

  • ChurchCRM version: 5.8.0
  • PHP version the server running: PHP 8.2.15
  • DB Server and Version the server is running: MySQL 8.0.28

2024-06-27-php.log:

[27-Jun-2024 14:54:39 America/Chicago] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'nte_DateEntered' cannot be null in CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:204
Stack trace:
#0 CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php(204): PDOStatement->execute(NULL)
#1 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(1131): Propel\Runtime\Connection\StatementWrapper->execute()
#2 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert(Object(Propel\Runtime\Connection\ConnectionWrapper))
#3 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave(Object(Propel\Runtime\Connection\ConnectionWrapper))
#4 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base\{closure}()
#5 CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func(Object(Closure))
#6 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction(Object(Closure))
#7 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#8 CHURCHCRM_ROOT/FamilyEditor.php(418): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote('edit')
#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 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php:1134
Stack trace:
#0 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert(Object(Propel\Runtime\Connection\ConnectionWrapper))
#1 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave(Object(Propel\Runtime\Connection\ConnectionWrapper))
#2 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base\{closure}()
#3 CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func(Object(Closure))
#4 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction(Object(Closure))
#5 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#6 CHURCHCRM_ROOT/FamilyEditor.php(418): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote('edit')
#7 {main}
  thrown in CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php on line 1134
[27-Jun-2024 14:55:35 America/Chicago] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'nte_DateEntered' cannot be null in CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:204
Stack trace:
#0 CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php(204): PDOStatement->execute(NULL)
#1 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(1131): Propel\Runtime\Connection\StatementWrapper->execute()
#2 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert(Object(Propel\Runtime\Connection\ConnectionWrapper))
#3 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave(Object(Propel\Runtime\Connection\ConnectionWrapper))
#4 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base\{closure}()
#5 CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func(Object(Closure))
#6 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction(Object(Closure))
#7 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#8 CHURCHCRM_ROOT/FamilyEditor.php(418): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote('edit')
#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 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php:1134
Stack trace:
#0 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert(Object(Propel\Runtime\Connection\ConnectionWrapper))
#1 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave(Object(Propel\Runtime\Connection\ConnectionWrapper))
#2 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base\{closure}()
#3 CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func(Object(Closure))
#4 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction(Object(Closure))
#5 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#6 CHURCHCRM_ROOT/FamilyEditor.php(418): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote('edit')
#7 {main}
  thrown in CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php on line 1134
[27-Jun-2024 14:57:52 America/Chicago] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'nte_DateEntered' cannot be null in CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:204
Stack trace:
#0 CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php(204): PDOStatement->execute(NULL)
#1 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(1131): Propel\Runtime\Connection\StatementWrapper->execute()
#2 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert(Object(Propel\Runtime\Connection\ConnectionWrapper))
#3 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave(Object(Propel\Runtime\Connection\ConnectionWrapper))
#4 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base\{closure}()
#5 CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func(Object(Closure))
#6 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction(Object(Closure))
#7 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#8 CHURCHCRM_ROOT/FamilyEditor.php(418): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote('edit')
#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 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php:1134
Stack trace:
#0 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(1024): ChurchCRM\model\ChurchCRM\Base\Note->doInsert(Object(Propel\Runtime\Connection\ConnectionWrapper))
#1 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(969): ChurchCRM\model\ChurchCRM\Base\Note->doSave(Object(Propel\Runtime\Connection\ConnectionWrapper))
#2 [internal function]: ChurchCRM\model\ChurchCRM\Base\Note->ChurchCRM\model\ChurchCRM\Base\{closure}()
#3 CHURCHCRM_ROOT/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php(35): call_user_func(Object(Closure))
#4 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php(960): Propel\Runtime\Connection\ConnectionWrapper->transaction(Object(Closure))
#5 CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Family.php(232): ChurchCRM\model\ChurchCRM\Base\Note->save()
#6 CHURCHCRM_ROOT/FamilyEditor.php(418): ChurchCRM\model\ChurchCRM\Family->createTimeLineNote('edit')
#7 {main}
  thrown in CHURCHCRM_ROOT/ChurchCRM/model/ChurchCRM/Base/Note.php on line 1134

Copy link
Contributor

github-actions bot commented Aug 8, 2024

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.

@github-actions github-actions bot added the Stale label Aug 8, 2024
@DawoudIO DawoudIO removed the Stale label Aug 8, 2024
Copy link
Contributor

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.

@romdricks
Copy link
Contributor Author

@milanmenezes @respencer @DAcodedBEAT @DawoudIO @brimarq This was fixed by #7120 & #7150

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

6 participants