Home › Forums › Community Forum › EOT NOT WORKING
Tagged: ccbill
This topic contains 14 replies, has 2 voices. Last updated by Jason (Lead Developer) 4 years, 10 months ago.
Topic Author | Topic |
---|---|
Posted: Thursday Feb 9th, 2012 at 1:58 am #4544 | |
|
|
Copy pasting this because my last response went ignored, which is frustrating. I’m considering doing a chargeback as this software has done nothing but cause me problems. Seriously, you guys need a real helpdesk that actually shows you read the tickets and has you respond to them. EOT is not working with CCBill. I don’t know why. It goes all the way back to September. Members are still “S2 Member Level 1″ even though they canceled their account months ago. EOT is activated and set to demote members, but it does nothing. I QUADRUPLE checked all of my settings. I’ve looked through the logs and can’t find any “errors” at first glance but either way have no idea what I’m looking for in the first place. The only thing close to an error I can find is this: array ( I replaced the IPN with x’s for privacy reasons. What does that mean? If the system can’t verify if a member has paid or not under a payment processor account, they should be DELETE OR DEMOTED! What is wrong with this? Lastly, the CCBill dl log shows “4 => ‘Error: Too many requests.’,” at times – not every time, but often – does s2member go back and do it again or what? |
List Of Topic Replies
Author | Replies |
---|---|
Author | Replies |
Posted: Thursday Feb 9th, 2012 at 2:00 am #4545 | |
|
|
I had to spend 4 hours copy/pasting back and forth with CCBill to manually demote over a 100 members who have gotten more than a free lunch. This is why I switched from other crappy membership plugins, and I’m finding S2member is just as crappy. |
|
Posted: Thursday Feb 9th, 2012 at 2:11 am #4547 | |
|
|
Wow, a customer from 2010 (via paypal through s2member) that’s been logging in every week was never demoted. I am seriously naive to think the product worked as advertised. What threw me off is that it works for “some” people that sign up. Out of every 3 customers it will probably demote 1 correctly. |
|
Posted: Thursday Feb 9th, 2012 at 7:07 am #4587 | |
|
|
Thanks for reporting this important issue. |
|
Posted: Thursday Feb 9th, 2012 at 7:44 am #4588 | |
|
|
Initial investigation complete. I’m sorry that a previous request went unanswered. Regarding this log entry you posted…
This indicates that s2Member was unable to locate a User/Member in your database matching the Paid Subscr. ID value of: 0111338701000028940. From your description, it sounds like this is happening to all of your existing members, which leads me to believe there is another underlying problem somewhere on your installation. Let’s start debugging this please, by first verifying if this member’s account DOES actually have the required meta values in your database, so that s2Member would be able to properly handle this DataLink communication on your installation. There are two ways to verify this: 1. You can log into your Dashboard and search your list of Users for this value: 2. Or, if you’d like to run a PHP code snippet somewhere, you could use the underlying s2Member method which appears to be failing on your installation, at least in the case of this Subscription.
s2Member is handling this properly, given the fact that it can’t locate an account in your database matching this Paid Subscr. ID value: 0111338701000028940 Why that is exactly, remains to be seen. But let’s take it one step at a time, until we determine through debugging why this particular transaction was not handled properly. If you’d like to send us a Dashboard login, we’ll run diagnostics for you.
This error can occur when/if s2Member attempts to connect to ccBill’s DataLink more than once within any 24 hour period. By default, s2Member will make an attempt to connect once per day, so it can avoid this error returned by the ccBill DataLink API. That being said, I’ve seen this error come up on other client installations as well. It seems that ccBill’s DataLink API may not always allow access, depending upon server load on their side, and this generic error is returned. I’ve also seen it occur due to changes in server time, or because of DST being in affect. In either case, s2Member will try again the next day automatically, and s2Member will pick back up where it left off, so that nothing is missed from the day prior. However, under extreme circumstances, this error CAN result in EOTs being missed. If ccBill continues to return this error on your installation, I would make an attempt to contact ccBill and ask why it’s happening over and over again. s2Member is only allowed to pull data from ccBill’s DataLink API for 1 day at a time. So if it misses two days completely, it could also miss EOTs that should have been processed for those days. This is a limitation in the ccBill DataLink API, which makes every effort to protect itself from being overloaded by incoming client requests. |
|
Posted: Thursday Feb 9th, 2012 at 5:22 pm #4679 | |
|
|
Hi, First, I talked to CCBill, you can do datalink requests every hour. S2member is doing them more than once an hour. Here’s an example:
This could easily be fixed by only running it once every 1 hour and 10 minutes or something. That way, you avoid the “too many requests” error which as of now, I think could be contributing to this problem. Secondly, this is not happening to every one of my customers. “Some” people are demoted, which is what threw me off and took me so long to find this error.
That specific customer was since deleted by me, but I manually demoted the others instead of deleting, for testing purposes. I looked up another log that said “1 => ‘Ignoring this DataLink IPN. No IPN signup vars for Subscr. ID: 0111338xxxxxx028940.’,” And then I looked up the customer number in my dashboard and the customer is there! In the dashboard!
|
|
Posted: Friday Feb 10th, 2012 at 12:49 am #4718 | |
|
|
Regarding your original accusation.
FYI: I just researched your previous post activity on our forums. I see that you’ve posted over 50 times in our forums and you’ve received responses numerous times, with well over 100 replies from myself and Support Reps such as Raam and Cristian. In fact, in many of your previous posts, you seemed quite satisfied with our support service. You are: CN (aka: ChuckNorris, is this correct?) I’d like you to address my previous question.
Yes, I stand corrected. It seems this may have changed at some point. The document here clearly states that ccBill’s DataLink service can receive connections every 60 minutes. Given the nature of this remote request to ccBill, we wouldn’t want to reconnect any more than we need to. Once each day is adequate for s2Member. A default installation of s2Member Pro will only make connections to the DataLink API once every 24 hours. As seen here in the source code for s2Member. /s2member-pro/includes/classes/separates/gateways/ccbill/ccbill-datalink.inc.php at line #72.
Very good. So the Subscr ID. is there. Now, what about the IPN Signup Vars? Did you check your database to see if s2Member has the IPN Signup Vars for this User/Member? If you’re not sure how to check the database, you can use this method provided by s2Member.
If you do check the database, what you’re looking for is the entry that s2Member stored in the wp_usermeta table with this meta_key “wp_s2member_ipn_signup_vars“. |
|
Posted: Monday Feb 13th, 2012 at 1:53 am #4929 | |
|
|
In fact, in many of your previous posts, you seemed quite satisfied with our support service. I’d like you to address my previous question. Here it is: http://www.s2member.com/forums/topic/eot-not-working/ I am happy with the support but please understand how unbelievably frustrating it is finding out months and months later that the software was not doing it’s job. It’s at least $1,000 down the drain. Of the 100 or so people I deleted, 4 of them signed up within a day of getting deleted, after getting 3 – 8 months free lunch. So if I seem snotty and frustrated, that’s why. Have you been able to reproduce this problem on a clean installation of WordPress, with only s2Member active, and with the default theme for WordPress? If so, please send us a Dashboard login and we’ll run diagnostics for you. No. I don’t know how I’m supposed to do that. Won’t I need a CCBill payment ID for someone or something? How exactly would I go about testing this on a clean install? Allow this file to override your existing copy of /s2member-pro/includes/classes/separates/gateways/ccbill-datalink.inc.php I believe the correct path was s2member-pro/includes/classes/gateways/ccbill/ccbill-datalink.inc.php – for future reference. “If you do check the database, what you’re looking for is the entry that s2Member stored in the wp_usermeta table with this meta_key “wp_s2member_ipn_signup_vars“.” I checked the database, searched by the CCBill ID, and this is what I found: 1 match: http://www.imagebam.com/image/112e53174519785 It does not say “wp_s2member_ipn_signup_vars“ – it says “wp_s2member_subscr_id”. That was for a demoted customer at “Subscriber”. I searched for wp_s2member_ipn_signup_vars and found 127 matches, which is close to the 132 S2member 1 Level members I have. Upon opening one of the ipn signup vars members, the meta value says this:
I put xxx’s for privacy. |
|
Posted: Tuesday Feb 14th, 2012 at 10:57 pm #5143 | |
|
|
I sent the s2 debug log |
|
Posted: Thursday Feb 16th, 2012 at 2:29 am #5320 | |
|
|
Debug log received. Thank you. |
|
Posted: Thursday Feb 16th, 2012 at 2:28 pm #5394 | |
|
|
Thank you. OK, I’ve taken a look at your full reply and I’ve also investigated the results that you came up with from your database. It sounds like all of the data that s2Member needs is available in your database, but for some reason, which is yet to be determined, this data is unavailable to s2Member at runtime. At this point I have to assume this is a plugin conflict somewhere. Here is why I’ve drawn this conclusion. So far, I’ve been unable to reproduce it on a clean installation. We have many other site owners running s2Member together with ccBill. To my knowledge, this issue has never been reported before. In the debug log that you ran for me, I find results like this:
This indicates that s2Member’s attempt to pull details from the database failed, through the core WordPress function This is abnormal behavior, and between this odd occurrence, and the issues you’re reporting with IPN Signup Vars not being found either, through the s2Member’s inability to pull information that it expects to have available in the database is likely to result in the types of issues that you’re reporting. In fact, this is likely to produce all sorts of very strange behaviors, including many failed attempts to process one thing or another internally. My suggestion would be to disable other plugins on your installation, and/or revert to the default theme for WordPress. You may also want to post a list of all the other plugins you’re running, so we can review those with you. It’s very difficult to debug things like this when there are many other plugins and/or a custom theme in the mix, but we’ll try to help you identify anything that might jump right out at us, as being something that would likely conflict with s2Member in a serious way. Alternatively, you could setup a test site where you clone your existing site, minus all other plugins, and set your theme to the default theme for WordPress. However, please keep in mind that any plugin conflicts that have existed on your installation, could have also affected your existing database. So, at this point, cloning the site might not correct all of the issues either, if your underlying database has become corrupt in some way. From what I’ve seen so far, I don’t think that’s happened, but just to be aware of this possibility.
Thank you very much. I’ve just finished investigating this as well. Totally our fault, and I’m very sorry for this. I’ve spoken to Cristian/Raam about this. It appears your ticket came into our new Customer Support Forum the day after the launch of this new site, and it was escalated to me. I overlooked your ticket and I’m very sorry about that.
Yes, please know that we understand why you would be frustrated. However, there are some things beyond our control also. Let’s work together and find out what’s happening on your installation. If it’s something that can be corrected on our end, we’ll certainly make that happen. At this point however, there appears to be some abnormal functionality on your end, which is something that really can’t plan for. Right now we’re trying to help you find the source of the underlying cause, which I suspect to be a plugin conflict. As a next step, let’s take a look at your list of other plugins. |
|
Posted: Friday Feb 17th, 2012 at 1:25 am #5453 | |
|
|
Hi, Here’s the list of plugins: I’ve disabled other plugins that I do not need. At the bottom of the second image I disabled Scheduled Posts MIA-s. That’s the only one that I can think of which runs a cron or something like that to make sure future posts aren’t “missed” and get published – had a big problem with future posts not posting so installed that. Anyways, it’s deactivated now. I’ve used multiple themes. The problem is happening on all of them. “Pretty Theme” is one of them. http://wordpress.org/extend/themes/pretty-theme |
|
Posted: Wednesday Feb 22nd, 2012 at 7:40 pm #6023 | |
|
|
I see under EOT it gives me the option “Yes, but I’ll run with my own cron”. Can I have the instructions on doing this please? Thank you |
|
Posted: Thursday Feb 23rd, 2012 at 1:18 am #6054 | |
|
|
Reviewing this support request. |
|
Posted: Thursday Feb 23rd, 2012 at 2:57 am #6073 | |
|
|
Sure. You’ll want to grab the CRON URL from your own Dashboard though. You can find that in your EOT Behavior options. Just choose that option from the list and a message will appear just above that field with the URL that’s required. Yours will look something like this:
Schedule the CRON job to run at least once each day please. Dashboard -› s2Member® -› ccBill® Options -› Automatic EOT Behavior |
This topic is closed to new replies. Topics with no replies for 2 weeks are closed automatically.