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) »
  • How do I find out what's going on with registrations?
Pages: [1]

Author Topic: How do I find out what's going on with registrations?  (Read 2280 times)

mhm

  • I post occasionally
  • **
  • Posts: 82
  • Karma: 2
How do I find out what's going on with registrations?
October 22, 2008, 09:47:40 am
We just started using CiviCRM (and CiviEvent), and are doing online registrations for two different events.  One event is using Google Checkout, and the other uses Paypal (due to some complicated internal stuff about where the money is going, and just wanting to try out Google's checkout). 

The event using Google Checkout seems to be working fine.  The event using Paypal seems to have a lot of transactions that simply end up "pending."  Not "pending - pay later," just "pending."  With Google Checkout events, it seems that any time there's one that says pending, I just need to check the notification email, and I'll see that they made a payment, and I just have to change them from "pending" to "registered."  (Why is this, by the way?  It seems like an annoying extra step.)  With the pending ones running through Paypal, there is no payment, that I can see, anywhere.  What might have gone wrong, and where?  (And where would logs that might show me that be?)

There is, of course, always the possibility that several people have changed their minds part-way through the registration running through Paypal, but that seems off to me. 

mhm

  • I post occasionally
  • **
  • Posts: 82
  • Karma: 2
Re: How do I find out what's going on with registrations?
October 22, 2008, 10:05:50 am
Okay, so I decided to test it myself, running my own card through Paypal, and then just denying the order through the organization's login to Paypal.  Everything worked.  There are about 6 places where, using Paypal Standard, one must click "yes" or whatever it is before the payment actually goes through.  This could be the issue, but what really, triggers the "pending" notification in CiviEvent?  Does this just happen automatically once someone puts in their email?  Does it not wait for anything from Paypal? 

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: How do I find out what's going on with registrations?
October 23, 2008, 06:45:18 am
Google Checkout and PayPal Standard both work in a similar way. Contribution records are created with a "Pending" status initially. After the user has completed "checkout" on the Google / PayPal server, those servers "call back" to your CiviCRM install to report that the payment was completed successfully. If the user decides not to complete the payment OR the "call back" fails due to misconfiguration - then the payment (and event registration in your case) remains in "Pending" status.

If "successfully completed" payments on the either the Google or PayPal events are still showing Pending, then this indicates a configuration problem. For both processors, you need to make sure that the "call back" URL for your CiviCRM site is registered properly in your merchant account setup with the processor - so recheck the procedures on our wiki. You could also check the CiviCRM.log file located in your configured "Uploads" directory to see if there are any errors related to this "call back" process.
Protect your investment in CiviCRM by  becoming a Member!

mhm

  • I post occasionally
  • **
  • Posts: 82
  • Karma: 2
Re: How do I find out what's going on with registrations?
October 23, 2008, 11:05:27 am
Dave, thanks so much for the help. 

Part of the problem seems to be that I had set up the callback urls as http instead of https, so hopefully that will fix part of the problem. 

Looking at the log, however, wasn't too enlightening -- there is surprisingly little there.  It shows my two most recent transactions (one an actual customer transaction, the other was me testing yesterday), and no other actual transactions, although there have been more than 20 in the last two weeks alone, and the log goes back to Sept. 24.  Is there some setting I'm missing that would send things to the logs?  Also, I should note the the two transactions it shows are both with Paypal, and it does not show anything for Google checkout.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: How do I find out what's going on with registrations?
October 23, 2008, 03:05:18 pm
We write to the log when the processor pings back to us with payment status - so not having records in the log confirms that the call back url's are likely incorrect.
Protect your investment in CiviCRM by  becoming a Member!

mhm

  • I post occasionally
  • **
  • Posts: 82
  • Karma: 2
Re: How do I find out what's going on with registrations?
October 23, 2008, 03:52:41 pm
So, where do I go from here?  The two Paypal transactions it does show were not after any changes to the call-back urls. 

To confirm what I found on the wiki, the call back urls should simply be https://www.example.com, correct?  (Since that is where my main Drupal install is.)

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: How do I find out what's going on with registrations?
October 23, 2008, 05:26:54 pm
About 10% of our paypal transactions get left in a pending state. The reason is that our customers have trouble with the paypal interface (It 'hides' the option to just put your credit card details in and they get confused or don't want to use an account).

This is not a bug - it is the way paypal works. We are applying to our bank to set up a merchant account with them and to dump paypal.
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

Deepak Srivastava

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: How do I find out what's going on with registrations?
October 23, 2008, 05:30:20 pm
Quote
To confirm what I found on the wiki, the call back urls should simply be https://www.example.com, correct?  (Since that is where my main Drupal install is.)
Call back url in your case would be sth like - https://www.example.com/sites/all/modules/civicrm/extern/googleNotify.php (if using google checkout).
For paypal-standard its set by the code, so you don't have to manually set it any where. 

Here are the wiki docs for more info -
http://wiki.civicrm.org/confluence/display/CRMDOC/Google+Checkout+Configuration.
http://wiki.civicrm.org/confluence/display/CRMDOC/PayPal+Website+Payments+Standard+and+Recurring+Contributions
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

mhm

  • I post occasionally
  • **
  • Posts: 82
  • Karma: 2
Re: How do I find out what's going on with registrations?
October 29, 2008, 09:34:46 am
Thanks for everyone's help on this.  I think it is finally working correctly, and the problem with the Paypal transactions does just seem to be one where people are abandoning the process.  We may wind up seeing if we can change to processing payments in another way.  Paypal's standard process, for people without accounts really is a drag.

sawjer

  • Guest
Re: How do I find out what's going on with registrations?
November 26, 2008, 08:45:44 am
I am running standalone civicrm 2.1.2 with the latest patch for index.php and I test online registration for events

I had to clear seller and buyer and recreate it to unblock incomplete transactions. The new seller is configured accoding to the description in the online docu of civicrm.

When I do a trial online registration I come up to the credit card screen. I login to the buyer account and I can trigger the payment. It confirms what I have done and lets me return to civicrm.

However the user is registered but with status pending.
The log shows the following:
Nov 26 16:39:54  [info] $GET = Array
(
    [reset] => 1
    [contactID] => 1
    [contributionID] => 37
    [module] => event
    [eventID] => 1
    [participantID] => 42
)


Nov 26 16:39:54  [info] $POST = Array
(
    [mc_gross] => 360.00
    [invoice] => 4ba84009395e2b7ca1138bc69baee93f
    [protection_eligibility] => Ineligible
    [payer_id] => ZJPVTFTN5EGE8
    [tax] => 0.00
    [payment_date] => 07:39:43 Nov 26, 2008 PST
    [payment_status] => Pending
    [charset] => windows-1252
    [first_name] => Test
    [notify_version] => 2.6
    [custom] =>
    [payer_status] => verified
    [business] => Manuel_1227712897_biz@swissagenda.info
    [quantity] => 1
    [verify_sign] => AJAQ0kVJHxbaetxKNwZ04nskguxIA4sQdKL9M0IeKnubPr7YFV-uK4HW
    [payer_email] => Margri_1227712949_per@swissagenda.info
    [txn_id] => 8RA92427SA416070R
    [payment_type] => instant

If I try a live registration working without a logged in user of civicrm:
I come to the credit card screen of paypal. I enter all my credentials of my (real and tested ) creditcard. 
The system responds with:
- Proper amount to be payed
- Error: The card you entered cannot be used for this payment. Please enter a different credit or debit card number.

I have verified that the number entered is correct, Name of Card owner and address are correct.
In the CiviCRM.log I find not entry of this transaction

What is wrong in my setup?

Help is very much appreciated as I am under pressure to make it work.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • How do I find out what's going on with registrations?

This forum was archived on 2017-11-26.