CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • No CiviCRM Participant Payment records for incomplete transaction
Pages: [1]

Author Topic: No CiviCRM Participant Payment records for incomplete transaction  (Read 3385 times)

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
No CiviCRM Participant Payment records for incomplete transaction
January 15, 2010, 11:53:08 pm
Hello,

When someone starts a credit card payment and then doesn't complete (Pending (Incomplete Transaction)) the contribution record is created and the participant record is created but not the linking record in civicrm_participant_payment.

This seems like an error to me although it mainly affects SQL queries I run trying to get the contribution ID (invoice number). We treat these as the same as pending (pay later) as normally when someone fails to pay by credit card they later pay by bank transfer.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: No CiviCRM Participant Payment records for incomplete transaction
January 16, 2010, 07:05:45 am

i'm not sure i'd consider it an error. when you "finish" the pay later transaction the linking record is created by the completing process

its 6 of one, half a dozen of the other kinda deal

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: No CiviCRM Participant Payment records for incomplete transaction
January 16, 2010, 11:47:08 am
OK - I'll just have to find a way to work around it. I guess I'll probably have to write a hook to add the extra records
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: No CiviCRM Participant Payment records for incomplete transaction
January 16, 2010, 01:45:11 pm
NB - I presume the absence of this record is the reason why for 'pending pay later' I can receipt the contribution in from the event registration record but I can't for 'pending (incomplete transaction)' (this is where we get data entry errors happening although the new Xero integration should stop that.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

alanski

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 5
  • Cup of tea? Yes please
    • Joomkit
  • CiviCRM version: Version in post
  • CMS version: Joomla
  • MySQL version: 5.0
Re: No CiviCRM Participant Payment records for incomplete transaction
March 19, 2010, 08:56:27 am
This seems interestingly related to whatever admin process you have.

As far as I can tell when an event registration payment fails the persons record is created and given a Participant Status of 'Pending from incomplete transaction'
These does seem counter intuitive - I wouldnt want to write a contribution record until the gateway told me money changed hands. However Civi still creates a contribution record for person - almost like recording their intention to pay but failed.
and These cant be changed to pay later status once a contribution has been recorded.

Its a bit confusing for admins who are legging out the door clutching a participant list.

Any more thoughts?



Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: No CiviCRM Participant Payment records for incomplete transaction
March 19, 2010, 01:14:47 pm
There has been quite a bit of discussion around this general area and the consensus is that in future (3.2 from discussions) all payments will be recorded in a payments (the financial_trxns) table so in this case a contribution record would mean exactly what you say:

Quote
almost like recording their intention to pay but failed

I agree you should be able to change the status from pending (incomplete) to pending (pay later) as this would be a likely outcome of an administrator's follow up.

We track pending contributions for events rather than pending registrations. The reason being that if you want to cancel or confirm an event the most reliable way to do it is to cancel or confirm the contribution. You can also change the contribution amount (but not the participant payment amount) at that point - which is quite a common occurance. I know behaviour has changed a bit across versions but we used to find that events were confirmed or cancelled but contributions weren't before we started working off the contributions page.

Thus we direct our administrator to work off that screen. But OCCASSIONALLY there is a pending registration with no pending contribution record to track. We also occassionally find the administrator deletes a contribution (where it was a mistake and there are multiples) but the participation record is not deleted. I could prevent them from making deletions but really the main problem is that if you try to complete a pending registration a new one is created. I did start looking at how to fix (patch) this as the code is 95% there & hope to get back to it.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • No CiviCRM Participant Payment records for incomplete transaction

This forum was archived on 2017-11-26.