Plugin is Failing to create a new member record after payment

Hello,

Ok, so I followed all the troubleshooting and yes I do have IPN activated in my account. That is not the problem.

Here is what is showing in the debug log:
Remember, this is only happening for one type of membership purchase (Premium Lifetime membership), the second paid membership is working fine (Monthly Membership). I have added a —- in the areas with email addresses or names to protect the buyers identity, just so you know it´s not an error.

[12/07/2015 12:22 PM] – SUCCESS :Paypal Class Initiated by 173.0.81.1
[12/07/2015 12:22 PM] – SUCCESS :Post string : mc_gross=49.00&protection_eligibility=Eligible&address_status=unconfirmed&payer_id=JKUX3M7NZ5WGC&tax=0.00&address_street=Rua+Joana+Ang%E9lica++124++AP+604%0D%0AIpanema&payment_date=04%3A22%3A23+Dec+07%2C+2015+PST&payment_status=Completed&charset=windows-1252&address_zip=22420-030&first_name=MA—-US&mc_fee=2.21&address_country_code=BR&address_name=MA——+TA—-IBA&notify_version=3.8&custom=subsc_ref%3D2&payer_status=unverified&business=bu——-1234%40gmail.com&address_country=Brazil&address_city=Rio+De+Janeiro&quantity=1&verify_sign=A0FIHGGYIJ-nD8w6ijMHucFJMWkkAoKBbVFljo——–w9DxauqJQE&payer_email=m——-%40live.com&txn_id=1DR04660AB308812N&payment_type=instant&btn_id=101174471&last_name=T—–&address_state=RJ&receiver_email=bu———–1234%40gmail.com&payment_fee=2.21&shipping_discount=0.00&insurance_amount=0.00&receiver_id=YE85JSGQYV3HE&txn_type=web_accept&item_name=Lifetime+Premium+Membership+%2449&discount=0.00&mc_currency=USD&item_number=PMLife49&residence_country=BR&shipping_method=Default&handling_amount=0.00&transaction_subject=subsc_ref%3D2&payment_gross=49.00&shipping=0.00&ipn_track_id=7c8fff—-eaa&
[12/07/2015 12:22 PM] – SUCCESS :Connection to http://www.paypal.com successfuly completed.
[12/07/2015 12:22 PM] – SUCCESS :IPN successfully verified.
[12/07/2015 12:22 PM] – SUCCESS :Creating product Information to send.
[12/07/2015 12:22 PM] – SUCCESS :Transaction Type: Buy Now/Subscribe
[12/07/2015 12:22 PM] – SUCCESS :Item Number: PMLife49
[12/07/2015 12:22 PM] – SUCCESS :Item Name: Lifetime Premium Membership $49
[12/07/2015 12:22 PM] – SUCCESS :Item Quantity: 1
[12/07/2015 12:22 PM] – SUCCESS :Item Total: 49.00
[12/07/2015 12:22 PM] – SUCCESS :Item Currency: USD
[12/07/2015 12:22 PM] – SUCCESS :Membership payment paid for membership level ID: 2
[12/07/2015 12:22 PM] – SUCCESS :swpm integration is being used… creating member account…
[12/07/2015 12:22 PM] – SUCCESS :swpm_handle_subsc_signup_stand_alone(). Custom value: subsc_ref=2, Unique reference: 1DR04660AB308812N
[12/07/2015 12:22 PM] – SUCCESS :Could not find any record using the given email address (m—@live.com). Attempting to query database using the unique reference: 1DR04660AB308812N
[12/07/2015 12:22 PM] – SUCCESS :Creating new member account. Membership level ID: 2
[12/07/2015 12:22 PM] – FAILURE :Error! Failed to insert a new member record. This request will fail.
[12/07/2015 12:22 PM] – SUCCESS :Saving transaction data to the database table.
[12/07/2015 12:22 PM] – SUCCESS :Transaction data saved.
[12/07/2015 12:22 PM] – SUCCESS :Paypal class finished.

Any other ideas?
Also, Can you also send me the link that explains how to set up sandbox testing? I tried to do it previous but did not have success. However, I think I will have to figure it out this time.

Thanks

Hi again,

This button is set up as a one time payment with full access to all pages on the website. It’s a ‘buy now’ type buttonNo expiry date. As it sounds, it is a one time purchase for lifetime access. What other types of details may you need?

I built the button through Paypal, not through with the short code through the plugin because the button wouldn’t appear within the pricing table plugin I am using.

I have had successful transactions using this button. Only the last 2 transactions, consecutively failed. For this reason, I wrote into technical support.

Should I just try creating a new button and post the code in? Maybe some sort of random error. Or do you think I’ll have the same problem?

Thanks,
Amy