Membership Plugin

WordPress Membership Plugin

  • Home
  • Documentation
  • Addons
  • Support
    • Quick Setup
    • Documentation
    • Premium Addon Support
    • Paid Support
    • Support Forum
    • Support Forum Search
    • Forum Login
    • Forum Registration
  • Contact

[Support request] Failed to insert a new member record.

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.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • December 26, 2019 at 12:33 am #19521
    rivka
    Participant

    Hi, 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&notify_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&notify_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&notify_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&notify_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 #19531
    mbrsolution
    Moderator

    Hi,

    Can you carry out the following troubleshooting steps.

    https://simple-membership-plugin.com/forums/topic/test-for-plugin-and-theme-conflict-before-posting-an-issue-or-a-bug/

    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

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Log In

Please read this message before using our plugin.

Search

Featured Addons and Extensions

  • Membership Form Builder Addon
  • Member Directory Listing Addon
  • WooCommerce Payment Integration
  • Member Data Exporter Addon

Documentation

  • Documentation Index Page

Copyright © 2026 | Simple Membership Plugin | Privacy Policy