WordPress.org

Forums

Export Featured Images
timing out when exporting? (3 posts)

  1. allmyhoney
    Member
    Posted 1 year ago #

    Hi there, I have a site with 2051 posts and featured images on each. I tried to export but it times out after about 5mins - just spins and spins and gives me no xml file? I have a VPS server with 12GB of RAM. I know this is resource intensive job so just wondering is it the server or the plugin at this stage?

    https://wordpress.org/plugins/export-featured-images/

  2. Damian
    Member
    Plugin Author

    Posted 1 year ago #

    Hi it's most probably the plugin. I need to add some export by date or category function, but i just don't have time right now.

    You could try something like changing in wpefi-admin.php line 350
    $posts = $wpdb->get_results( "SELECT * FROM {$wpdb->posts} $where" );

    To

    $posts = $wpdb->get_results( "SELECT * FROM {$wpdb->posts} $where LIMIT 0, 250" );

    this will get first 250 results

    Then change it to
    $posts = $wpdb->get_results( "SELECT * FROM {$wpdb->posts} $where LIMIT 250, 250" );

    To get next 250

    $posts = $wpdb->get_results( "SELECT * FROM {$wpdb->posts} $where LIMIT 500, 250" );

    etc

    etc

    And see if that works

  3. allmyhoney
    Member
    Posted 1 year ago #

    HI Damian, ok no worries. Yes the export by date and/or category would be a fantastic addon here but I hear you when you say you are struggling for time here. What you suggested seems to work here so cheers for this. Appreciate the efforts on this plugin. Thanks

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Export Featured Images
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.