|
Chuck Post
|
April 9, 2015 at 5:31 pm
We are receiving this error: Fatal error: Maximum execution time of 30 seconds exceeded in /home/content/95/8601795/html/tours/wp-content/plugins/event-espresso-core-reg/core/db_models/fields/EE_Model_Field_Base.php on line 97
We only need to get the last 6 months of reports.
|
|
Dean
|
April 10, 2015 at 2:22 am
Hi Chuck,
Roughly how many registrations are you trying to export in one go?
|
|
Chuck Post
|
April 10, 2015 at 8:55 am
Dean, we have 6500 total, about 500 per month, we need to get the last 6 months.
I saw another support reply were you offered a php code change that would allow us to do this in smaller queries. We are using HostGator.
|
|
Lorenzo Orlando Caum
|
April 10, 2015 at 9:41 am
Hi, try this workaround:
https://gist.github.com/lorenzocaum/8e9f047e533248153a38
—
Lorenzo
|
|
Chuck Post
|
April 10, 2015 at 11:40 am
I see this line on my server: $registrations = $reg_model->get_all(array(array(‘EVT_ID’=>$event_id),’order_by’=>array(‘Transaction.TXN_ID’=>’asc’,’REG_count’=>’asc’)));
but it has the ))); on the end
Your line is:’order_by’ => array(‘Transaction.TXN_ID’=>’asc’,’REG_count’=>’asc’),’REG_count’=>’asc’), ‘limit’ => array(0,100),
Is this the line?
|
|
Chuck Post
|
April 10, 2015 at 11:47 am
This is what I am seeing on the server:
‘order_by’=>array(‘Transaction.TXN_ID’=>’asc’,’REG_count’=>’asc’)));
Your code says:
‘order_by’ => array(‘Transaction.TXN_ID’=>’asc’,’REG_count’=>’asc’),
Is this the correct line? even though the ))): is different from ),
|
|
Lorenzo Orlando Caum
|
April 10, 2015 at 2:23 pm
Hi Chuck, is your software up to date?
You should see something like this:
http://cl.ly/image/0u2x3z2U1o0a
—
Lorenzo
|
|
Chuck Post
|
April 10, 2015 at 5:42 pm
Thanks Lorenzo,
I have updated to Version 4.6.19.p
The file : event-espresso-core-reg/core/db_classes/EE_Export.class.php did not update on the server (HostGator). I can tell because I had commented out that line for editing and it is still there. Whats up with that?
|
|
Chuck Post
|
April 10, 2015 at 9:14 pm
Thanks, worked…….the “work a round” code (GitHub”) is a bit off:
‘order_by’ => array(‘Transaction.TXN_ID’=>’asc’,’REG_count’=>’asc’),’REG_count’=>’asc’),
need to take out a ‘REG_count’=>’asc’),
|
|
Lorenzo Orlando Caum
|
April 13, 2015 at 8:08 am
Hi,
I removed the duplicate parameter. Thanks
—
Lorenzo
|
