Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Registering clients for events

Registering clients for events 8 years 6 months ago #26110

  • jimb
  • jimb's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
I cannot register clients for events on backend - when I click Individual registration or Group Registration Button found in Registration Records section I am getting the following 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 =
Please help

Please Log in or Create an account to join the conversation.

Registering clients for events 8 years 6 months ago #26111

  • nathan.dth
  • nathan.dth's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 1857
  • Karma: 19
  • Thank you received: 218
If you select an event first in the dropdown (which has always been required), it works just fine. There's supposed to be an alert that tells you that, but in the current build, the alert is broken... not the actual functionality though. The next update will have this corrected. You can still use it though.

Please Log in or Create an account to join the conversation.

Nathan is no longer affiliated with DTH since the recent acquisition. You can connect with him and get any type of Joomla website help at www.JoomlaEmployee.com .
  • Page:
  • 1
Time to create page: 0.430 seconds