Welcome, Guest
Username: Password: Remember me

TOPIC: CSV Export Errors - 2.7.2b

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

  • andybon
  • andybon's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 239
  • Thank you received: 0
Updated this thread with post below - Critical errors remain with 2.7.2b

Ouch - First those registrations being recorded with 'no event' - Now my CSV no longer exports.... I get this kind of error shown below... I haven't done any database tinkering - Simply gone into back-end 'Records' and where I had entries with no events showing I changed them to the event (after e-mailing the registrants to ask what event they'd registered for :evil: )

I am getting more and more worried about all this :(
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] => 169 [1] => 192 [2] => 170 [3] => 184 [4] => 171 [5] => 172 [6] => 185 [7] => 189 [8] => 190 [9] => 168 [10] => 174 [11] => 173 [12] => 179 [13] => 178 [14] => 175 [15] => 180 [16] => 177 ) Array ( [0] => 169 [1] => 192 [2] => 170 [3] => 184 [4] => 171 [5] => 172 [6] => 185 [7] => 189 [8] => 190 [9] => 168 [10] => 174 [11] => 173 [12] => 179 [13] => 178 [14] => 175 [15] => 180 [16] => 177 ) ["169","192","170","184","171","172","185","189","190","168","174","173","179","178","175","180","177"]["type","amount","payment_type","paid","memtot","confirmNum","code","category","location","user_id","attend","status","transaction_id"]["169","192","170","184","171","172","185","189","190","168","174","173","179","178","175","180","177"]
Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/active/public_html/administrator/components/com_dtregister/models/export.php on line 359

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

Last Edit: by andybon.

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

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
We have updated the package to 2.7.2b. Please download and reinstall. You should find this issue to be resolved. It was actually due to another issue in progress. CSV export has a few improvements in the new package. Thanks.

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

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

  • andybon
  • andybon's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 239
  • Thank you received: 0
Hi there - I know you marked this as Solved but I'm afraid it isn't...

Upgraded to 2.7.2b and still getting fatal errors.... I have 2 huge events coming up this weekend and next - The organisers are freaking out because I can't get the data to them - and these are the people I reassured all was ok too after since 2.6.9 they haven't been able to get confirmation mails with all the user entered data on!!!!!!

I think this issue is connected with my HUGE problem of empty registrations showing up (email and name captured but no event showing in back-end)... I've been embarassingly contacting people - asking them what they registered for and then manually editing the 'empty' record in the back-end to fix it....
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] => 169 [1] => 10 [2] => 182 [3] => 183 [4] => 192 [5] => 170 [6] => 184 [7] => 171 [8] => 202 [9] => 185 [10] => 4 [11] => 189 [12] => 190 [13] => 191 [14] => 120 [15] => 168 [16] => 152 [17] => 151 [18] => 153 [19] => 154 [20] => 155 [21] => 174 [22] => 173 [23] => 179 [24] => 178 [25] => 175 [26] => 180 [27] => 177 [28] => 200 [29] => 201 [30] => 204 [31] => 199 [32] => 198 [33] => 197 [34] => 196 [35] => 195 [36] => 194 [37] => 193 [38] => 205 [39] => 206 [40] => 207 ) Array ( [0] => 169 [1] => 10 [2] => 182 [3] => 183 [4] => 192 [5] => 170 [6] => 184 [7] => 171 [8] => 202 [9] => 185 [10] => 4 [11] => 189 [12] => 190 [13] => 191 [14] => 120 [15] => 168 [16] => 152 [17] => 151 [18] => 153 [19] => 154 [20] => 155 [21] => 174 [22] => 173 [23] => 179 [24] => 178 [25] => 175 [26] => 180 [27] => 177 [28] => 200 [29] => 201 [30] => 204 [31] => 199 [32] => 198 [33] => 197 [34] => 196 [35] => 195 [36] => 194 [37] => 193 [38] => 205 [39] => 206 [40] => 207 ) ["type","amount","payment_type","paid","memtot","confirmNum","code","category","location","user_id","attend","status","transaction_id"]["169","10","182","183","192","170","184","171","202","185","4","189","190","191","120","168","152","151","153","154","155","174","173","179","178","175","180","177","200","201","204","199","198","197","196","195","194","193","205","206","207"]["169","10","182","183","192","170","184","171","202","185","4","189","190","191","120","168","152","151","153","154","155","174","173","179","178","175","180","177","200","201","204","199","198","197","196","195","194","193","205","206","207"]
Fatal error: Maximum execution time of 30 seconds exceeded in /home/active/public_html/libraries/joomla/database/table.php on line 847

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

Last Edit: by andybon.

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

  • spheatherm
  • spheatherm's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 1
  • Thank you received: 0
I have installed the latest version and I am having this same issue. I need to pull numbers for an event ASAP as well! Please help.

(Added later...)
I am actually running 2.7.2c and I figured out that it is hanging up on the Address 2 field. Once that is removed the CSV export works fine.

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

Last Edit: by spheatherm.

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

  • andybon
  • andybon's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 239
  • Thank you received: 0
I'm guilty of not getting back to DTH Admin yet on a support ticket - They wanted FTP access to look into this and I haven't found those FTP details yet! :!:

I've got around the problem by pulling just single events at a time, over a short date range and then piecing the bits together - not great but it worked in an emergency situation!

I do suspect the error is because of the empty registrations issue (now fixed by DTH :D ) - You might want to check 'Records' in the backend and just ensure you haven't got any missing the Event title like I had (historic problem but could be what's causing your CSV export problem - maybe - I'm no expert!!!!!)

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

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

  • ismadman
  • ismadman's Avatar
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 97
  • Thank you received: 0
Getting the same prob on 2.7.2d as we have an event running this weekend and our records are almost at 400 now .
When I export I get this
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/administrator/components/com_dtregister/lib/dttable.php on line 50

HELP!!

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

Time to create page: 0.138 seconds