Support

Home Forums Event Espresso Premium 'All Registrations CSV Report' button showing blank page after a while

'All Registrations CSV Report' button showing blank page after a while

Posted: January 25, 2017 at 10:45 am

Viewing 8 reply threads


Melanie Kusmik

January 25, 2017 at 10:45 am

When we are trying to export all registrations it waits for 30-50 seconds and then shows a blank page here.

However Filtered CSV Report and Event Registrations CSV Report buttons work fine.

We have more than 2000 registrations and the current version of EE is 4.9.25.p

From the server error log we have this:
Timeout waiting for output from CGI script …/wp-admin/admin.php, referer: http://techventurekids.org/wp-admin/admin.php?page=espresso_registrations

We were trying to change the default_socket_timeout value (current value is 20) but the server doesn’t allow us to change that.

Is there anything else we can do to fix the issue?


Josh

  • Support Staff

January 25, 2017 at 10:55 am

Does your server allow you to add the following to your wp-config.php file?

@ini_set( 'max_execution_time', 360 );


Melanie Kusmik

January 25, 2017 at 11:21 am

We can edit wp-config.php file but the value doesn’t change for execution time.
You can check the current php info here redacted

  • This reply was modified 7 years, 8 months ago by Josh. Reason: removed link to phpinfo


Josh

  • Support Staff

January 25, 2017 at 11:34 am

When you run the All Registrations CSV report, does it break the processing up into batches, or does it try to do it all in one request? When it breaks the processing up into batches, it will happen on a page that looks like this.

If it’s using batches, you can set this in the wp-config.php file to make the batches smaller:

define( 'EE_BATCHRUNNER_BATCH_SIZE', 10 );

If it’s not using batches, can you make sure the following is not set in the wp-config.php file?

define( 'EE_USE_OLD_CSV_REPORT_CLASS', true );


Melanie Kusmik

January 25, 2017 at 11:48 am

http://techventurekids.org/wp-admin/admin.php?page=espresso_batch&return_url=…
This is the link where the blank page appears.

So, EE must uses the batch mode.

Also for other two buttons
Filtered CSV Report and Event Registrations CSV Report
it uses batch mode and works great (like the screenshot you sent).


Josh

  • Support Staff

January 25, 2017 at 11:50 am

So in that case you can set this in the wp-config.php file to make the batches smaller:
define( 'EE_BATCHRUNNER_BATCH_SIZE', 10 );


Melanie Kusmik

January 25, 2017 at 11:55 am

Just tried. Worked for Event Registrations CSV Report but not for All Registrations CSV Report


Melanie Kusmik

January 25, 2017 at 12:17 pm

If we don’t filter the registrations by Year/Month/Categories/Status then the Filtered CSV Report button generates CSV for all the registrations.

So, we are going to use it as an alternative for now.

Thank you for your support.


Josh

  • Support Staff

January 27, 2017 at 12:14 pm

Interesting. That may mean there’s one registration that has some invalid data, in which case the filtered report would ignore that one.

Viewing 8 reply threads

The support post ‘'All Registrations CSV Report' button showing blank page after a while’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso