Simple Membership Plugin › Forums › Simple Membership Plugin › Failed to insert a new member record.
- This topic has 1 reply, 2 voices, and was last updated 6 years, 11 months ago by
mbrsolution.
-
AuthorPosts
-
December 26, 2019 at 12:33 am #19521
rivka
ParticipantHi, I’ve been trying for a long time to understand why I can’t make new friends. Of all the attempts I made, I only succeeded once.
I set up IPN on PAYPAL. UTF-8 also.
I use the Astra themes.
Can the fact that my clients use Hebrew language create a problem in the process of adding the user?
Attaches the report:[12/09/2019 12:11 PM] – SUCCESS: Paypal Class Initiated by 66.211.170.66
[12/09/2019 12:11 PM] – SUCCESS: Post string : mc_gross=3.00&protection_eligibility=Eligible&payer_id=4VFC9KBMLAQ88&payment_date=04%3A11%3A37+Dec+09%2C+2019+PST&payment_status=Completed&charset=windows-1255&first_name=%F8%E1%F7%E4&mc_fee=1.30¬ify_version=3.9&custom=subsc_ref%253D2%2526user_ip%253D213.151.40.46&payer_status=verified&business=rivka017%40gmail.com&quantity=1&verify_sign=ARNPIWr0DsE-wHEK-aayWcjmj-.2ACF7wq6G9V8VLdHRJQwDdkkJNz4u&payer_email=shopping.rivka%40gmail.com&txn_id=2HB024379D5090505&payment_type=instant&last_name=%EC%E5%E9&receiver_email=rivka017%40gmail.com&payment_fee=&shipping_discount=0.00&receiver_id=3CU77A4Q59B5W&insurance_amount=0.00&txn_type=web_accept&item_name=Subscriber&discount=0.00&mc_currency=ILS&item_number=1276&residence_country=IL&shipping_method=Default&transaction_subject=&payment_gross=&ipn_track_id=44f4ef927e7e0&
[12/09/2019 12:11 PM] – SUCCESS: Checking if PayPal IPN response is valid
[12/09/2019 12:11 PM] – SUCCESS: Connecting to: https://www.paypal.com/cgi-bin/webscr
[12/09/2019 12:11 PM] – SUCCESS: IPN successfully verified.
[12/09/2019 12:11 PM] – SUCCESS: Creating product Information to send.
[12/09/2019 12:11 PM] – SUCCESS: Transaction Type: Buy Now/Subscribe
[12/09/2019 12:11 PM] – SUCCESS: Item Number: 1276
[12/09/2019 12:11 PM] – SUCCESS: Item Name: Subscriber
[12/09/2019 12:11 PM] – SUCCESS: Item Quantity: 1
[12/09/2019 12:11 PM] – SUCCESS: Item Total: 3.00
[12/09/2019 12:11 PM] – SUCCESS: Item Currency: ILS
[12/09/2019 12:11 PM] – SUCCESS: Membership payment paid for membership level ID: 2
[12/09/2019 12:11 PM] – SUCCESS: Transaction type: web_accept. Creating member account…
[12/09/2019 12:11 PM] – SUCCESS: swpm_handle_subsc_signup_stand_alone(). Custom value: subsc_ref=2&user_ip=213.151.40.46, Unique reference: 2HB024379D5090505
[12/09/2019 12:11 PM] – SUCCESS: Could not find any record using the given email address (shopping.rivka@gmail.com). Attempting to query database using the unique reference: 2HB024379D5090505
[12/09/2019 12:11 PM] – SUCCESS: Did not find a match for an existing member profile for the given reference. This must be a new payment from a new member.
[12/09/2019 12:11 PM] – SUCCESS: Creating new member account. Membership level ID: 2, Subscriber ID value: 2HB024379D5090505
[12/09/2019 12:11 PM] – FAILURE: Error! Failed to insert a new member record. This request will fail.
[12/09/2019 12:11 PM] – SUCCESS: Saving transaction data to the database table.
[12/09/2019 12:11 PM] – SUCCESS: Transaction data saved.
[12/09/2019 12:11 PM] – SUCCESS: Paypal class finished.——————————————————————
[12/09/2019 12:14 PM] – SUCCESS: Paypal Class Initiated by 173.0.81.1
[12/09/2019 12:14 PM] – SUCCESS: Post string : mc_gross=3.00&protection_eligibility=Eligible&payer_id=ZFNEXP2H3XKVY&payment_date=04%3A14%3A17+Dec+09%2C+2019+PST&payment_status=Completed&charset=windows-1255&first_name=yaniv&mc_fee=1.30¬ify_version=3.9&custom=subsc_ref%253D2%2526user_ip%253D213.57.109.24&payer_status=verified&business=rivka017%40gmail.com&quantity=1&verify_sign=AcOVEV4eGrhfF4dAb5pRxjitadYfAMMcq1rJFEvmdrIZ.MzMoRWBLrLN&payer_email=greenyaniv%40gmail.com&txn_id=8FD30863SH4074925&payment_type=instant&last_name=green&receiver_email=rivka017%40gmail.com&payment_fee=&shipping_discount=0.00&receiver_id=3CU77A4Q59B5W&insurance_amount=0.00&txn_type=web_accept&item_name=Subscriber&discount=0.00&mc_currency=ILS&item_number=1276&residence_country=IL&shipping_method=Default&transaction_subject=&payment_gross=&ipn_track_id=a46b3580b9232&
[12/09/2019 12:14 PM] – SUCCESS: Checking if PayPal IPN response is valid
[12/09/2019 12:14 PM] – SUCCESS: Connecting to: https://www.paypal.com/cgi-bin/webscr
[12/09/2019 12:14 PM] – SUCCESS: IPN successfully verified.
[12/09/2019 12:14 PM] – SUCCESS: Creating product Information to send.
[12/09/2019 12:14 PM] – SUCCESS: Transaction Type: Buy Now/Subscribe
[12/09/2019 12:14 PM] – SUCCESS: Item Number: 1276
[12/09/2019 12:14 PM] – SUCCESS: Item Name: Subscriber
[12/09/2019 12:14 PM] – SUCCESS: Item Quantity: 1
[12/09/2019 12:14 PM] – SUCCESS: Item Total: 3.00
[12/09/2019 12:14 PM] – SUCCESS: Item Currency: ILS
[12/09/2019 12:14 PM] – SUCCESS: Membership payment paid for membership level ID: 2
[12/09/2019 12:14 PM] – SUCCESS: Transaction type: web_accept. Creating member account…
[12/09/2019 12:14 PM] – SUCCESS: swpm_handle_subsc_signup_stand_alone(). Custom value: subsc_ref=2&user_ip=213.57.109.24, Unique reference: 8FD30863SH4074925
[12/09/2019 12:14 PM] – SUCCESS: Could not find any record using the given email address (greenyaniv@gmail.com). Attempting to query database using the unique reference: 8FD30863SH4074925
[12/09/2019 12:14 PM] – SUCCESS: Did not find a match for an existing member profile for the given reference. This must be a new payment from a new member.
[12/09/2019 12:14 PM] – SUCCESS: Creating new member account. Membership level ID: 2, Subscriber ID value: 8FD30863SH4074925
[12/09/2019 12:14 PM] – SUCCESS: Member signup URL: https://herayon-tv.co.il/membership-join/membership-registration/?member_id=2&code=06ff242beaa5f9d4edd1f7e4a5b72233
[12/09/2019 12:14 PM] – SUCCESS: Member signup (prompt to complete registration) email successfully sent to: greenyaniv@gmail.com
[12/09/2019 12:14 PM] – SUCCESS: Saving transaction data to the database table.
[12/09/2019 12:14 PM] – SUCCESS: Transaction data saved.
[12/09/2019 12:14 PM] – SUCCESS: Paypal class finished.——————————————————————
[12/09/2019 8:26 PM] – SUCCESS: Paypal Class Initiated by 66.211.170.66
[12/09/2019 8:26 PM] – SUCCESS: Post string : mc_gross=-3.00&protection_eligibility=Eligible&payer_id=ZFNEXP2H3XKVY&payment_date=12%3A26%3A03+Dec+09%2C+2019+PST&payment_status=Refunded&charset=windows-1255&first_name=yaniv&mc_fee=-1.30¬ify_version=3.9&reason_code=refund&custom=subsc_ref%253D2%2526user_ip%253D213.57.109.24&business=rivka017%40gmail.com&verify_sign=A6.B8VIlri5lyREu9.rbullJdB3lAQ8sYWnFF693UgCs9n6378j3twOZ&payer_email=greenyaniv%40gmail.com&parent_txn_id=8FD30863SH4074925&txn_id=97P48862P8588401K&payment_type=instant&last_name=green&receiver_email=rivka017%40gmail.com&payment_fee=&shipping_discount=0.00&receiver_id=3CU77A4Q59B5W&insurance_amount=0.00&item_name=Subscriber&discount=0.00&mc_currency=ILS&item_number=1276&residence_country=IL&handling_amount=0.00&shipping_method=Default&transaction_subject=&payment_gross=&shipping=0.00&ipn_track_id=69fb080010c9f&
[12/09/2019 8:26 PM] – SUCCESS: Checking if PayPal IPN response is valid
[12/09/2019 8:26 PM] – SUCCESS: Connecting to: https://www.paypal.com/cgi-bin/webscr
[12/09/2019 8:26 PM] – SUCCESS: IPN successfully verified.
[12/09/2019 8:26 PM] – SUCCESS: Creating product Information to send.
[12/09/2019 8:26 PM] – SUCCESS: This is a refund notification. Refund amount: -3.00
[12/09/2019 8:26 PM] – SUCCESS: Refund/Cancellation check – lets see if a member account needs to be deactivated.
[12/09/2019 8:26 PM] – SUCCESS: Updating the account status value of member (2) to: inactive
[12/09/2019 8:26 PM] – SUCCESS: Subscription refund notification received! Member account deactivated.
[12/09/2019 8:26 PM] – SUCCESS: Paypal class finished.——————————————————————
[12/09/2019 9:08 PM] – SUCCESS: Prompt to complete registration email sent to: greenyaniv@gmail.com. From email address value used: office@herayon-tv.co.ilג€ג€¬
[12/24/2019 7:14 PM] – SUCCESS: Paypal Class Initiated by 173.0.81.1
[12/24/2019 7:14 PM] – SUCCESS: Post string : mc_gross=3.00&protection_eligibility=Ineligible&payer_id=3YT8CYRGS2P36&payment_date=11%3A14%3A49+Dec+24%2C+2019+PST&payment_status=Completed&charset=windows-1255&first_name=%F8%E1%F7%E4&mc_fee=1.30¬ify_version=3.9&custom=subsc_ref%253D2%2526user_ip%253D213.151.40.46&payer_status=unverified&business=rivka017%40gmail.com&quantity=1&verify_sign=AM8GcfjYnxpCPnTrk69qa9NakHl6A5Rfm82DII41ISIh9wW41kPvBeN-&payer_email=danilevi18%40gmail.com&txn_id=4DA31670YL5747152&payment_type=instant&last_name=%EC%E5%E9&receiver_email=rivka017%40gmail.com&payment_fee=&shipping_discount=0.00&receiver_id=3CU77A4Q59B5W&insurance_amount=0.00&txn_type=web_accept&item_name=Subscriber&discount=0.00&mc_currency=ILS&item_number=1276&residence_country=IL&receipt_id=3668-0075-7943-3873&shipping_method=Default&transaction_subject=&payment_gross=&ipn_track_id=8ca5620730b7e&
[12/24/2019 7:14 PM] – SUCCESS: Checking if PayPal IPN response is valid
[12/24/2019 7:14 PM] – SUCCESS: Connecting to: https://www.paypal.com/cgi-bin/webscr
[12/24/2019 7:14 PM] – SUCCESS: IPN successfully verified.
[12/24/2019 7:14 PM] – SUCCESS: Creating product Information to send.
[12/24/2019 7:14 PM] – SUCCESS: Transaction Type: Buy Now/Subscribe
[12/24/2019 7:14 PM] – SUCCESS: Item Number: 1276
[12/24/2019 7:14 PM] – SUCCESS: Item Name: Subscriber
[12/24/2019 7:14 PM] – SUCCESS: Item Quantity: 1
[12/24/2019 7:14 PM] – SUCCESS: Item Total: 3.00
[12/24/2019 7:14 PM] – SUCCESS: Item Currency: ILS
[12/24/2019 7:14 PM] – SUCCESS: Membership payment paid for membership level ID: 2
[12/24/2019 7:14 PM] – SUCCESS: Transaction type: web_accept. Creating member account…
[12/24/2019 7:14 PM] – SUCCESS: swpm_handle_subsc_signup_stand_alone(). Custom value: subsc_ref=2&user_ip=213.151.40.46, Unique reference: 4DA31670YL5747152
[12/24/2019 7:14 PM] – SUCCESS: Could not find any record using the given email address (danilevi18@gmail.com). Attempting to query database using the unique reference: 4DA31670YL5747152
[12/24/2019 7:14 PM] – SUCCESS: Did not find a match for an existing member profile for the given reference. This must be a new payment from a new member.
[12/24/2019 7:14 PM] – SUCCESS: Creating new member account. Membership level ID: 2, Subscriber ID value: 4DA31670YL5747152
[12/24/2019 7:14 PM] – FAILURE: Error! Failed to insert a new member record. This request will fail.
[12/24/2019 7:14 PM] – SUCCESS: Saving transaction data to the database table.
[12/24/2019 7:15 PM] – SUCCESS: Transaction data saved.
[12/24/2019 7:15 PM] – SUCCESS: Paypal class finished.December 27, 2019 at 3:37 am #19531mbrsolution
ModeratorHi,
Can you carry out the following troubleshooting steps.
If the above does not help, can you deactivate the plugin and then activate it again. Then try to register a new member. Let me know what happens.
Thank you
-
AuthorPosts
- You must be logged in to reply to this topic.