40 pointsStarting to get into this DEV thingI'm new here
poohnix
Member
—
26th December 2011 (4 months ago)
I have a problem with PayPal recurring payments on a Membership Multisite install.
For some reason the recurring payments aren't recorded for subscriptions at any other site than the main site.
At the main site it works, being recorded in the subscription_transaction table for that site, and the expiry date of the subscription being extended properly.
However, subscriptions for members of any other site aren't updated when recurring payments are processed.
I have verified that the IPN notifications from PayPal are sent correctly, what the Membership plugin actually does with the notifications I have no idea, since they aren't recorded in any way.
The only transactions showing up in the transaction table is the original transaction, when they sign up.
I have a problem with PayPal recurring payments on a Membership Multisite install.
For some reason the recurring payments aren't recorded for subscriptions at any other site than the main site.
At the main site it works, being recorded in the subscription_transaction table for that site, and the expiry date of the subscription being extended properly.
However, subscriptions for members of any other site aren't updated when recurring payments are processed.
I have verified that the IPN notifications from PayPal are sent correctly, what the Membership plugin actually does with the notifications I have no idea, since they aren't recorded in any way.
The only transactions showing up in the transaction table is the original transaction, when they sign up.
Ok, sorry.
Membership itself is network activated, not by site.
The gateway used is "PayPal Express - with Subscriptions" for all sites, and each site has a number of subscriptions defined, all serial.
Some sites also use domain mapping. Some have their own domain, the other sites use subfolder, not subdomain.
Subscribers to the main site are updated when recurring payments are processed, but not for the other sites.
Does anyone have any theory why this is (not) happening?
Only the initial signup payments are registered in the "wp_(site#)_m_subscription_transaction" table, and the "wp_(site#)_m_membership_relationships" isn't updated when the recurring payments are processed.
The IPN's from PayPal are sent to the right URL, (depending on site), and accepted by the system...
As it is, I have to manually check daily which member payments that has been processed, and update the expiration time manually.
Have I missed something when I created the sites initially? (I used the new blog templates plugin to create the sites.)
Can you pop me up the details of one of the transactions from the PayPal IPN log? Also, can you check you PHP error log and let me know any messages in there relating to the membership plugin.
The error log for the site is utterly clean - not a single error message.
The site is sesvensktv.com which is a site in a multisite install where the main site is itsvpn.com.
Sub-sites are in subfolders, not subdomains, or as in this case using domain mapping...
The IPN for the latest transaction today looks like:
Instant Payment Notification (IPN) details
Message ID 7N245517L07594908
Date/time created 1/24/2012 12:31 GMT+01:00
Original/Resent Original
Latest delivery attempt date/time 1/24/2012 12:31 GMT+01:00
Notification URL http://sesvensktv.com/paymentreturn/paypalexpress
HTTP response code 200
Delivery status Sent
No. of retries 0
Transaction ID 33508425YC189262P
IPN type Transaction made
IPN Message
mc_gross=49.00&protection_eligibility=Ineligible&address_status=confirmed&payer_id=MER32NSVK2M3L&address_street=149 Yorktown Road&payment_date=03:31:29 Jan 24, 2012 PST&payment_status=Completed&charset=windows-1252&address_zip=08085&first_name=Per&mc_fee=5.16&address_country_code=US&address_name=Per Blomquist¬ify_version=3.4&subscr_id=S-4NE6698120157900H&custom=1324736222:21:4:7d9f56947bd5484b67c1d8a08b78b81f&payer_status=unverified&business=sales@wwwspace.net&address_country=United States&address_city=Woolwich Township&verify_sign=AyJiXJqBbF-VcP.IO6RiZv.W0D8IAEe34MivR29OAraN.U5aSp1J65fp&payer_email=per.blomquist@gmail.com&txn_id=33508425YC189262P&payment_type=instant&last_name=Blomquist&address_state=NJ&receiver_email=sales@wwwspace.net&payment_fee=&receiver_id=NMVDPCS9967VN&txn_type=subscr_payment&item_name=Bara Sverige - SEK 49 / MÃ¥nad&mc_currency=SEK&item_number=4&residence_country=US&transaction_subject=&payment_gross=&ipn_track_id=mfHpewfYBMlY7ft2XZBFkg
I'm still having an issue with this...
The strange thing is that all recurring payments show up in the list when looking under
Membership -> payment gateways -> PayPal Express - with Subscriptions -> Transactions.
for this network site.
So the IPN works, and Membership register each transaction.
But the membership term for the users are never extended. I have to do it each and every time myself, in the table wp_7_m_membership_relationships. (This is site 7 in the network.)
Neither updateddate nor expirydate are updated for the member.
I did eventually fix this, simply by adding a trigger i mysql.
Since every recurring payment is added correctly in the "wp_#_m_subscription_transaction" table, I just added a trigger for that insert, which checks that it's a completed payment and the amount is what is defined in the "wp_#_m_subscriptions_levels", and use the period and period unit defined there to extend the user account in the "wp_#_m_membership_relationships" table...
But I still have no idea why it doesn't work in the first place, since each payment is registered in the system... that part works, but not the update of the user.
Don't worry, there are plenty of us who would be royally screwed! There are a lot of niggly bits that make it difficult to nail down the problem in every case, but when it comes to getting your questions answered, WPMUDev tries their best. In fact, I believe they are beefing up their staff on the Customer Service side of things. My understanding is that Joe, who commented just above you, is a new hire with that expressed intention. I'm sure you'll find him and others quite responsive.
Responses (12)
Developer — 26th December 2011 (4 months ago) #
Can you give use some details of how you have the plugin activated and set up?
Member — 26th December 2011 (4 months ago) #
Ok, sorry.
Membership itself is network activated, not by site.
The gateway used is "PayPal Express - with Subscriptions" for all sites, and each site has a number of subscriptions defined, all serial.
Some sites also use domain mapping. Some have their own domain, the other sites use subfolder, not subdomain.
Subscribers to the main site are updated when recurring payments are processed, but not for the other sites.
Member — 14th January 2012 (4 months ago) #
Does anyone have any theory why this is (not) happening?
Only the initial signup payments are registered in the "wp_(site#)_m_subscription_transaction" table, and the "wp_(site#)_m_membership_relationships" isn't updated when the recurring payments are processed.
The IPN's from PayPal are sent to the right URL, (depending on site), and accepted by the system...
As it is, I have to manually check daily which member payments that has been processed, and update the expiration time manually.
Have I missed something when I created the sites initially? (I used the new blog templates plugin to create the sites.)
Member — 24th January 2012 (4 months ago) #
No theories?
Developer — 24th January 2012 (4 months ago) #
Can you pop me up the details of one of the transactions from the PayPal IPN log? Also, can you check you PHP error log and let me know any messages in there relating to the membership plugin.
Member — 24th January 2012 (4 months ago) #
The error log for the site is utterly clean - not a single error message.
The site is sesvensktv.com which is a site in a multisite install where the main site is itsvpn.com.
Sub-sites are in subfolders, not subdomains, or as in this case using domain mapping...
The IPN for the latest transaction today looks like:
Instant Payment Notification (IPN) details
Message ID 7N245517L07594908
Date/time created 1/24/2012 12:31 GMT+01:00
Original/Resent Original
Latest delivery attempt date/time 1/24/2012 12:31 GMT+01:00
Notification URL http://sesvensktv.com/paymentreturn/paypalexpress
HTTP response code 200
Delivery status Sent
No. of retries 0
Transaction ID 33508425YC189262P
IPN type Transaction made
IPN Message
mc_gross=49.00&protection_eligibility=Ineligible&address_status=confirmed&payer_id=MER32NSVK2M3L&address_street=149 Yorktown Road&payment_date=03:31:29 Jan 24, 2012 PST&payment_status=Completed&charset=windows-1252&address_zip=08085&first_name=Per&mc_fee=5.16&address_country_code=US&address_name=Per Blomquist¬ify_version=3.4&subscr_id=S-4NE6698120157900H&custom=1324736222:21:4:7d9f56947bd5484b67c1d8a08b78b81f&payer_status=unverified&business=sales@wwwspace.net&address_country=United States&address_city=Woolwich Township&verify_sign=AyJiXJqBbF-VcP.IO6RiZv.W0D8IAEe34MivR29OAraN.U5aSp1J65fp&payer_email=per.blomquist@gmail.com&txn_id=33508425YC189262P&payment_type=instant&last_name=Blomquist&address_state=NJ&receiver_email=sales@wwwspace.net&payment_fee=&receiver_id=NMVDPCS9967VN&txn_type=subscr_payment&item_name=Bara Sverige - SEK 49 / MÃ¥nad&mc_currency=SEK&item_number=4&residence_country=US&transaction_subject=&payment_gross=&ipn_track_id=mfHpewfYBMlY7ft2XZBFkg
Member — 24th January 2012 (4 months ago) #
Hmm... looks like parts of the IPN isn't visible here.
Not sure why they are cut out, or what to do about it.
Member — 13th February 2012 (3 months ago) #
I'm still having an issue with this...
The strange thing is that all recurring payments show up in the list when looking under
Membership -> payment gateways -> PayPal Express - with Subscriptions -> Transactions.
for this network site.
So the IPN works, and Membership register each transaction.
But the membership term for the users are never extended. I have to do it each and every time myself, in the table wp_7_m_membership_relationships. (This is site 7 in the network.)
Neither updateddate nor expirydate are updated for the member.
Member — 20th February 2012 (3 months ago) #
I did eventually fix this, simply by adding a trigger i mysql.
Since every recurring payment is added correctly in the "wp_#_m_subscription_transaction" table, I just added a trigger for that insert, which checks that it's a completed payment and the amount is what is defined in the "wp_#_m_subscriptions_levels", and use the period and period unit defined there to extend the user account in the "wp_#_m_membership_relationships" table...
But I still have no idea why it doesn't work in the first place, since each payment is registered in the system... that part works, but not the update of the user.
Support Kangaroo — 20th February 2012 (3 months ago) #
Greetings poohnix,
Thank you for being a WPMU Dev member!
Happy to hear that you got things sorted with your "trigger"
If we can be of further assistance please let us know.
Cheers, Joe :-)
Member — 21st February 2012 (3 months ago) #
I'm concerned he had to figure this out himself based on lack of responses from support staff.
Is this the norm here? Someone like myself with nowhere near the same level of technical proficiency as poohnix would be royally screwed in this case.
Ray
Member — 21st February 2012 (3 months ago) #
Hey Ray,
Don't worry, there are plenty of us who would be royally screwed! There are a lot of niggly bits that make it difficult to nail down the problem in every case, but when it comes to getting your questions answered, WPMUDev tries their best. In fact, I believe they are beefing up their staff on the Customer Service side of things. My understanding is that Joe, who commented just above you, is a new hire with that expressed intention. I'm sure you'll find him and others quite responsive.
Cheers,
Pali
Become a member