PayPal Transaction record does not get inserted in database

(@mbrsolution)

Hi, are you testing in Sandbox mode or live mode?

Can you further explain the following comment.

but when come back to the site it still shows the But with Paypal button.

Thank you

Thread Starter

(@adityaneel09)

Hello,
I am testing in sandbox mode.

but when come back to the site it still shows the But with Paypal button.

This means I show a “Buy with Paypal” button on the page. But when purchase is made and the user is redirected back to this page, it still shows the “Buy with Paypal”. I check in the database and the record did not get inserted in the transaction list.

Here’s the link: https://culinary-concepts.co.uk/NEW2016/biscuit-cakes-sponges/
TEST LOGIN:
username: falcon
pwd: Aditya@12345

Thank you

Plugin Support

(@mbrsolution)

Hi, can you carry out a live purchase. This will then reveal to you if it is working or not. I am almost certain the live purchase will work. Sandbox testing is very tricky and many run into issues.

Let me know how you go.

Regards

Thread Starter

(@adityaneel09)

Hi,
I just did a few live purchases.
The entry is made in the transaction table but somehow I am not able to get the wordpress user id in "save_txn_record" function. So I am not able to map the paypal purchase record.

Here is my workaround for the same:

global $wpdb;
        $query = "SELECT <code>email</code> FROM <code>wp_swpm_members_tbl</code> WHERE member_id = " . $custom_var['swpm_id'];
        $results = $wpdb->get_results($query);
        $email = '';
        for ($i = 0; $i < sizeof($results); $i++) {
            $email = $results[$i]->email;
        }

But this doesn’t work.
Any assistance would be highly appreciated.

Thank you

This reply was modified 7 years, 2 months ago by aditya.neel09.

Plugin Support

(@mbrsolution)

Hi, can you try the following documentation. Let me know if this helps you.

There are a few more checks you can carry out before I go testing your registration, as you mentioned above.

Thank you

Thread Starter

(@adityaneel09)

Hi,
I referred to the documentation but that didn’t help.
Here’s the log from the live paypal transaction:

[12/12/2017 8:46 AM] - SUCCESS: Paypal Class Initiated by 173.0.81.1
[12/12/2017 8:46 AM] - SUCCESS: Post string : transaction_subject=&payment_date=23%3A21%3A01+Dec+11%2C+2017+PST&txn_type=web_accept&last_name=neelkanth&residence_country=IN&item_name=Hot+Cold+Desserts&payment_gross=&mc_currency=￡ (entire paypal transaction chain)
[12/12/2017 8:46 AM] - SUCCESS: Checking if PayPal IPN response is valid
[12/12/2017 8:46 AM] - SUCCESS: Connecting to: https://www.paypal.com/cgi-bin/webscr
[12/12/2017 8:46 AM] - SUCCESS: IPN successfully verified.
[12/12/2017 8:46 AM] - SUCCESS: Creating product Information to send.
[12/12/2017 8:46 AM] - SUCCESS: Transaction Type: Buy Now/Subscribe
[12/12/2017 8:46 AM] - SUCCESS: Item Number: 307
[12/12/2017 8:46 AM] - SUCCESS: Item Name: Hot Cold Desserts
[12/12/2017 8:46 AM] - SUCCESS: Item Quantity: 1
[12/12/2017 8:46 AM] - SUCCESS: Item Total: 0.01
[12/12/2017 8:46 AM] - SUCCESS: Item Currency: GBP
[12/12/2017 8:46 AM] - SUCCESS: Membership payment paid for membership level ID: 3
[12/12/2017 8:46 AM] - SUCCESS: Transaction type: web_accept. Creating member account...
[12/12/2017 8:46 AM] - SUCCESS: swpm_handle_subsc_signup_stand_alone(). Custom value: subsc_ref=3&user_ip=49.213.60.251, Unique reference: 9NW651769B116841E
[12/12/2017 8:46 AM] - SUCCESS: Found a match in the member database. Member ID: 5
[12/12/2017 8:46 AM] - SUCCESS: Modifying the existing membership profile... Member ID: 5
[12/12/2017 8:46 AM] - SUCCESS: Setting access starts date value to: 2017-12-12
[12/12/2017 8:46 AM] - SUCCESS: Updating the current membership level (3) of this member to the newly paid level (3)
[12/12/2017 8:46 AM] - SUCCESS: Member signup/upgrade completion email successfully sent to: [email protected]
[12/12/2017 8:46 AM] - SUCCESS: Saving transaction data to the database table.
[12/12/2017 8:46 AM] - SUCCESS: Transaction data saved.
[12/12/2017 8:46 AM] - SUCCESS: Paypal class finished.

