WordPress.org

Ready to get started?Download WordPress

Forums

Export User Data
[resolved] White page (30 posts)

  1. ulises2010
    Member
    Posted 5 months ago #

    This plugin looks like I'm looking for, but I install it, and when I try to export all my users (I have almost 9000) only have a white page... :-(

    http://wordpress.org/plugins/export-user-data/

  2. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    Hi,

    A white page is usually caused by a PHP error - so, please enable error logging ( http://codex.wordpress.org/Debugging_in_WordPress ) and then post back some error reports which are relevant to this plugin - look for the plugin name in the logs.

    With some extra information, it should be possible to find the problem.

    Alternatively, you can try to deactivate all other plugins and revert to the default theme - and then try the plugin again - this is to test for conflicts.

    Thanks

    Q

  3. ulises2010
    Member
    Posted 5 months ago #

    Thanks a lot,
    I enable de error loging, but I try to export the datas, I again abtain a white page, but the contain of debug.log don't say anything:

    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-includes/nav-menu.php on line 597
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-includes/nav-menu.php on line 597
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Undefined variable: post in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Undefined variable: post in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Undefined variable: post in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Undefined variable: post in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Undefined variable: post in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Undefined variable: post in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Undefined variable: post in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Undefined variable: post in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-content/themes/ChildAggregate/functions.php on line 9
    [22-Jan-2014 23:47:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-includes/nav-menu.php on line 597
    [22-Jan-2014 23:49:04 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-includes/nav-menu.php on line 597
    [22-Jan-2014 23:49:04 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-includes/nav-menu.php on line 597
    [22-Jan-2014 23:49:05 UTC] PHP Notice:  Trying to get property of non-object in /var/www/clients/client1308/web1540/web/wp-includes/nav-menu.php on line 597

    Anyway, I can export ir I filter by role and chose a role with no many users, but when I try with 'All roles' I have the white page

  4. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    As you can use the plugin to export smaller groups of users, by filtering the results, it sounds like your server is running out of memory - this would normally give a PHP Fatal error, but it's possible that it does not record it.

    One option is that you export the users by role or date ranges and then combine them into a single document.

    I can think about adding an export limit option to the plugin - but I will not have time for a few weeks to add this - as I'm busy on other projects.

    Good luck!

    Q

  5. ulises2010
    Member
    Posted 5 months ago #

    Thanks a lot, I can talk with the my hosting to increase the php memory, but I'm not sure was this, I have this:

    This website with blog_id=1 and prefix=wp_ has:
    Php version: 5.3.10-1ubuntu3.9
    Wp version: 3.8
    Wordpress Memory limit: 256M
    Php Memory Limit: 256M
    Charset: UTF-8

    You think I have to increse the php Memory... I don't have problem to change something in the host, but I really don't know what value I have to modify.... can you help me?

    The option of diferents exports don't be able to me, because I import all the users in the same day (no works the data range) and almost all have the same role... in even case I have the white page.

    Otherwise, if you can work in a update of the pluging, I think is usefull my other request, export only updated profiles

    http://wordpress.org/support/topic/export-only-updated-profile

    Thanks again and I hope you can help me.

  6. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    The 256M of memory should be enough - I've never had need to try to export such a large number of users.

    Another idea might be to try and increase the allowed PHP execution time - you can do this simply by adding an extra line to the wp-config.php:

    set_time_limit(300);

    Important – If you are making changes in wp-config.php, then add this line above “/* That’s all, stop editing! Happy blogging. */” comment.

    Try that and see if it helps..

    Q

  7. ulises2010
    Member
    Posted 5 months ago #

    Thanks a lot, I really apreciate your help... but don't work.

    I add the line (and the coment ;-) to my wp-config.php, but all the same.

    I know, the time limit is increase too in the server.

    I try puting 3000 instead of 300... but nothing, in fact, don't increase the time between I clik in export, and the white page is showed... It's really desesperated, do you have another idea?

    Thans again

  8. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    At this moment, I don't have any suggestion other than to try another plugin or to export the data directly from your mySQL database - for example via phpmyadmin...

    Good luck!

  9. ulises2010
    Member
    Posted 5 months ago #

    Thanks a lot... I try other plugins but I have the same result... a white page :-(

    I deactivate many plugins (not all, many are 'esentials') but again the white page.... :-(

    I try to export directly the wp_user data from myphpadmin but don't have all the datas, I have many metadatas... :-(

    I don't know what can I do....

  10. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    What you need to do is to find the source of the problem - you could either disable all plugins and then test or install other "debugging" plugins to try and find the problem.

    Query Monitor is a great plugin for this - but it's a bit complex also.

    Good luck!

  11. mpeterson
    Member
    Posted 5 months ago #

    Same problem trying to export 1700 users here, fwiw.

  12. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    @mpeterson - thanks for the note - I'm going to need to find a way to test the plugin on such a huge user base to see if I can replicate the problem.

    for now, please try to reduce the number being exported via filters - you can always combine the files afterwards.

    Q

  13. ulises2010
    Member
    Posted 5 months ago #

    Thanks... you have idea of how reduce the number being exported?... In my case I upload all the users the same day, and all have the same role?... It's possible other filter?

  14. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    I've review the plugin, made a few minor fixes and run an export on about 1000 users - which is the biggest set I have access to at the moment - all ran fine.

    Please try version 0.8 - ideally with no other plugins active, default 2014 theme and error logging on - to record problems.

    If I have time next week, I'll review options for chunking or breaking the export into groups of 1000 or so - but until I look into this, I can't be sure this is a good option or not.

    Q

  15. ulises2010
    Member
    Posted 5 months ago #

    Thanks a lot qstudio... really I apreciate your work.

    Sadly the problem persist for my with the version 0.8, but I can't try without the other plugins and the default theme, because the site is online.

    I think is a good idea to be possible to breaking the export into small groups (plese, with the option be smaller than 1000, I'm afraid of I have the same problem with 1000 users)

    Thanks again

  16. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    @ulises2010 - If I find a good and simple way to allow exports to be broken up, I'll add that to the next release - keep the plugin installed and you should get a notice when the update is available.

    As a side note - without you finding a way to isolate and locate the problem - which you could do by running a version of your site with just this one plugin, the default theme and error logging enabled - it's very hard to replicate, locate and fix problems.

    Q

  17. ulises2010
    Member
    Posted 5 months ago #

    Thanks a lot qstudio.

    I install other wordpress in another server.

    I upload many users using the 'Import from CSV' pluging

    I have 9,000 users, but when I try to upload crash and only upload a few.

    First I upload 519 and your pluging export it Ok

    Then I upload more until have 1203 and your pluging export it Ok

    Finally I upload more until have 2084 and.... I have the (in)famous white page.

    I hope this help you to locate the problem.

    Thanks

  18. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    Thanks - did you also try to activate Error Logging in your wp-config.php - an actual error message from the server would really help solve this problem?

    Q

  19. ulises2010
    Member
    Posted 5 months ago #

    Ok... This is the error:

    [25-Jan-2014 19:35:12 UTC] PHP Fatal error: Allowed memory size of 109051904 bytes exhausted (tried to allocate 35 bytes) in /mnt/webc/d0/87/53839987/htdocs/wordpress/es/wp-includes/meta.php on line 578

  20. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    Excellent and really, as expected.

    As you can see, as you increase the number of users you try to export, you also increase the amount of resources used - eventually you hit the limit and PHP stops executing..

    However, your PHP limit is very low - 104mb.

    I suggest you ask your host to increase your PHP limit to 256mb - you can also validate your PHP settings by running phpinfo()

    Q

  21. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    The error also shows us where the overload happens:

    meta.php: 578
    $cache[$mpid][$mkey][] = $mval;

    which is part of the update_meta_cache() function - so, the calls to get_user_meta() are being cached to save resources on future loads, but in this case, they are also overloading PHP.

    One option would be to try using direct $wpdb calls - but this is generally not recommended and it's not future safe..

  22. ulises2010
    Member
    Posted 5 months ago #

    All you say sounds for me like chinese ;-)

    If I have to do something more say me and I try to do it (I now go out, but in four hours more or less I return).

    Thanks, and I hope you can solve it.

  23. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    ok - I pushed a new update, with a simple limit range option.. it's basic, but please try it and see if it helps.

    Q

  24. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    0.8.1 broke all buddypress exports :( ... but the latest release has both a range limit option and perhaps a solution to memory over-usage..

    Please try to export your whole list first - if that fails, try to limit the number and see how that helps.

    Q

  25. ulises2010
    Member
    Posted 5 months ago #

    Excusme for my delay, but the night go longer than I expect ;-)

    I try your new version and look perfect....thanks, thanks, and thanks....

    In my test site, with 2,084 users I can export all.

    In my oficial site, whit 8,585 still I have the white page, but with the new feature of limit range I can broke it in part...

    The only thing I don't know wich is the 'offset start number'.

    Thanks.

  26. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    offset is the number to start the export from

    for example:

    1st export -- 0( offset ) -- 1000 ( total number )

    2nd export -- 1000 ( offset ) - 1000 ( total number )

    3rd export -- 2000 ( offset ) - 1000 ( total number )

    Q

  27. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    If you're happy - please rate the plugin and mark this request as closed.

    Q

  28. ulises2010
    Member
    Posted 5 months ago #

    Thanks... I rate it, Is the less I can do for your effort.

    Anyway, I try your export directions, but whit

    1st export -- 0( offset ) -- 1000 ( total number )

    do it perfect, but with

    2nd export -- 1000 ( offset ) - 1000 ( total number )

    say me 'No users found.' and as I say you I have more than 8,000 users

    Otherwise, I select a lot of costum fields to export, but they don't be stored, and I have to select the next time I have to export all the metas again... It's possible to implement an option to stored it.... it's only a idea, for me is not urgent and I understand you don't have time to do all the time my ideas...

    The only thing I yes want your help is for the exportation limits now.

    Thanks again

  29. ulises2010
    Member
    Posted 5 months ago #

    Hi Qstudio,

    Only for your information.

    I finally can export all the dates, but don't works exactly as you say...

    I have to put:

    1st export -- 0( offset ) -- 1000 ( total number )

    2nd export -- 1000 ( offset ) - 2000 ( total number )

    3rd export -- 2000 ( offset ) - 3000 ( total number )

    etc....

    If I put:

    2nd export -- 1000 ( offset ) - 1001 ( total number )

    It only export 1 user.

    Thanks

  30. qstudio
    Member
    Plugin Author

    Posted 5 months ago #

    Hi - yeh, I wrote the answer 3 times - each time differently, quickly before I went out.

    The final answer - 0 - 1000, 1000 - 2000, 2000 - 3000 is correct, as you've seen!

    Good news, I'll close this topic.

    Q

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.