eMember – Changing Member User Name

[jmwalker1111]

I have two sites that run eMember. On one (therapeuticcommuniities.org) I have been able to go in through phpMyAdmin and change the user name of my members in the wp_gdot_wp_eMember_members_tbl table. However on the other site (raphajourney.com), when I look at phpMyAdmin that table is not present.

Is there any way I can change the user name of one of my members without going through that table? And if not, is there a reason that table isn’t present?

Thank you.

[wzp]

“wp_gdot_” is the prefix name for your site’s MySQL tables, and “wp_eMember_members_tbl” is the actual table name. So on the second site, you need to first look in the wp_config.php file for the line that defines the $table_prefix variable. Whatever that value is, prepend it to “wp_eMember_members_tbl” and you will now know what table to look for.

[jmwalker1111]

Thank you for the response. I do understand the prefix name for my other site is wp_wapt. However even with that information this wp_eMember_members_tbl does not exist. The only eMember tables are emember_openid_lookup and emember_uploads.

It doesn’t seem possible but that is all that is listed there.

[admin]

There has to be a table called eMember_members_tbl in the database. Thats where hte plugin stores all the member’s info. If you do have the plugin installed and it is working correctly then you must not be looking at the correct place.

When you add a new member, all the info goes to that members table. Without it, you won’t see any member record if you go to the members menu.

[jmwalker1111]

I do understand that the table has to be there, but where I usually can find it on one site (therapeuticcommunities.org), I can’t find it on the other (raphajourney.com). I am looking at the tables for my site, but it is not listed there. I’m sure I must be doing something wrong but I don’t know where else to look for it. I’m happy to send you screen shots of both sites so you can see what I am looking at. Is there another way to find these tables? Thank you for your help!

[wzp]

Is there a table called wp_wapt_eMember_members_tbl in the database?

[jmwalker1111]

No that table is not present when I view my site through phpMyAdmin. I know it should be there but it isn’t so I am not sure where the problem lies.

[admin]

Do the following which can take care of any database table issues:

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

Go to PHPMyAdmin tables list. Search with the eMember key work in there. What tables do you see that has the emember keyword?

Are you looking in the correct database? If you have multiple WordPress installs in that one domain, you will likely have multiple databases. So make sure to look in the correct one.

When you go to the members menu of the plugin, you do see members record in there correct? If you do member profile data in the members menu of the plugin then that means the data is definitely there you are just not looking in the correct database table.

[jmwalker1111]

When I look at my site and search for emember through phpMyAdmin I see only two tables, they are emember_openid_lookup and emember_uploads. I am looking at the right database, but the members table is just not there. I know it should be (because I see them on another site I run) but they aren’t there. Where else could they be??

The members records are working ok on the website except I have one member that I can’t go in and update manually. When I try it tells me that her email address is already registered to a user. She has been a member for a couple of years, and this email address is only attached to this eMember account and only her WP User account, so as far as I can tell this error should not be happening. I thought if I could find the table I could update her account through that.

I am not sure if the two issues are related but I need to find a solution for both.

Thanks for your help!

[admin]

You will need to get help from your hosting provider for this. Tell them the following:

The plugin is rendering the members info in the members menu of the plugin. This data comes from the eMember_members_tbl database table. However, I can’t find that database table on my server.

[Author]

Posts