Answers.Body: <p>Solved:</p>
  
  <p>It turns out that the CiviCRM logs contained error messages that indicated a missing database column, specifically a CiviCRM custom field. It's not clear why the column was missing, and the CiviCRM admin continued to display the field. An attempt to edit and save the custom field, in the CiviCRM admin, resulted in the same error as occured when submitting the donation form, which appeared to confirm that the custom field was the culprit. Sure enough, once this column was rebuilt, the problem was solved.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-09-13T18:33:44.793Z
Answers.LastActivityDate: 2017-09-13T18:33:44.793Z
Answers.UserDisplayName: Danielle Siembieda
Body: <p>We used the Paypal Pro Payment Processor with Civi. It has worked well in the past (including last month). After the last update they are no longer working properly. However, the payment processor is taking the actual payment. </p>
  
  <p>For example I went through our donation page and donated $1.11. On hitting submit I received this error
  <a href="https://i.sstatic.net/fRtZ2.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/fRtZ2.png" alt="enter image description here"></a>
  On the CiviCRM End I received this error failing to update database.
  <a href="https://i.sstatic.net/Qxlxy.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Qxlxy.png" alt="enter image description here"></a>
  However, on the Paypal end the payment went through. I received a notification from Paypal indicating I received a donation of $1.11. </p>
  
  <p>So, something is happening on the Civi end of things but I don't know how to fix this error.</p>
  
  <p>Here are the errors:</p>
  
  <pre><code>CRM_Core_Exception: Failed to update contribution in database in /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php on line 2336
  Exception trace
  #
  Function
  Location
  
  0
  CRM_Contribute_Form_Contribution_Confirm-&gt;completeTransaction(Array, 99)
  /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php:2336
  1
  CRM_Contribute_Form_Contribution_Confirm-&gt;processFormSubmission('6')
  /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php:716
  2
  CRM_Contribute_Form_Contribution_Confirm-&gt;postProcess()
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php:447
  3
  CRM_Core_Form-&gt;mainProcess()
  /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Main.php:1314
  4
  CRM_Contribute_Form_Contribution_Main-&gt;skipToThankYouPage()
  /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Main.php:1048
  5
  CRM_Contribute_Form_Contribution_Main-&gt;postProcess()
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php:447
  6
  CRM_Core_Form-&gt;mainProcess()
  /var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php:169
  7
  CRM_Core_QuickForm_Action_Upload-&gt;realPerform(Object(CRM_Contribute_Form_Contribution_Main), 'upload')
  /var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php:136
  8
  CRM_Core_QuickForm_Action_Upload-&gt;perform(Object(CRM_Contribute_Form_Contribution_Main), 'upload')
  /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php:203
  9
  HTML_QuickForm_Controller-&gt;handle(Object(CRM_Contribute_Form_Contribution_Main), 'upload')
  /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php:103
  10
  HTML_QuickForm_Page-&gt;handle('upload')
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Controller.php:351
  11
  CRM_Core_Controller-&gt;run(Array, null)
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php:310
  12
  CRM_Core_Invoke::runItem(Array)
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php:84
  13
  CRM_Core_Invoke::_invoke(Array)
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
  14
  CRM_Core_Invoke::invoke(Array)
  /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module:448
  15
  civicrm_invoke('contribute', 'transact')
  unknown:unknown
  16
  call_user_func_array('civicrm_invoke', Array)
  /var/www/html/includes/menu.inc:527
  17
  menu_execute_active_handler()
  /var/www/html/index.php:21
  18
  {main}
  
   Sorry but we are not able to provide this at the moment.Failed to update contribution in database
  Return to home page.
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-09-08T03:09:04.277Z
Comments.Text: Check the CiviCRM log in the ConfigAndLog directory for clues; Something goes wrong when yoir Contribution is trying to write to the database
Comments.UserDisplayName: KarinG - Semper IT
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-09-08T17:22:35.027Z
Comments.Text: To expand on KarinG's comment: To solve your problem, we'll need to see the debugging info. In CiviCRM, go to **Administer menu > System Settings > Debugging and Error Handling**, select "Yes" to both "Enable Debugging" and "Display Backtrace", and press "Save". Repeat the steps that caused your error, and you'll see much a more detailed error. Please update this question with the expanded error and backtrace - and don't forget to disable debug/backtrace afterward! You can also get this info from the log located in the [ConfigAndLog directory](https://civicrm.stackexchange.com/q/15931/12)
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-09-08T18:35:43.817Z
Comments.Text: Thanks for guiding me through the how-to on the Debugging.
Comments.UserDisplayName: Danielle Siembieda
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-09-11T11:31:37.820Z
Comments.Text: There is normally an "edit" link underneath the question, just underneath the tags.
  One thing to check re the "no such field" error: do you have Civi advanced logging enabled (at /civicrm/admin/setting/misc?reset=1)? If so, possibly a field has failed to be added to one of the logging tables. Try /civicrm/menu/rebuild?reset=1&triggerRebuild=1 or disable then re-enable logging.
Comments.UserDisplayName: davejenx
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-09-12T22:28:08.847Z
Comments.Text: Thanks for the backtrace!  From the backtrace, it looks like you do NOT have a confirmation page - once you submit the contribution, it goes straight to "Thank You".  As a test, could you try enabling the confirmation page and see if the problem goes away?
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <civicontribute><payment-processor><paypal>
Title: Paypal Payment Processor not connecting with CiviCRM
ThreadText: # Paypal Payment Processor not connecting with CiviCRM
  
  (Asked by: username_0 on 2017-09-07)
  
  We used the Paypal Pro Payment Processor with Civi. It has worked well in the past (including last month). After the last update they are no longer working properly. However, the payment processor is taking the actual payment.
  
  For example I went through our donation page and donated $1.11. On hitting submit I received this error
  [![enter image description here](https://i.sstatic.net/fRtZ2.png)](https://i.sstatic.net/fRtZ2.png)
  On the CiviCRM End I received this error failing to update database.
  [![enter image description here](https://i.sstatic.net/Qxlxy.png)](https://i.sstatic.net/Qxlxy.png)
  However, on the Paypal end the payment went through. I received a notification from Paypal indicating I received a donation of $1.11.
  
  So, something is happening on the Civi end of things but I don't know how to fix this error.
  
  Here are the errors:
  
  ```
  CRM_Core_Exception: Failed to update contribution in database in /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php on line 2336
  Exception trace
  #
  Function
  Location
  
  0
  CRM_Contribute_Form_Contribution_Confirm->completeTransaction(Array, 99)
  /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php:2336
  1
  CRM_Contribute_Form_Contribution_Confirm->processFormSubmission('6')
  /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php:716
  2
  CRM_Contribute_Form_Contribution_Confirm->postProcess()
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php:447
  3
  CRM_Core_Form->mainProcess()
  /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Main.php:1314
  4
  CRM_Contribute_Form_Contribution_Main->skipToThankYouPage()
  /var/www/html/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Main.php:1048
  5
  CRM_Contribute_Form_Contribution_Main->postProcess()
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php:447
  6
  CRM_Core_Form->mainProcess()
  /var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php:169
  7
  CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Contribute_Form_Contribution_Main), 'upload')
  /var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php:136
  8
  CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contribute_Form_Contribution_Main), 'upload')
  /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php:203
  9
  HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution_Main), 'upload')
  /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php:103
  10
  HTML_QuickForm_Page->handle('upload')
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Controller.php:351
  11
  CRM_Core_Controller->run(Array, null)
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php:310
  12
  CRM_Core_Invoke::runItem(Array)
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php:84
  13
  CRM_Core_Invoke::_invoke(Array)
  /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
  14
  CRM_Core_Invoke::invoke(Array)
  /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module:448
  15
  civicrm_invoke('contribute', 'transact')
  unknown:unknown
  16
  call_user_func_array('civicrm_invoke', Array)
  /var/www/html/includes/menu.inc:527
  17
  menu_execute_active_handler()
  /var/www/html/index.php:21
  18
  {main}
  
   Sorry but we are not able to provide this at the moment.Failed to update contribution in database
  Return to home page.
  
  ```
  
  **Tags:** civicontribute, payment-processor, paypal
  
  > **Comments:**
  > **username_1**: Check the CiviCRM log in the ConfigAndLog directory for clues; Something goes wrong when yoir Contribution is trying to write to the database  
  > **username_2**: To expand on username_1's comment: To solve your problem, we'll need to see the debugging info. In CiviCRM, go to **Administer menu > System Settings > Debugging and Error Handling**, select "Yes" to both "Enable Debugging" and "Display Backtrace", and press "Save". Repeat the steps that caused your error, and you'll see much a more detailed error. Please update this question with the expanded error and backtrace - and don't forget to disable debug/backtrace afterward! You can also get this info from the log located in the [ConfigAndLog directory](https://civicrm.stackexchange.com/q/15931/12)  
  > **username_0**: Thanks for guiding me through the how-to on the Debugging.  
  > **username_3**: There is normally an "edit" link underneath the question, just underneath the tags. One thing to check re the "no such field" error: do you have Civi advanced logging enabled (at /civicrm/admin/setting/misc?reset=1)? If so, possibly a field has failed to be added to one of the logging tables. Try /civicrm/menu/rebuild?reset=1&triggerRebuild=1 or disable then re-enable logging.  
  > **username_2**: Thanks for the backtrace!  From the backtrace, it looks like you do NOT have a confirmation page - once you submit the contribution, it goes straight to "Thank You".  As a test, could you try enabling the confirmation page and see if the problem goes away?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2017-09-13. Score: 2
  
  Solved:
  
  It turns out that the CiviCRM logs contained error messages that indicated a missing database column, specifically a CiviCRM custom field. It's not clear why the column was missing, and the CiviCRM admin continued to display the field. An attempt to edit and save the custom field, in the CiviCRM admin, resulted in the same error as occured when submitting the donation form, which appeared to confirm that the custom field was the culprit. Sure enough, once this column was rebuilt, the problem was solved.
  
  
  ---
  
  