Community Support Forums

Re: Free Registration Numbers Wrong

2011-10-01T14:47:51-05:00

Thanks for the updates.

I've taken a closer look at this, but so ar I've been unable to reproduce this behavior outside the installation reported in this ticket. If anyone has this problem, please report it here so we can continue to look for anything within s2Member that may or may not be causing this.

At this time, I have to assume this behavior is a result of object caching plugins not keeping SQL updates in-sync properly, possibly leaving a corrupted database in its path. My advice, don't use W3 Total Cache for object caching. Either that, or don't use W3 Total Cache at all, go with Quick Cache.

Statistics: Posted by Jason Caldwell — October 1st, 2011, 2:47 pm

Re: Free Registration Numbers Wrong

2011-09-27T23:19:39-05:00

seofeed wrote:
That hack is turned off because of the other outstanding issues I have

Got it.

OK, regarding this problem, are you using a caching plugin? Have you tried disabling it to see if that solves the problem?

In case that was the cause, you may want to try another caching plugin like Jason's Quick Cache. https://wordpress.org/extend/plugins/quick-cache/

Statistics: Posted by Cristián Lávaque — September 27th, 2011, 11:19 pm

Re: Free Registration Numbers Wrong

2011-09-27T19:02:26-05:00

Never mind. I found your previous email.

Statistics: Posted by Jason Caldwell — September 27th, 2011, 7:02 pm

Re: Free Registration Numbers Wrong

2011-09-27T18:41:54-05:00

Thanks for the follow-ups. Sorry for the delayed response.
OK. Can you please submit a Dashboard login for me here?
http://www.s2member.com/contact/

Statistics: Posted by Jason Caldwell — September 27th, 2011, 6:41 pm

Re: Free Registration Numbers Wrong

2011-09-25T12:35:36-05:00

That hack is turned off because of the other outstanding issues I have

Statistics: Posted by seofeed — September 25th, 2011, 12:35 pm

Re: Free Registration Numbers Wrong

2011-09-24T22:38:47-05:00

You're using the auto-login after registration hack, right? Have you tried without it to see if that's what's causing this problem?

Statistics: Posted by Cristián Lávaque — September 24th, 2011, 10:38 pm

Re: Free Registration Numbers Wrong

2011-09-23T11:21:03-05:00

Should have been more specific. The exact thing were capabilities are added twice is happening again. It didn't happen on the first few and then it started again. Nothing changed on our end. I have no idea here.

Statistics: Posted by seofeed — September 23rd, 2011, 11:21 am

Re: Free Registration Numbers Wrong

2011-09-23T10:13:41-05:00

This issue is happening again. It's creating 3 entries for first name and last name.

Statistics: Posted by seofeed — September 23rd, 2011, 10:13 am

Re: Free Registration Numbers Wrong

2011-09-12T22:57:14-05:00

Just tested it again before changing theme per your suggestion and it worked fine. Who knows man. Maybe the object caching wasn't being respected yet when I tested it before. Will let you know if something else happens but something tells me object caching was the problem. Thanks so much for your help and wonderful support! Anyone reading should buy the Pro version.

Statistics: Posted by seofeed — September 12th, 2011, 10:57 pm

Re: Free Registration Numbers Wrong

2011-09-12T17:32:56-05:00

Have you tested this with a default theme for WordPress® too? Like plugins, themes come with a functions.php file which could potentially cause conflicts as well. If you can please run your test with the default theme for WordPress® and report back with your findings. If the problem persists, I'll be happy to take another look at your database.

Statistics: Posted by Jason Caldwell — September 12th, 2011, 5:32 pm

Re: Free Registration Numbers Wrong

2011-09-09T22:45:37-05:00

Ok, still having the problem.

Of course, removing all the duplicates reports the numbers correctly and it now lists 20 users on the page instead of 11 like before. I added a test user and the count only increased by one but that was through the 'Add User' form in wp-admin

Tried using the Pro Form here: http://bit.ly/pulOZn and it added two entries again. So the issue still remains.

Once again, disabled object caching and it still only happens for the subscriber level. Back to square one

Statistics: Posted by seofeed — September 9th, 2011, 10:45 pm

Re: Free Registration Numbers Wrong

2011-09-09T22:25:24-05:00

Also, find it incredibly odd it only happens with the subscriber level and no others

Statistics: Posted by seofeed — September 9th, 2011, 10:25 pm

Re: Free Registration Numbers Wrong

2011-09-09T22:18:04-05:00

RE: Your email. No I hadn't seen this. I'll try your solution and I'll pretty quickly if it keeps happening. Just disabled object caching W3 Total Cache as well.

Statistics: Posted by seofeed — September 9th, 2011, 10:18 pm

Re: Free Registration Numbers Wrong

2011-09-06T14:34:25-05:00

Thanks for your patience.
I've just finished taking a look at your database.

This problem is caused by a corrupted database.
If you load up phpMyAdmin for your database, and go to the SQL tab at the top.

Paste this in and press GO.

Code:: SELECT * FROM `wp_usermeta` WHERE `meta_key` LIKE 'wp_capabilities' ORDER BY `wp_usermeta`.`user_id` DESC

You'll notice there are duplicate entries for wp_capabilities in your wp_usermeta table, and this is why the numbers are coming out wrong within WordPress. You can rid yourself of this problem, by going through the list of entries and deleting the duplicates.

