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

TOPIC: Erro 1064 when clicking on Register Now button

Erro 1064 when clicking on Register Now button 9 years 8 months ago #24354

  • cheru
  • cheru's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 28
  • Thank you received: 0
Hi nant,
I have reinstalled the latest version of DT Register.

Created a sample event.
Tried to Register.

But this error still shows up.


1064 Error
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 aas_dtregister_codes where id in()


Any idea how to resolve this please??

It is urgent.

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

Erro 1064 when clicking on Register Now button 9 years 8 months ago #24355

  • cheru
  • cheru's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 28
  • Thank you received: 0
The error also appears when I tried to add an individual registration from the backend.


An error has occurred.

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 aas_dtregister_codes where id in()



Where or how can this problem be resolved.

i need it pretty urgently, as the site has already gone live.

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

Erro 1064 when clicking on Register Now button 9 years 8 months ago #24356

  • nathan.dth
  • nathan.dth's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 1857
  • Karma: 19
  • Thank you received: 218
Which version of DT Register are you using? The current build is 3.1.0b. If you have anything previous, go to My Orders and download the updated package. Be sure to also update all DT plugins and modules. If the issue remains, submit a ticket with specific details on how to replicate, which event, etc. Thanks.

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 .

Erro 1064 when clicking on Register Now button 9 years 8 months ago #24371

  • 88keyman
  • 88keyman's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
I got this error after installing 3.1.1 when trying to access DT Register in the administration backend.

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

Erro 1064 when clicking on Register Now button 9 years 7 months ago #24438

  • bdonner
  • bdonner's Avatar
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 128
  • Thank you received: 2
Error 1064 here also when someone tries to register for an event.

Not for all events, only for some.

It SEEMS like this problem only occours for me, when someone tries to register in a language which is not the site's default language. Registering to the same event in the default language has not caused errors (yet).

I have tried to change different event parameters and fields used, but does not help.

Error noticed a couple of days ago with the previous version of DT register, I now upgraded to newest 3.1.1 and error still there.

See attachment for whole error which shows when user has chosen Individual or Group registration.

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

Last Edit: by bdonner.
  • Page:
  • 1
Time to create page: 0.266 seconds