-
definedbyeye
-
Topic Author
-
Offline
-
Fresh Boarder
-
-
Posts: 4
-
Thank you received: 0
-
-
|
I have DT Register installed on a linux server and a windows server. The linux server will return rows in my export CSV. The windows server will not. Yes, everything is selected for download.
DT Donate exports fine (on both servers).
Could I have created a custom field that is interfering with the query? Right now, the query looks like this: select if(a.user_id != 0 , a.user_id ,'' ) user_id, a.register_date, e.summary , e.summary title , e.dtstart publish_up, a.userId ,
if(a.userType='I','Individual','Group') as userType ,a.userFirstname,a.userLastname,a.userOrganization,a.userAddress,a.userCity,a.userState,a.userZip,a.userCountry,a.userEmail,a.userPhone,a.userTitle,a.userSuffix ,a.Individual_Golf_Players_Entry_Fee,a.hilton_head_individual_golf_tickets,a.golf_foursome,a.tournament_sponsorship,a.tournament_sponsor,a.pledge_of_future_glory_sponsorship,a.hilton_head_pfg_sonsorship,a.pledge_of_future_glory_sponsor,a.tee_sponsorship,a.hilton_head_tee_sponsorship,a.tee_sponsor,a.beverage_cart_sponsorship,a.attending_dinner,a.hilton_head_dinner_tickets,a.dinner_guests,a.hilton_head_dinner_table,a.dinner_guest_names,a.hilton_head_dinner_sponsorship,a.how_did_you_hear_about_us,a.comments,b.groupName,b.groupId,c.groupMemberId,c.groupUserId,c.title,c.firstname,c.lastname,c.suffix,c.organization,c.address,c.city,c.state,c.country,c.zip,c.email,c.phone,c.Individual_Golf_Players_Entry_Fee as m_Individual_Golf_Players_Entry_Fee,c.hilton_head_individual_golf_tickets as m_hilton_head_individual_golf_tickets,c.golf_foursome as m_golf_foursome,c.tournament_sponsorship as m_tournament_sponsorship,c.tournament_sponsor as m_tournament_sponsor,c.pledge_of_future_glory_sponsorship as m_pledge_of_future_glory_sponsorship,c.hilton_head_pfg_sonsorship as m_hilton_head_pfg_sonsorship,c.pledge_of_future_glory_sponsor as m_pledge_of_future_glory_sponsor,c.tee_sponsorship as m_tee_sponsorship,c.hilton_head_tee_sponsorship as m_hilton_head_tee_sponsorship,c.tee_sponsor as m_tee_sponsor,c.beverage_cart_sponsorship as m_beverage_cart_sponsorship,c.attending_dinner as m_attending_dinner,c.hilton_head_dinner_tickets as m_hilton_head_dinner_tickets,c.dinner_guests as m_dinner_guests,c.hilton_head_dinner_table as m_hilton_head_dinner_table,c.dinner_guest_names as m_dinner_guest_names,c.hilton_head_dinner_sponsorship as m_hilton_head_dinner_sponsorship,c.how_did_you_hear_about_us as m_how_did_you_hear_about_us,c.comments as m_comments, d.numberOfPerson ,d.amount ,payment_type ,
if(pay_later_paid=1 ,'Paid', if(payment_type!='Free' && payment_type!='','Not Paid',' ')) as paid ,a.confirmNum ,
dis.code 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,4,2,3,5,6,7) and a.payment_verified=1 order by a.register_date desc
** I modified the code to add the registrant title and suffix fields. My code works on Linux
|