TOPIC: [SOLVED] Error adding registrants manually in backend

I just upgraded to 3.1.8a and everything seems to be ok apart from when I try to add registrants manually through the DT register backend. When I click on the individual registration button I get a SQL error - 1064 (see attached screens.

Can you help?

Sorry, not sure why the screenshot didn't appear. Here is the 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 =

Hi, did you find out the reason for this error? I am having the same one.

Regards,
Ben

It turned out it was because I wasn't selecting an event before clicking on add registrant. There used to be a popup error message to warn you when you did this but that's not there at the moment for some reason. Anyway, hopefully this is the same for you.

Yes, you just need to select an event first, as has always been the case. The popup alert is being fixed, but the manual registration functionality still works fine after selecting the event.