Support

Home Forums Event Espresso Premium Incomplete Registration Report Downloads

Incomplete Registration Report Downloads

Posted: October 10, 2019 at 4:12 pm


Praxis

October 10, 2019 at 4:12 pm

Hi there,
Since upgrading to EE 4.10.1.p we are unable to download complete CSV reports of event registrations, filtered or unfiltered. Sometimes it downloads as expected and redirects back to the admin page as expected, but the full list of registrations is not in the CSV. The actual number of registrants in the event we are trying to download doesn’t seem to matter, whether it’s 17 or 215.

Other times it seems like it’s downloading but then it drops you on a 404 page (example 404 url: /wp-content/uploads/espresso/batch_temp_folder/##########/event-espresso-registrations-2019-10-10%2015-08-26.csv)

Any guesses about what might be going on? This is happening on my dev and test environs too, and i’ve tried turning off all non-EE plugins. It didn’t make a difference.

We’re on WP 5.2.3.
thanks!


Tony

  • Support Staff

October 11, 2019 at 4:25 am

Hi there,

Sometimes it downloads as expected and redirects back to the admin page as expected, but the full list of registrations is not in the CSV.

So when the CSV downloads, is there a pattern to the missing registrations?

Other times it seems like it’s downloading but then it drops you on a 404 page (example 404 url: /wp-content/uploads/espresso/batch_temp_folder/##########/event-espresso-registrations-2019-10-10%2015-08-26.csv)

If you open up Chrome dev tools (or similar) and view the console section when downloading the CSV, does it show any JS errors?

It’s possible the request is triggering a mod_sec rule on the server which is then being directed to a 404. It’s not common but we have seen it before.

Any errors in the error_log when you trigger a CSV download?


Praxis

October 11, 2019 at 7:04 pm

You get a different number of registrations in the CSV every time you download the same event, but it appears to be missing the registrations that happened in the middle time period, in groups of 50.

Here’s one example in detail: Out of 83 approved registrations, the CSV includes only 33. It includes the most recent registrant (from today) then skips 50 people and includes the first 32 people who registered.

Another event which has 218 approved registrations: The most recent 51 registrations followed by the first 17 registrations (missing 150).

I just exported the same event again, and this time only 50 rows are missing.

When it is writing the CSV file, you see this text printing:

The file will download automatically when done, and then you will be redirected.<br>
Registrations report started successfully...<br>
Wrote 50 rows to report CSV file...<br>
Wrote 50 rows to report CSV file...<br>
Wrote 50 rows to report CSV file...<br>
Wrote 50 rows to report CSV file...<br>
Wrote 17 rows to report CSV file...

But it looks like some of those 50 rows chunks aren’t getting written.

The only error that appears in the chrome dev console which seems relevant (whether or not a CSV file is written) is this:

batch_file_runner_init.js?ver=4.10.1.p:65 Resource interpreted as Document but transferred with MIME type text/csv: "../wp-content/uploads/espresso/batch_temp_folder/../event-espresso-registrations-2019-10-11%2017-32-33.csv".

No PHP errors are appearing.


Tony

  • Support Staff

October 14, 2019 at 4:46 am

Yeah, so it sounds like some of the batch requests are being dropped.

Do you have any customizations hooking into the CSV process? If so, try disabling those and see if you have the same issue.

Something else you can test is to set this in your wp-config.php file:

define('EE_USE_OLD_CSV_REPORT_CLASS', true);

Run another export and confirm if all registrations are included.

The only error that appears in the chrome dev console which seems relevant (whether or not a CSV file is written) is this:

Meaning there are other errors or that is the only error thrown?

If there are JS error being thrown during the batch process it can prevent it from working, although I’m guessing not based batch text you added above.

The above isn’t a problem, thats from the download itself rather than the batch processes (which appear to be the problem here).


Praxis

October 15, 2019 at 6:35 pm

Thanks for the suggestions, Tony. They seemed to help fix the bug on my Dev environment, but my Test and Live environments are still buggy. I have copied up the database and files, and copied down the code, so you would think they are all the same.

We have been experiencing another bug which might be related(?) —
When a user logs in or creates an account during the checkout process, the Step 2 or “Attendee Information” fields do not load
eg: https://imgur.com/a/1KYwaOp

If you reload the page, the “return to Event Cart” button appears, and nothing else. However, if I go into the dashboard from another window and flush the site cache, then refresh the checkout page, all of the Attendee Information fields load.

This bug also happens on Test and Live but not on Dev, FWIW.


Praxis

October 15, 2019 at 6:42 pm

BTW, this bug also seems to have appeared right after I updated to event espresso core update v4.10.1.p two weeks ago.


Tony

  • Support Staff

October 16, 2019 at 3:44 am

Thanks for the suggestions, Tony. They seemed to help fix the bug on my Dev environment, but my Test and Live environments are still buggy.

So using define('EE_USE_OLD_CSV_REPORT_CLASS', true); you still get missing registrations?

That constant tells Event Espresso NOT to use the batch process so if you still have missing registrations the batch write process isn’t the cause.

Note that with that constant set on a site you should NOT see anything like this: https://monosnap.com/file/WInYnS7r6Nchqab6gE7D58VPWqZyPW

The download should just start in the browser.

I have copied up the database and files, and copied down the code, so you would think they are all the same.

Do you have any customizations hooking into the CSV process?

However, if I go into the dashboard from another window and flush the site cache

Which cache? You can’t cache any of the EE critical pages so if they are cached you’ll need to exclude them, you can follow this guide:

https://eventespresso.com/wiki/setup-nocache-exclusion-rules-event-espresso/

This bug also happens on Test and Live but not on Dev, FWIW.

Are Live and Test on the same server whilst Dev is local/another server?

BTW, this bug also seems to have appeared right after I updated to event espresso core update v4.10.1.p two weeks ago.

Are you 100% sure that’s the case? Any other updates done at the same time?

I can’t see anything in the 4.10.1 changes that would link to any of these issues.

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: publish

Updated by  Tony 15 hours, 36 minutes ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!