CiviCRM Community Forums (archive)

Mike:
The membership will be created (or renewed) WHEN the contribution is COMPLETED. For PayPal Standard this means (as you've stated) that the IPN (notification) has been posted back to CiviContribute from PayPal.

The fact that your contributions are still in Pending status means that the IPN has not been properly posted back to CiviContribute from PayPal. An obvious possible problem is if you are running things on a test sandbox that doesn't have a public internet address (e.g. localhost). If this is not the case, please verify that you have configured CiviCRM and your PayPal merchant profile as documented here:

http://wiki.civicrm.org/confluence/display/CRMDOC/PayPal+Website+Payments+Standard+and+Recurring+Contributions

Mike:

1. Check your CiviCRM Global Settings >> Localization. Here try changing currency to AUD.
2. Also Check "Payment Receiving Preferences" for your live Paypal account.
    - Block payments sent to me in a currency I do not hold:

- kurund

I assumed u did a new contribution after your made the below changes. Note that once paypal has successfully posted an IPN it will NOT repost it (so those contribitions will be in pending state, unless u edit them and change them to completed). You should be able to do this using the Edit Contributions screen (search for all pending contributions)

if it still does not work, can u check: files/civicrm/upload/CiviCRM.log and let us know if you see any error message or a database updated successfully message

thanx

lobo

Mike - Lobo will need to chime in on your log error - all I can see from the error is that the IPN processing code can't determine which module (CiviContribute or CiviEvent) is generating the transaction....

Regarding editing of Contribution Statuses... the ability to do this via Edit Contribution screen has been added for 1.8 - but isn't available in 1.7. If these are live contributions and you need to update their statuses - you'll need to do this via SQL update statements.

1. Determine the contribution ID for any contributions you need to update by checking the id=xx when viewing the contribution

EX:  http://<site root>/civicrm/contact/view/contribution?reset=1&id=10&cid=102&action=view&context=dashboard&selectedChild=contribute
Contribution ID = 10 (id=10)

2. Run the following update query via phpMyAdmin or MySQL command line:
UPDATE civicrm_contribution SET contribution_status_id = 1 where id = (put your contribution record id here);

NOTE: If you want to update all PENDING contributions in your DB in one shot - your can do this:
UPDATE civicrm_contribution SET contribution_status_id = 1 where contribution_status_id =2;

CAVEAT: You should back up your DB before messing with this :-)

Hi Lobo,

I have emailed you the file.
 
Thank you for taking the time to look at this.
 
I upgraded from 1.6 to 1.7.9379 Drupal PHP5
I didn't record the rev number of the 1.6 version (probably should have)

regards,
Mike
 

Hi,

I have much the same problem.
A "Donation" page works fine, but a "Membership" page does not.
All membership payments show as "pending", whether Test or Live.
I am on Joomla 1.0.12, CiviCRM 1.6.8517, PHP 5.2.1, MySQL 5.0.30.
This is a hosted solution, so upgrading is not at my discretion.

Thanks for all you do,
Brian Darby

I'm having the issue with contributions staying in the pending state as well, but I have some caveats:

 - I'm using Website Payments Standard as well
 - I'm using Test Drive and the Paypal sandbox - should I expect Paypal to send IPN postbacks from the sandbox or only from live? I have not configured live payments yet.
 - I am using a local box for development on a DSL line, but I've configured it for dynamic DNS and given it a real dns name. Using another machine at a different site, I'm able to surf the site on my local box using that address.

Any ideas? How instant is "instant"? I assumed it meant "within a minute or two"