TOPIC: Error message if I create new individual registration

Error message if I create new individual registration
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 36 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 skuec_dtregister_group_event e left join skuec_dtregister_event_detail g on e.slabId = g.slabId left join skuec_dtregister_prerequisite_category epc on epc.event_id = e.slabId left join skuec_dtregister_prerequisite ep on ep.event_id = e.slabId left join skuec_dtregister_files f on f.event_id = e.slabId left join skuec_dtregister_feeorder fo on fo.eventId = e.slabId left join skuec_dtregister_locations l on l.id = e.location_id where e.slabId =

Thnaks

Joomla version?
DT Register version?
New install or upgrade? Upgrade from what version?

You're only going to have an error like this if something hasn't been done or setup correctly / completely. You've given zero information though.

Also, you said error when creating a new registration. Do you mean a frontend registration like a user would do? Or a manually created registration record by an admin.

99% chance the issue here is that you haven't saved permissions. So go to DT Reg -> Permissions. Click "Sync Groups", then set permissions as needed, and Save.

I try to explain in english...
I made update of joomla to 3.3.0 and after the update I see that DtRegister have a update too, and I made it to 3.0.9a.

I can create a new customer from the frontend, but if I try to add a new customer from the backend, after setting the permissions and save it, close and reopen, I receive the error message

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 1 SQL=select * from skuec_users where id =

Thanks

I am also getting the same error message when i a public user registers on the front end for an event. I am running joomla 3.2.3 with DT register 3.0.9a

Yvjo - we are unable to replicate any such issue... and no one else has reported it either. Please submit a ticket with admin access to your site and exact steps to replicate the error.

southpaw3229 - If you are using the latest DT Reg 3.0.9, then you MUST use the latest build of Joomla... or you will have issues. You should be running Joomla 3.3.0 (or 3.2.4 if your PHP is too old for 3.3).