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

TOPIC: SQLError 1064 upon registration

SQLError 1064 upon registration 9 years 7 months ago #24383

  • crd13tm
  • crd13tm's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Version 3.1.1. Go through the process of registering a group of 2 people. Click to finalize the registration, I get the following:

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 eval_dtregister_group_event e left join eval_dtregister_event_detail g on e.slabId = g.slabId left join eval_dtregister_prerequisite_category epc on epc.event_id = e.slabId left join eval_dtregister_prerequisite ep on ep.event_id = e.slabId left join eval_dtregister_files f on f.event_id = e.slabId left join eval_dtregister_feeorder fo on fo.eventId = e.slabId left join eval_dtregister_locations l on l.id = e.location_id where e.slabId =

3rd issue I have encountered in 2 days of testing... anyone else having this many version 3.1.1 issues? Maybe it's me... :blink:

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

SQLError 1064 upon registration 9 years 7 months ago #24456

  • crd13tm
  • crd13tm's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Anybody, any ideas?

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

SQLError 1064 upon registration 9 years 7 months ago #24467

  • quayleconv
  • quayleconv's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
Found this happened if I didn't have a Billing Member for a group. Change the Name Address Ph No and E Mail fields to Both in the event Field Settings and it works OK.
Still looking for an answer to the problem - if you copy the sql query into phpmyadmin on the DB and run it with an event ID for one of your events, the query works fine. Seems it is not getting the e.slabId number from the event setup if there is no billing member in a group

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

SQLError 1064 upon registration 9 years 7 months ago #24474

  • bdonner
  • bdonner's Avatar
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 128
  • Thank you received: 2
My companys registrations are at a standstill since over two weeks back because of this problem. I posted a support ticket May 9th which Nathan tried to have a look on May 11th but could not because I had not understood to give all needed admin access details, but now it is a week since I got all access details to DT Register and no one has had a look yet.

DT Register PLEASE:

I paid for a new (my 5th for this website, my 12th all in all!) DT Register license to get the last bugfix version (which did not help) and to get support, but no support given! Many of us are totally depending commercially on having a working registration system. DT Register has failed unacceptably many times through the years with slow or no help, causing the companies and organisations I run DT Register for much trouble. I understand hands can be full, but it is a working component for those using it we need, with bugfixes and totally reliable versions. IT IS NOT (!!) heaps of new functionalities again failing in each version of the component that we very much need. Time after time a stable version of DT Register has been promised, but every time I update to get rid of a bug, I get yet another.

Regards Ben

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

  • Page:
  • 1
Time to create page: 0.211 seconds