|
Jonathan Young
|
August 23, 2015 at 3:32 am
Hi,
Recently my installation of Event Espresso has started having major issues when trying to use the “All Registrations CSV Report” function within the registrations page. I’ve have tried changing the theme and disabling other plugins as this helped when a similar issue was encountered previously. However, this didn’t help at all this time. The first image below is when the Twentyfourteen theme is enabled, the second is when a custom theme is enabled.
As you can see from the first image the Debug message displays the same messages infinitely.
Any help with this would be very much appreciated!
Jonathan
|
|
Jonathan Young
|
August 23, 2015 at 3:35 am
Not sure how to edit post so please find the correct images below:
Jonathan
|
|
Jonathan Young
|
August 23, 2015 at 3:35 am
|
|
Dean
|
August 24, 2015 at 5:52 am
HI,
What exact version of EE are you using please?
|
|
Jonathan Young
|
August 24, 2015 at 6:20 am
Hi Dean,
We are currently running Event Espresso – 4.8.4.p – this was updated yesterday I believe though the problem with downloading the CSV registration report has been present since last Wednesday.
Thanks,
Jonathan
|
|
Tony
|
August 24, 2015 at 9:54 am
Hi Jonathan,
How many registrations doe this event have?
If you create a new event, place a single test registration onto that site and export the registration for that event, does it work as expected?
|
|
Jonathan Young
|
August 24, 2015 at 10:16 am
Hi Tony,
There are currently 651 registrations for the event, I’ve created a new test event and made a single registration, though I’m not sure how I would export this registration individually? As the registration appears with all the others – but is listed for the test event.
Thanks,
Jonathan
|
|
Tony
|
August 24, 2015 at 10:33 am
Go to Event Espresso -> Events.
Hover over the new event name.
Click the ‘Registrations’ link that appears for that event.
The page should now only list the registrations for that specific event.
Click to export all the registrations on that page (at the bottom of the table)
|
|
Jonathan Young
|
August 24, 2015 at 11:52 am
Hi Tony,
Yes it does appear to work no problem with the test event, can you advise on how to resolve this with the main one?
Thanks,
Jonathan
|
|
Lorenzo Orlando Caum
|
August 24, 2015 at 1:59 pm
Hi Jonathan, could you try raising the maximum execution time to a higher value?
You can add this towards the middle of your wp-config.php file and then save changes:
/** Raise PHP timeout */
set_time_limit(90);
—
Lorenzo
|
|
Josh
|
August 24, 2015 at 2:16 pm
You can also add the following to the wp-config.php file:
|
|
Jonathan Young
|
August 25, 2015 at 2:06 am
Hi Lorenzo, Josh
Both of these lines have been added to the wp-config file, upon activating the All CSV Registrations button it displays this message after roughly 1 minute:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
I have been assured by the IT staff that manage the server that this is not a fault of theirs, please advice?
Thanks
Jonathan
|
|
Tony
|
August 25, 2015 at 5:24 am
Hi Jonathan,
It looks like the server is timing out before the request can be complete, upping the execution time can help in some instances but it depends on how much data you are pulling in (and the resources available on your server)
We are working on a solution for this, however currently in order to pull in all of your registrations you’ll need to reduce the amount of rows being called from the database for the export, essentially splitting down the export into smaller sections for your server to handle.
This needs to be via a plugin such as this – http://take.ms/ttBVf
Each export will need the value within the plugin to be changed to pull the next ‘batch’.
For example after installing that plugin if you go to Dashboard -> Plugins.
You will find a plugin called ‘Site Specific Plugin for EE Export functions’
That plugin hooks in and sets a limit on the query used for the exports. However, this limit needs to be changed to allow you to export the registrations in smaller ‘chunks’ and then combine them together.
If you click the edit link under the plugin name you’ll see something like this – http://take.ms/GDiv9
The array(0,100) line is setting the limits, the first number is the row to start on, the second how many rows to pull.
So basically to pull in 1000 registrations that needs to be changed to:
array(0,200) then run the export.
array(200,200) then run the export.
array(400,200) …
array(600, 200) …
array(800,200)…
(I also did 1000,200 just to be sure)
You’ll have a new file for each time you export, each with different registrations.
Then at the end manually combine all of those files together into one file.
|
|
Jonathan Young
|
August 25, 2015 at 7:15 am
Hi Tony,
Yes this appears to work as a stopgap solution, thank you for your help in this. Can you let me know when you have a more permanent solution? As this obviously isn’t ideal for large scale registrations moving forward.
Thanks again,
Jonathan
|
|
Jonathan Young
|
August 25, 2015 at 8:20 am
Hi Tony,
Not sure if this is a side effect of the plugin but the registration CSV file no longer exports the registrants personal information (name, address, email etc). Having looked into some individual registrations within WordPress – it appears this information isn’t being displayed there either? I certainly hope this information isn’t lost…
Thanks,
Jonathan
|
|
Jonathan Young
|
August 25, 2015 at 8:26 am
Apologies, I just noticed that the users personal information is displayed in the top right within WordPress for each registration. However, these details are still not being displayed within the CSV registration downloads, can you advise?
Thanks,
Jonathan
|
|
Tony
|
August 25, 2015 at 9:07 am
I’m not sure I understand.
Which name does the CSV show for the registration?
Registrations are assigned to the users ‘contact’ which is linked with the user profile, so the details should pull through.
Unless these a group registrations in which user enter multiple attendee data?
|
|
Jonathan Young
|
August 25, 2015 at 9:49 am
Hi Tony,
Apologies for not being clear – when the All Registrations Download button is clicked and the csv file is downloaded the fields for personal information which are captured by the form (and I believe are mandatory) are not being downloaded with the other data, please see an example image below:
Thanks,
Jonathan
|
|
Tony
|
August 25, 2015 at 12:18 pm
Hmm, how were these registrations made?
Through the admin or front end?
Do you use the WP Users Add-on?
|
|
Jonathan Young
|
August 26, 2015 at 3:06 am
Hi Tony,
All registrations were made front end by our users, we did briefly use the WP Users Addon but due to an update error (it froze when updating this addon, locking out the whole website via the maintenance mode) it had to be deactivated and removed.
Thanks,
Jonathan
|
|
Tony
|
August 26, 2015 at 4:32 am
Hi Jonathan,
I have replied to your support token privately and just adding some details here for future readers.
(it froze when updating this add-on, locking out the whole website via the maintenance mode)
That sounds like an issue with the WordPress updater rather than the WP Users Add-on. If the WordPress updater was interrupted after Maintenance Mode was enabled it can sometimes leave WordPress in maintenance mode (leaving you with the awesome display of a whitescreen showing ‘Maintence mode’)
This can be de-activated by removing the .maintenance file from the root directory using FTP (or similar). The plugin that was being updated (in this was the WP User Add-on) may have also been removed, or possibly not and will need to be removed manually.
Then re-install the plugin manually.
I’ve added information specific to your site to your support token, please reply via the token for those and we will continue to investigate.
|
|
b2995
|
August 26, 2015 at 2:32 pm
That worked! Thank you!
Another question… I thought by selecting the category, it would only download those files. Is there a way to update the plugin to manipulate that as well? And are yall addressing that issue as well? Only asking since we do about 2000-4000 records each year and I don’t want to have to do a complete dump every time.
Thanks again! EE has been awesome for our events either way!
|
|
Josh
|
August 27, 2015 at 8:46 am
We’re working on adding a feature that will break up the the reports in batches while it generates the reports so it doesn’t hit the typical shared server max execution time when there are 1000’s of records.
|