How did this happen? I'm not sure. I can tell you this is the first time this issue has been reported, and I'm not aware of anything in the s2Member plugin that would cause this. My best guess is that the plugin you're running W3 Total Cache, which has "Object Caching" enabled, somehow caused this, either directly or indirectly, but it's really difficult to say for sure, that's really just a wild guess at this point. If you can pin this to a specific plugin or plugin combination, please report back and let us know!

Statistics: Posted by Jason Caldwell — September 6th, 2011, 2:34 pm

Re: Free Registration Numbers Wrong

2011-09-06T13:19:51-05:00

Thanks for your patience.
I'm just about to take a look this now.

Statistics: Posted by Jason Caldwell — September 6th, 2011, 1:19 pm

Re: Free Registration Numbers Wrong

2011-09-06T08:55:29-05:00

Hey Guys, hadn't heard back from the contact form submission and wanted to followup. Thanks!

Statistics: Posted by seofeed — September 6th, 2011, 8:55 am

Re: Free Registration Numbers Wrong

2011-09-01T03:34:24-05:00

Sent, thanks!

Statistics: Posted by seofeed — September 1st, 2011, 3:34 am

Re: Free Registration Numbers Wrong

2011-08-31T22:02:37-05:00

OK. Great. Thanks for reporting back.

This is the first time that I've seen this reported, and it is indeed very strange. My first thought would be that you had a plugin conflict on your site at one point, which has damaged the integrity of your database somehow. It's hard to know for sure though. Yes, if possible, please send me access to your phpMyAdmin interface via this private contact form so we can take a look: http://www.s2member.com/contact/

Statistics: Posted by Jason Caldwell — August 31st, 2011, 10:02 pm

Re: Free Registration Numbers Wrong

2011-08-31T13:43:26-05:00

I have the Pro Version. Can this conversation go private so I can share more information with you easily?

We're making progress now. The wp_users reports the correct number of users.

But S2Member says it is 209 users (users page):

The export says it is 209 members as well:

Now, the issue I found when exporting. Every one of the subscriber role members are listed twice and what's more is their first name and last name is missing. Their display name shows up but the firstname, lastname field is empty. Obviously, these dupes in S2Member are causing the wrong numbers to be reported.

This is only an issue with the subscriber role. It works fine for every other role. So we've found the problem. Now, how to fix it and prevent it from happening in the future?

I can't upload a screenshot because it would contain usernames, names, etc... I can send it somewhere if you want me too.

Statistics: Posted by seofeed — August 31st, 2011, 1:43 pm

Re: Free Registration Numbers Wrong

2011-08-31T12:54:38-05:00

OK. Thank you. It's really starting to sound like a corrupted database to me. I would suggest that you use your hosting control panel to locate the phpMyAdmin interface for your server. This will allow you to investigate the wp_users table directly, and perhaps you can make since from that approach.

wp-users.png
Either that, or if you have s2Member Pro, pull an export of all Users and examine the resulting file. With s2Member Pro installed, this tool is available in your Dashboard, under: s2Member -> Import/Export.

Statistics: Posted by Jason Caldwell — August 31st, 2011, 12:54 pm

Re: Free Registration Numbers Wrong

2011-08-31T12:42:27-05:00

No, never been enabled. I just see this text in Multi-site config for S2Member:

Your WordPress® installation does not have Multisite Networking enabled.
Which is perfectly OK Multisite Networking is 100% completely optional.

Statistics: Posted by seofeed — August 31st, 2011, 12:42 pm

Re: Free Registration Numbers Wrong

2011-08-30T22:28:40-05:00

Hmm. That's really weird. Did you at any point have Multisite Networking enabled for WordPress?

Statistics: Posted by Jason Caldwell — August 30th, 2011, 10:28 pm

Re: Free Registration Numbers Wrong

2011-08-30T20:41:48-05:00

It shows the same wrong number that I see on the users page. The other levels report correctly. I've tried running repairs on the database and all tables have reported ok.

Statistics: Posted by seofeed — August 30th, 2011, 8:41 pm

Re: Free Registration Numbers Wrong

2011-08-30T16:04:57-05:00

Thanks for the follow-up.

seofeed wrote:
Hey Jason, unfortunately not on Multisite. It's a plain old setup with the Optimize Wootheme and backed by S2Member.

Gotchya. Hmm, that's not good then, it's beginning to look like maybe your database has become corrupted somehow. Let's take a look at this first though...

Please create this directory and temporary file:
/wp-content/mu-plugins/s2-hacks.php

Code:: add_action("init", "s2_debug"); function s2_debug(){ echo count(get_users("role=subscriber")); } ?>

Now load up your site and see what the count shows. Is it right, or wrong? Also, you might try changing the Role value to see other counts. For instance: s2member_level1, s2member_level2, s2member_level3, etc. Also see: http://codex.wordpress.org/Function_Reference/get_users

Statistics: Posted by Jason Caldwell — August 30th, 2011, 4:04 pm

Re: Free Registration Numbers Wrong

2011-08-29T22:50:47-05:00

Hey Jason, unfortunately not on Multisite. It's a plain old setup with the Optimize Wootheme and backed by S2Member.

Statistics: Posted by seofeed — August 29th, 2011, 10:50 pm