Answers.Body: <p>I had the same issue with Stripe and fixed it by temporarily switching all payment methods on contribution/event pages from Stripe to Paypal. deleting the existing Stripe payment Processors, disabling and uninstalling the the Stripe extension. Then reinstalling Stripe from the extensions screen. Then setting it up again from scratch.</p>
  <p>I've had Stripe installed for a long time and I think maybe updating over and over left some DB fields mismatched.</p>
  <p>It didn't take too long and is working again now.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-12-04T21:33:17.413Z
Answers.LastActivityDate: 2024-12-04T21:33:17.413Z
Answers.UserDisplayName: joewickert
Body: <p>CiviCRM was updated in the last few days, to 5.78.4, running on WordPress.</p>
  <p>Since then (possibly unrelated but a bit much of a coincidence) no one has been able to make a contribution.</p>
  <p>The card is authorised and appears to go through, but then</p>
  <p>&quot;Payment Processor Error message :DB Error: No Such Field&quot;</p>
  <p>Afterwards, the payments show as pending, but are not processed.</p>
  <p>The donors probably don't even notice the error, but we have noticed that payments are not processing.</p>
  <p>Is there a fix for this?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-12-04T15:27:59.287Z
Comments.Text: Yes, sounds likely to be related to the civicrm update. For a potential quick fix, visit extensions listing page /civicrm/admin/extensions?reset=1 and see if there's a pending update to an extension. If that doesn't fix it, tell us more, e.g. which version of civicrm were you running before the update, and which payment processor is being used here. You'll also likely get some more clues if you look in your civicrm error log, which you can see using the "logviewer" extension. Specifically - it might help identify which table is missing which field.
Comments.UserDisplayName: Alan Dixon
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-12-04T15:40:18.697Z
Comments.Text: Thanks, I'll take a look at that. It's Stripe, as it happens, and it was 5.65 something I think before, over a year out of date (that's another story).
Comments.UserDisplayName: Michael FORWARD
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-12-04T15:45:51.333Z
Comments.Text: It doesn't look as if any extensions have pending updates. All are on 5.78.4.
Comments.UserDisplayName: Michael FORWARD
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-12-04T15:47:35.500Z
Comments.Text: Ah, if your civicrm upgrade was BIG, then I'd put my money on a missing core field. Definitely check the logviewer or raw log files for the errors, they'll give you the information about which field is missing from which table. It might be a symptom of a bigger problem, of course.
Comments.UserDisplayName: Alan Dixon
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-12-04T16:01:45.657Z
Comments.Text: Something I've found, which may or may not be relevant, is that there's an alert about a problem detected with the Stripe Webhook. Not sure how long it's been there.
Comments.UserDisplayName: Michael FORWARD
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-12-05T20:13:35.173Z
Comments.Text: Not relevant no.
Comments.UserDisplayName: Alan Dixon
Tags: <civicontribute>
Title: Payment Processor Error message :DB Error: No Such Field
ThreadText: # Payment Processor Error message :DB Error: No Such Field
  
  (Asked by: username_0 on 2024-12-04)
  
  CiviCRM was updated in the last few days, to 5.78.4, running on WordPress.
  
  Since then (possibly unrelated but a bit much of a coincidence) no one has been able to make a contribution.
  
  The card is authorised and appears to go through, but then
  
  "Payment Processor Error message :DB Error: No Such Field"
  
  Afterwards, the payments show as pending, but are not processed.
  
  The donors probably don't even notice the error, but we have noticed that payments are not processing.
  
  Is there a fix for this?
  
  **Tags:** civicontribute
  
  > **Comments:**
  > **username_1**: Yes, sounds likely to be related to the civicrm update. For a potential quick fix, visit extensions listing page /civicrm/admin/extensions?reset=1 and see if there's a pending update to an extension. If that doesn't fix it, tell us more, e.g. which version of civicrm were you running before the update, and which payment processor is being used here. You'll also likely get some more clues if you look in your civicrm error log, which you can see using the "logviewer" extension. Specifically - it might help identify which table is missing which field.  
  > **username_0**: Thanks, I'll take a look at that. It's Stripe, as it happens, and it was 5.65 something I think before, over a year out of date (that's another story).  
  > **username_0**: It doesn't look as if any extensions have pending updates. All are on 5.78.4.  
  > **username_1**: Ah, if your civicrm upgrade was BIG, then I'd put my money on a missing core field. Definitely check the logviewer or raw log files for the errors, they'll give you the information about which field is missing from which table. It might be a symptom of a bigger problem, of course.  
  > **username_0**: Something I've found, which may or may not be relevant, is that there's an alert about a problem detected with the Stripe Webhook. Not sure how long it's been there.  
  > **username_1**: Not relevant no.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2024-12-04. Score: 2
  
  I had the same issue with Stripe and fixed it by temporarily switching all payment methods on contribution/event pages from Stripe to Paypal. deleting the existing Stripe payment Processors, disabling and uninstalling the the Stripe extension. Then reinstalling Stripe from the extensions screen. Then setting it up again from scratch.
  
  I've had Stripe installed for a long time and I think maybe updating over and over left some DB fields mismatched.
  
  It didn't take too long and is working again now.
  
  
  ---
  
  