Not receiving registration email

[dangermoose]

Hi, I’m new to eMember but been using eStore for quite a while. I’ve been through the documentation but just wanted to clarify a few things. This is where I’m currently at…

I’ve got only a single membership, Premium.

I set up a product for this in WP eStore (and added the eMember level ID to the product in the ‘Reference Text’ field)

I’ve got an eStore button on ‘Join Us’ page using the shortcode: [wp_eStore_add_to_cart id=4] which works fine.

At the moment I can make the purchase which goes through but not getting the registration link email. I just wondered if there is something I am missing – getting a bit confused if I should be configuring the email settings in eMember or eStore!

Does IPN need to be enabled in the PayPal account for the registration email to be sent?

If so, what url should I put in the IPN field in PayPal.

Should PDT also be enabled?

Thanks.

[Peter]

Hi, If you have eStore working on your site then don’t worry about PayPal IPN setup (it is already working otherwise eStore wouldn’t be working correctly).

Could you please enable debug for eStore and then do another purchase with an email address which doesn’t exist in your membership DB and then share the output for the following files:

ipn_handle _debug.log

subscription_handle_debug.log

See this link for how to enable debug:

https://support.tipsandtricks-hq.com/forums/topic/how-and-when-to-enable-debug-and-what-does-it-do

[dangermoose]

I’ve checked the log file from eStore and it looks like everything was successful.

I don’t think the below will tell you much but it appears there is something else at play, maybe server settings or something.

On thing however – I grabbed the registration URL from the subscription log and tried it in a browser. It took me to the ‘join-us’ page which just says Free membership is disabled on this site (which it is) & please visit the payment page. I also noticed there are no members added to the eMember list from the tests I have done. I will check on permissions, maybe the DB cannot be written to or something. I’ll report back just in case this helps anyone else.

This is the subscription_handle.log

[07/11/2012 8:11 AM] – SUCCESS :eMember ID is empty. Checking the database for existing record of this email address..

[07/11/2012 8:11 AM] – SUCCESS :Did not find record in the members table. A new member account will be created for: *******@hotmail.com

[07/11/2012 8:11 AM] – SUCCESS :Creating new member account

[07/11/2012 8:11 AM] – SUCCESS :Member signup URL :http://*******.co.uk/join-us/registration/?member_id=&code=ca4d12a106d61d755e38a928431ea39f

[07/11/2012 8:11 AM] – SUCCESS :Saving membership signup rego URL data for: *******@hotmail.com

[07/11/2012 8:11 AM] – SUCCESS :Membership signup rego URL data saved.

[07/11/2012 8:11 AM] – SUCCESS :Member signup/upgrade completion email successfully sent to:*******@hotmail.com From email address value used:******* <david@*******.co.uk>

ipn_handle.log

[07/11/2012 8:11 AM] – SUCCESS :Connection to http://www.paypal.com successfuly completed.

[07/11/2012 8:11 AM] – SUCCESS :IPN successfully verified.

[07/11/2012 8:11 AM] – SUCCESS :Creating product Information to send.

[07/11/2012 8:11 AM] – SUCCESS :Transaction Type: Shopping Cart

[07/11/2012 8:11 AM] – SUCCESS :Number of Cart Items: 1

[07/11/2012 8:11 AM] – SUCCESS :Item Number: 4

[07/11/2012 8:11 AM] – SUCCESS :Item Name: Multi Site Full Access

[07/11/2012 8:11 AM] – SUCCESS :Item Quantity: 1

[07/11/2012 8:11 AM] – SUCCESS :Item Price: 0.01

[07/11/2012 8:11 AM] – SUCCESS :Item Shipping: 0.00

[07/11/2012 8:11 AM] – SUCCESS :Item Currency: GBP

[07/11/2012 8:11 AM] – SUCCESS :eMember integration is being used… creating member account… see the “subscription_handle_debug.log” file for details

[07/11/2012 8:11 AM] – SUCCESS :Download Link :

Multi Site Full Access – This product does not have any downloadable content

[07/11/2012 8:11 AM] – SUCCESS :Incremental counter value for PayPal checkout: 4

[07/11/2012 8:11 AM] – SUCCESS :Applying filter – eStore_notification_email_body_filter

[07/11/2012 8:11 AM] – SUCCESS :Product Email successfully sent to *****@hotmail.com.

[07/11/2012 8:11 AM] – SUCCESS :Notify Email successfully sent to david@*****.co.uk.

[07/11/2012 8:11 AM] – SUCCESS :Updating Products, Customers, Coupons, Sales Database Tables with Sales Data.

[07/11/2012 8:11 AM] – SUCCESS :Current available copies value: Sales count value: 3

[07/11/2012 8:11 AM] – SUCCESS :New available copies value: New sales count value: 4

[07/11/2012 8:11 AM] – SUCCESS :Products, Customers, Coupons, Sales Database Tables Updated.

[07/11/2012 8:11 AM] – SUCCESS :Updating Affiliate Database Table with Sales Data if Using the WP Affiliate Platform Plugin.

[07/11/2012 8:11 AM] – SUCCESS :Not Using the WP Affiliate Platform Plugin.

[07/11/2012 8:11 AM] – SUCCESS :Paypal class finished.

[Peter]

Hi,

From what I can see in the logs it looks like eStore/eMember are working correctly.

I’m now wondering if it may be something with your host.

Which hosting provider are you with?

[admin]

You most likely have a database column out of sync issue whereby the member database records are not getting updated correctly. So even though the plugin is doing everything correctly the database (MySQL) update is failing silently.

Please check this post and do what it suggests to fix it:

https://support.tipsandtricks-hq.com/forums/topic/issues-related-to-database-table-columns-out-of-sync

[dangermoose]

I think you are spot on Admin, our tech guy had to alter some Database tables to get the member ID’s to be sent to the registration page correctly. Previously, when a purchase was made, the unique url didn’t contain any member ID so would direct the user to an incorrect page. To be honest I’m not sure exactly what he did but it seems to work now. I’ll try to get some more detail and report back. Thanks!

[Author]

Posts