Welcome, Guest
Username: Password: Remember me

TOPIC: CSV Export Errors - 2.7.2b

CSV Export Errors - 2.7.2b 13 years 11 months ago #11624

  • jstephens
  • jstephens's Avatar
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 31
  • Thank you received: 0
I've seen the problem with the 30 second time out on my site as well. I cranked the 30 up to 60 in php.ini and that worked for me. I'm not sure why it's taking so long, but I have been able to do the workaround.

Please Log in or Create an account to join the conversation.

CSV Export Errors - 2.7.2b 13 years 11 months ago #11625

  • ismadman
  • ismadman's Avatar
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 97
  • Thank you received: 0
yeah but on a hosted server you have no access to php.ini ( server side )
I know you could make your on root level one
Looking into finding the file that is causing it and adding some code in there
ie:
set_time_limit ( 60 ) ;
$t1=time();

sleep(50); 
$t2=time();
$t_lapsed=$t2-$t1;
echo "Total time lapsed = $t_lapsed";

Please Log in or Create an account to join the conversation.

CSV Export Errors - 2.7.2b 13 years 11 months ago #11633

  • ismadman
  • ismadman's Avatar
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 97
  • Thank you received: 0
Set the dttable.php file to set_time_limit (0); at line 49
after about 3 minutes i got a 500 internal server error
so that din't fix it lol

Please Log in or Create an account to join the conversation.

CSV Export Errors - 2.7.2b 13 years 11 months ago #11634

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Trying to determine where the issue is. Larger amounts of data didn't used to be a problem. We'll track it down. For now, maybe use the date filter to export in pieces. A pain, I realize, but just until we get a solid fix in place.

Please Log in or Create an account to join the conversation.

CSV Export Errors - 2.7.2b 13 years 11 months ago #11635

  • ismadman
  • ismadman's Avatar
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 97
  • Thank you received: 0
Thanks for the quick heads up .
We can export the way andybon describes then merge
( exporting individual events works but not all at once even with all the GROUP MEMBER DETAILS unchecked )
So alls good .
Will wait for the fix :)

Please Log in or Create an account to join the conversation.

CSV Export Errors - 2.7.2b 13 years 11 months ago #11643

  • ismadman
  • ismadman's Avatar
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 97
  • Thank you received: 0
Just updated to 2.7.2e
no change ( as i know nothing was addressed )
Seems the error has changed now though
Array ( [0] => type [1] => amount [2] => payment_type [3] => paid [4] => memtot [5] => confirmNum [6] => code [7] => category [8] => location [9] => user_id [10] => attend [11] => status [12] => transaction_id ) Array ( [0] => 25 [1] => 1 [2] => 2 [3] => 16 [4] => 3 [5] => 14 [6] => 17 [7] => 4 [8] => 5 [9] => 6 [10] => 8 [11] => 11 [12] => 19 [13] => 10 [14] => 20 [15] => 9 [16] => 13 [17] => 18 [18] => 54 [19] => 22 [20] => 21 [21] => 23 [22] => 24 [23] => 15 [24] => 53 [25] => 55 [26] => 57 [27] => 56 [28] => 58 [29] => 27 [30] => 28 [31] => 59 [32] => 41 [33] => 44 [34] => 49 [35] => 50 [36] => 51 [37] => 52 [38] => 45 [39] => 46 [40] => 47 [41] => 48 [42] => 42 [43] => 43 ) Array ( [0] => 25 [1] => 1 [2] => 2 [3] => 16 [4] => 3 [5] => 14 [6] => 17 [7] => 4 [8] => 5 [9] => 6 [10] => 8 [11] => 11 [12] => 19 [13] => 10 [14] => 20 [15] => 9 [16] => 13 [17] => 18 [18] => 54 [19] => 22 [20] => 21 [21] => 23 [22] => 24 [23] => 15 [24] => 53 [25] => 55 [26] => 57 [27] => 56 [28] => 58 [29] => 27 [30] => 28 [31] => 59 [32] => 41 [33] => 44 [34] => 49 [35] => 50 [36] => 51 [37] => 52 [38] => 45 [39] => 46 [40] => 47 [41] => 48 [42] => 42 [43] => 43 ) ["type","amount","payment_type","paid","memtot","confirmNum","code","category","location","user_id","attend","status","transaction_id"]["25","1","2","16","3","14","17","4","5","6","8","11","19","10","20","9","13","18","54","22","21","23","24","15","53","55","57","56","58","27","28","59","41","44","49","50","51","52","45","46","47","48","42","43"]["25","1","2","16","3","14","17","4","5","6","8","11","19","10","20","9","13","18","54","22","21","23","24","15","53","55","57","56","58","27","28","59","41","44","49","50","51","52","45","46","47","48","42","43"]
Fatal error: Maximum execution time of 30 seconds exceeded in /home/southpor/public_html/libraries/joomla/database/table.php on line 847

Please Log in or Create an account to join the conversation.

Time to create page: 0.126 seconds