TOPIC: [SOLVED] CSV Export Errors within backend

Running Jevent 1.4.3 RC2 and DT Register 2.4.1 in Joomla 1.5 in Legacy mode. When looking at the Registration Records I am unable to see any data collected for my custom fields (it would be nice if I could, new feature?) so I went to CSV Exports. Immediately I see the following errors (I added astersiks...):

Warning: array_chunk() expects parameter 1 to be array, null given in /home/content/*/*/*/*******/html/administrator/components/com_dtregister/admin.dtregister.html.php on line 4123

Warning: Invalid argument supplied for foreach() in /home/content/*/*/*/*******/html/administrator/components/com_dtregister/admin.dtregister.html.php on line 4142

However, I can still select \"Next\" and move on to select the data I would like. I then find additional errors:

Warning: array_diff(): Argument #1 is not an array in /home/content/*/*/*/*******/html/administrator/components/com_dtregister/admin.dtregister.php on line 462

Warning: implode(): Bad arguments. in /home/content/*/*/*/*******/html/administrator/components/com_dtregister/admin.dtregister.php on line 464

Warning: implode(): Bad arguments. in /home/content/*/*/*/*******/html/administrator/components/com_dtregister/admin.dtregister.php on line 470

And finally, when I select \"Export Data\" I find these errors:

Warning: sort() expects parameter 1 to be array, null given in /home/content/*/*/*/*******/html/administrator/components/com_dtregister/admin.dtregister.php on line 8122

Warning: end(): Passed variable is not an array or object in /home/content/*/*/*/*******/html/administrator/components/com_dtregister/admin.dtregister.php on line 8124

I have an event coming up soon and would really like to use this feature. It\'s extrememly helpful! Please let me know what I can do to address these code issues.

Thanks!

Hello. First of all, you CAN see custom field data in the backend records. Click on the record as if you were going to edit it. You\'ll see the full data there.

Second, these export errors do no happen on any of our sites. Please submit a support ticket with access to your site and we\'ll check it out.

Same error here
Warning: array_chunk() expects parameter 1 to be array, null given in /home/virtual/site6/fst/var/www/html/101/administrator/components/com_dtregister/admin.dtregister.html.php on line 4123

Here you can export your registration records data. First, please select the event(s) that you want to export data from. Click the CHECK ALL box to select all events. After selecting events, click the NEXT button in the top right corner of the screen.

dthadmin wrote: Hello. First of all, you CAN see custom field data in the backend records. Click on the record as if you were going to edit it. You\'ll see the full data there.

I\'ve done that. And...well... I guess I just disagree with you. I am unable to see the additional data. But it may just be a setting I\'ve missed.

dthadmin wrote: Second, these export errors do no happen on any of our sites. Please submit a support ticket with access to your site and we\'ll check it out.

Support ticket 1561 submitted.

Thanks for the quick reply!

For those playing along at home or having this same error, we fixed this for magilson. It was due to very outdated server setup... old php and mysql versions. We modified this file to get it to work:

/administrator/components/com_dtregister/admin.dtregister.php

Line 4552:

$database->setQuery( \"SELECT * , date(b.publish_up) eventdate from #__dtregister_group_event a

Change to:

$database->setQuery( \"SELECT * , b.publish_up eventdate from #__dtregister_group_event a


Line 7736:

$sql= \"select a.register_date, e.title , DATE(e.publish_up) publish_up, a.userId\" ;

Change to:

$sql= \"select a.register_date, e.title , e.publish_up , a.userId\" ;

I\'m getting the same / similar error while attempting to export .csv

Warning: sort() expects parameter 1 to be array, null given in /home/mattoon/public_html/administrator/components/com_dtregister/admin.dtregister.php on line 8122

Warning: end() [function.end]: Passed variable is not an array or object in /home/mattoon/public_html/administrator/components/com_dtregister/admin.dtregister.php on line 8124

I opened up a support ticket, any Ideas?