Failed to insert a new member record

[Mike]

Hi, A new member just signed up to my website. The PayPal payment profile was created, the IPN was received and verified, but a new member record was not inserted (see log file below). There have been no recent changes made to the site. I ended up having to add the member manually. I also added their unique ID reference from their PayPal profile, so hopefully that will work to receive payments for now. Thanks for your help.

Mike

[11/16/2018 7:19 PM] – SUCCESS: Checking if PayPal IPN response is valid
[11/16/2018 7:19 PM] – SUCCESS: Connecting to: https://www.paypal.com/cgi-bin/webscr
[11/16/2018 7:19 PM] – SUCCESS: IPN successfully verified.
[11/16/2018 7:19 PM] – SUCCESS: Creating product Information to send.
[11/16/2018 7:19 PM] – SUCCESS: Subscription signup IPN received… (handled by the subscription IPN handler)
[11/16/2018 7:19 PM] – SUCCESS: Found a membership level ID. Creating member account…
[11/16/2018 7:19 PM] – SUCCESS: swpm_handle_subsc_signup_stand_alone(). Custom value: subsc_ref=3&user_ip=MEMBER_IP, Unique reference: I-6D5MPEV0VA4Y
[11/16/2018 7:19 PM] – SUCCESS: Could not find any record using the given email address (MEMBER_EMAIL). Attempting to query database using the unique reference: I-6D5MPEV0VA4Y
[11/16/2018 7:19 PM] – SUCCESS: Did not find a match for an existing member profile for the given reference. This must me a new payment from a new member.
[11/16/2018 7:19 PM] – SUCCESS: Creating new member account. Membership level ID: 3
[11/16/2018 7:19 PM] – FAILURE: Error! Failed to insert a new member record. This request will fail.
[11/16/2018 7:19 PM] – SUCCESS: Paypal class finished.

[mbrsolution]

Hi, the log file states the following as you already mentioned above.

[11/16/2018 7:19 PM] – FAILURE: Error! Failed to insert a new member record. This request will fail.

This means the account was not created for the member. Is this a new member? Is this the first time this has occurred in your site?

Can you also carry out the following troubleshooting test.

And also the following troubleshooting steps.

Let me know how you go with the above test.

Thank you

[Author]

Posts