User Export is breaks site

[catapultimpact]

I have User Meta Pro and have been using the Import/Export feature to export users from one site and import into another site. I also have custom user roles for members and am using the feature to have all the user roles checked except for the user roles I want to export out. The problem I am running into is about 80% of the time, when I run an export of users, it will not save any file. Instead the export action will just freeze the site.

The only way to stop the freeze is to stop the load in the browser and refresh the page. It seems that seems to break the site. By doing this, it is causing an issue with the database for the site. Seems to break the wp_users and wp_usermeta tables. This effects the whole site, and makes it so the site goes down.

Please advise!

[catapultimpact]

I got this not from the guy hosting our site:

“It’s really not clear what is happening. As we looked at it closer, it’s not that the table is corrupt, it’s just… frozen. I’ve never seen something quite like this… I tried just restarting mysql without loading a backup and it worked. I’d suspect a weird table locking issue that never gets unlocked, but that usually prevents writes, not reads. While eastonprostaff.com is the only site that goes down (since it’s never able to read from the user table), there are a few server-wide effects (one of which is having to restart mysql to get the eastonprostaff going again) so we really need to try and make sure the issue is resolved before running it again.”

[Khaled]

Hi,

Until now, when you click export users, it tries to load all users data and put it onto csv files. I assume, you have a large numbers of Users that you tried to export. With future release, we shall introduce progressive users export. Until then, please try to filter users by date to maintain small numbers of users on a single export while exporting.

Thanks.

[catapultimpact]

We have just over 1K users. When I try to limit the number of users by deselecting only the User Roles I want exported out, that is when I get the error. When I export out the whole list, it seems to export out fine — so the solution that I have found is actually not limiting the user export at all… which really isn’t a solution. It seems to be a more of a bug with the plugin. Please advise.

[Khaled]

Did you tried version 1.1.7?

[catapultimpact]

Not yet. What has been fixed in the latest release that could fix this issue? I looked through the changelog updates and didn’t see anything listed that seems like it would effect/fix this bug.

Do you advise updating? Is it safe to update?

• This reply was modified 9 years, 6 months ago by catapultimpact.
• This reply was modified 9 years, 6 months ago by catapultimpact.

[Khaled]

I recommend v1.1.7, although there are not major update for users export issue but latest version has major ui and functionality improvement with bug fixes. And it is safe to update, you will not lose any user’s data. Just completely remove existing user-meta directory and then upload new user-meta files.

Thanks.

[catapultimpact]

Okay. But in regards to the issue at hand — what are the next steps to getting support on this issue? Do I need to create a support ticket to get you to look into what could be causing this?

[Khaled]

You can add a support ticket. I’ll inform you with update.

[Ganga River]

Same issue here

we have over 1400 members and everything freezes when I try to export the list

thank you!

[corbettreport]

I’m just getting a blank screen when I try to export out my users.

[Author]

Posts