But as you can see from the logs, I am not able to get the swpm_id
$customvariables['swpm_id']

Thanks.

Plugin Support

(@mbrsolution)

Hi, I have submitted a message to the developers to investigate further your issue.

Thank you

Thread Starter

(@adityaneel09)

Thank you very much.
Hoping for a positive response.

Plugin Author

wp.insider

(@wpinsider-1)

Have you done the following in your paypal account just to be sure?
https://simple-membership-plugin.com/setting-utf-8-formatting-for-your-paypal-ipn-messages/

Thread Starter

(@adityaneel09)

Hi,
Yes I tried the paypal utf8 formatting but still of no use.
Also, the recipient paypal email used belongs to the UK so I think that wouldn’t be an issue.

Thanks

Plugin Author

wp.insider

(@wpinsider-1)

This is a little strange. Do you get any server error in the error log file?

Thread Starter

(@adityaneel09)

Hi,
There seems to be no error in the log file:

[12/13/2017 6:49 AM] - SUCCESS: Paypal Class Initiated by 173.0.81.1
[12/13/2017 6:49 AM] - SUCCESS: Post string : transaction_subject=&payment_date=22%3A49%3A08+Dec+12%2C+2017+PST&txn_type=web_accept&last_name=neelkanth&residence_country=IN&item_name=Hot+Cold+Desserts&payment_gross=&mc_currency=GBP&business=david%40dnewton.net&payment_type=instant&protection_eligibility=Ineligible&verify_sign=APXA2hlQD4stQ9Mpl5BvVscKMBxzAx-q19b1ORMtMduPZ3onrHTjp7vj&payer_status=verified&payer_email=contact%40falconsolutions.co&txn_id=7WN18878BE058251J&quantity=1&receiver_email=david%40dnewton.net&first_name=aditya&payer_id=52HLDLH5RSWKL&receiver_id=XKZCM7LAY2FRY&item_number=307&payer_business_name=FALCON+SOLUTIONS&payment_status=Completed&payment_fee=&mc_fee=0.01&mc_gross=0.01&custom=subsc_ref%253D3%2526user_ip%253D49.213.60.105&charset=windows-1252&notify_version=3.8&ipn_track_id=e4e913bfd79d3&
[12/13/2017 6:49 AM] - SUCCESS: Checking if PayPal IPN response is valid
[12/13/2017 6:49 AM] - SUCCESS: Connecting to: https://www.paypal.com/cgi-bin/webscr
[12/13/2017 6:49 AM] - SUCCESS: IPN successfully verified.
[12/13/2017 6:49 AM] - SUCCESS: Creating product Information to send.
[12/13/2017 6:49 AM] - SUCCESS: Transaction Type: Buy Now/Subscribe
[12/13/2017 6:49 AM] - SUCCESS: Item Number: 307
[12/13/2017 6:49 AM] - SUCCESS: Item Name: Hot Cold Desserts
[12/13/2017 6:49 AM] - SUCCESS: Item Quantity: 1
[12/13/2017 6:49 AM] - SUCCESS: Item Total: 0.01
[12/13/2017 6:49 AM] - SUCCESS: Item Currency: GBP
[12/13/2017 6:49 AM] - SUCCESS: Membership payment paid for membership level ID: 3
[12/13/2017 6:49 AM] - SUCCESS: Member ID: 
[12/13/2017 6:49 AM] - SUCCESS: Transaction type: web_accept. Creating member account...
[12/13/2017 6:49 AM] - SUCCESS: swpm_handle_subsc_signup_stand_alone(). Custom value: subsc_ref=3&user_ip=49.213.60.105, Unique reference: 7WN18878BE058251J
[12/13/2017 6:49 AM] - SUCCESS: Found a match in the member database. Member ID: 5
[12/13/2017 6:49 AM] - SUCCESS: Modifying the existing membership profile... Member ID: 5
[12/13/2017 6:49 AM] - SUCCESS: Setting access starts date value to: 2017-12-13
[12/13/2017 6:49 AM] - SUCCESS: Updating the current membership level (3) of this member to the newly paid level (3)
[12/13/2017 6:49 AM] - SUCCESS: Member signup/upgrade completion email successfully sent to: [email protected]
[12/13/2017 6:49 AM] - SUCCESS: Saving transaction data to the database table.
[12/13/2017 6:49 AM] - SUCCESS: Transaction data saved.
[12/13/2017 6:49 AM] - SUCCESS: Paypal class finished.

Plugin Author

wp.insider

(@wpinsider-1)

I meant your server’s error log file (not the plugin’s log file). Sometimes when the Database insert fails, the server’s error log file will have details as to why the insert failed.

Thread Starter

(@adityaneel09)