TOPIC: [SOLVED] Error in CSV Export

Running DT Register 2.5.3 in Joomla 1.5.11 I get an error when exporting to a CVS file. This is what is returned on screen:

select a.register_date, e.summary , e.summary title , e.dtstart publish_up, a.userId , if(a.userType='I','Individual','Group') as userType ,a.user ,b.groupId,c.groupMemberId,c.groupUserId,c.firstname,c.lastname,c.organization,c.email

from #__dtregister_user a

inner join #__dtregister_group b on a.userId= b.useid

left join #__dtregister_group_member c on b.groupId=c.groupUserId

inner join #__dtregister_group_amount d on d.groupId=b.groupId

inner join #__jevents_vevdetail As e on a.eventId=e.evdet_id

left join #__dtregister_codes dis on dis.id = a.discount_code_id

where a.eventId in (1) and a.payment_verified=1

order by a.register_date desc


--
Pål Monstad

Please submit a support ticket so that we can look at this. Thanks! Matt

As stated in your ticket...

I just checked on your site and it is working fine. You had no data fields selected to export. You have to select something, like First Name and Last Name for example... the export needs SOMETHING to put in the export file

I had this same error.
In the third column, if you select EMAIL or PHONE it would give you this error.

I checked the database and those fields were not in the dtregisters_group_member file. I added the two fields and "select all" and/or selecting those two fields now work.

R.

DTRegister 2.5.2b