timing out when exporting?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Damian

    (@timersys)

    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

    Thread Starter allmyhoney

    (@allmyhoney)

    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

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘timing out when exporting?’ is closed to new replies.