TOPIC: Frontend Manual Registration Error

Front end Control Panel / hit Records. If you select add group or add individual we get a 1064 error? 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 34 SQL=select g.id as group_id , g.member as group_member , g.type as group_type , g.amount as group_amount , epc.prerequisite_id as prerequisitecategory_prerequisite_id, ep.prerequisite_id as prerequisite_prerequisite_id , f.id as file_id , f.path as file_path , f.event_id as file_event_id, fo.id as feeorder_id , fo.eventId as feeorder_eventId , fo.type as feeorder_type ,fo.reference_id as feeorder_reference_id , fo.title as feeorder_title , fo.ordering as feeorder_ordering , l.id as location_id , l.name as location_name , l.address as location_address , l.address2 as location_address2 , l.city as location_city , l.state as location_state , l.zip as location_zip , l.country as location_country , l.phone as location_phone , l.email as location_email , l.website as location_website , l.image as location_image , l.showimage as location_showimage from #__dtregister_group_event e left join #__dtregister_event_detail g on e.slabId = g.slabId left join #__dtregister_prerequisite_category epc on epc.event_id = e.slabId left join #__dtregister_prerequisite ep on ep.event_id = e.slabId left join #__dtregister_files f on f.event_id = e.slabId left join #__dtregister_feeorder fo on fo.eventId = e.slabId left join #__dtregister_locations l on l.id = e.location_id where e.slabId =

We are aware of this error and working on it for the next update. Manual registration by admin works in the admin side still.

Is this part of the same fix? See attached. After registration got this error message

kt8965 - that has absolutely nothing to do with the topic of this thread. This thread is about MANUAL registration by an event admin creating registration records... plus the error noted is not at all connected to email as yours is.

You have a setup issue within DT Register configuration and/or Joomla configuration. If you can't sort it out, submit a ticket and we can help... or at least a new forum thread for a fresh topic.

We got the same error after upgrading to DT Register 3.1.13. I did submit a ticket, but have not received a response. Any insight would be greatly appreciated.