Posted: October 10, 2019 at 4:12 pm
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.
So when the CSV downloads, is there a pattern to the missing registrations?
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?
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.
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
Run another export and confirm if all registrations are included.
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).
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(?) —
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.
BTW, this bug also seems to have appeared right after I updated to event espresso core update v4.10.1.p two weeks ago.
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.
Do you have any customizations hooking into the CSV process?
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:
Are Live and Test on the same server whilst Dev is local/another server?
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.