|
Darragh
|
October 5, 2015 at 4:04 am
Good morning,
I am having a problem with the CSV Export functionality. When I click the “All Registrations CSV Report” buttonafter around 30 seconds I am redirected back to the front end of the site where it tells me that the page cannot be found.
This was previously working perfectly however it seems to have broken as soon as I went over a set amount of registrations.
I have tried a few things such as increasing the max_execution_time to 999 and also increasing the php_memory_limit but to no avail.
WordPress Version:
4.3.1
PHP Version:
5.5.21
MySQL Version:
5.6.23
Event Espresso Version:
4.8.13.p
WordPress Address (URL):
https://www.gamestopexpo.com
Site address (URL):
https://www.gamestopexpo.com
Active Plugins:
Gravity Forms 1.9.13
Admin Custom Login 1.8
Admin Menu Editor 1.4.5
Akismet 3.1.4
Display Posts Shortcode 2.5.1
Event Espresso – Barcode Scanner (EE 4.6.0+) 1.0.5.p
Event Espresso – Social Sharing (EE4.4.4+) 1.0.p
Event Espresso – Promotions (EE 4.8+) 1.0.2.p
Event Espresso – Stripe Gateway (EE 4.6.0+) 1.0.10.p
Event Espresso – Ticketing (EE4+) 1.0.3.p
Event Espresso – WP Users (EE4.6+) 2.0.6.p
Event Espresso 4.8.13.p
Gravity Forms Multi Currency 1.7.1
Gravity Forms Quantity Limits 0.8
Gravity Forms Signature Add-On 2.3.2
Gravity Forms User Registration Add-On 2.4
Import users from CSV with meta 1.6.4
Jetpack by WordPress.com 3.7.2
Members 1.0.2
User Meta Manager Pro 2.1.2
User Switching 1.0.8
Yoast SEO 2.3.5
|
|
Tony
|
October 5, 2015 at 5:17 am
Hi there,
Some hosts do not allow you to set the max_execution_time and event prevent changing the memory limit so you may still be hitting either of those limits, or a query limit.
Currently for large amounts of registrations you’ll need to break down the export into smaller ‘sections’ of data that the server can handle without timing out. You can do this using this function:
https://gist.github.com/Pebblo/976ed35816bd3b9a6d03
This line:
$current_query['limit'] = array(0,400);
Starts at the first row 0, an set the limit at 400. You then run the export and will have 400 registrations. Then you need to changes the vales within the function for the next batch:
$current_query['limit'] = array(400,800);
And again run the export for the next batch.
That make sense?
You can use that function within your theme functions.php file or a Site Specific Plugin (the gist above is already a plugin)
|
