- Posts: 11
- Thank you received: 2
registrant bug
- franz
- Topic Author
- Offline
- New Member
-
Less
More
12 years 6 months ago #33685
by franz
registrant bug was created by franz
Hi Tuan,
when you create a registrant in the backend, if you save without entering "Number Registrants" you have an error page :
"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 'ORDER BY registrant_number DESC LIMIT 1' at line 1 SQL=SELECT price FROM gdnth_eb_event_group_prices WHERE event_id=2 AND registrant_number <= ORDER BY registrant_number DESC LIMIT 1 "
instead of an error message like "Number Registrants is required"
just for you to know.
when you create a registrant in the backend, if you save without entering "Number Registrants" you have an error page :
"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 'ORDER BY registrant_number DESC LIMIT 1' at line 1 SQL=SELECT price FROM gdnth_eb_event_group_prices WHERE event_id=2 AND registrant_number <= ORDER BY registrant_number DESC LIMIT 1 "
instead of an error message like "Number Registrants is required"
just for you to know.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
12 years 6 months ago #33686
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: registrant bug
Thanks for reporting. I think Number registrants need to be a required field. I will add javascript validation to force users to enter number registrants when creating new registrant into the version I am working on at the moment.
Tuan
Tuan
Please Log in or Create an account to join the conversation.
- jrupp
- Offline
- New Member
-
Less
More
- Posts: 7
- Thank you received: 0
12 years 3 months ago #37910
by jrupp
Replied by jrupp on topic Re: registrant bug
Is this fixed in the latest version? I have version 1.6.1 and I'm getting this error when trying to edit group member names after someone has registered through the front end of the site. I downloaded the update, but I'm wondering how to install it without erasing events or registrants.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
12 years 3 months ago #37941
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: registrant bug
Hi
Simply install new version over the old version and try again. If the issue happens, please submit a support ticket sending us admin and FTP account of your site. We will check to see what's wrong and get it corrected for you !
Regards,
Tuan
Simply install new version over the old version and try again. If the issue happens, please submit a support ticket sending us admin and FTP account of your site. We will check to see what's wrong and get it corrected for you !
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- veganvixen
- Offline
- New Member
-
Less
More
- Posts: 19
- Thank you received: 0
12 years 2 months ago - 12 years 2 months ago #38261
by veganvixen
Replied by veganvixen on topic Re: registrant bug
Hi,
Can you please tell me how to set the number of registrants so that when someone is registering they have to set a number? I cannot find the setting in the backend.
Thanks!
Can you please tell me how to set the number of registrants so that when someone is registering they have to set a number? I cannot find the setting in the backend.
Thanks!
Last edit: 12 years 2 months ago by veganvixen. Reason: I figured this out and edited group/php
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
12 years 2 months ago #38335
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: registrant bug
Hi
You emailed me and asked about group registration. However, I think there is a simpler way for doing this :
1. Edit the event, set registration type to only allows Individual Registration.
2. Create a custom field allow users to enter number registrants. Named it as eb_number_registrants.
3. Install and publish the plugin which I published below
After that, I think it should work in the way you want.
Regards,
Tuan
You emailed me and asked about group registration. However, I think there is a simpler way for doing this :
1. Edit the event, set registration type to only allows Individual Registration.
2. Create a custom field allow users to enter number registrants. Named it as eb_number_registrants.
3. Install and publish the plugin which I published below
After that, I think it should work in the way you want.
Regards,
Tuan
The following user(s) said Thank You: Ben, veganvixen
Please Log in or Create an account to join the conversation.
- veganvixen
- Offline
- New Member
-
Less
More
- Posts: 19
- Thank you received: 0
12 years 2 months ago #38353
by veganvixen
Replied by veganvixen on topic Re: registrant bug
Thank you so much Tuan!!!!
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
12 years 2 months ago #38397
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: registrant bug
No problem. if you have other questions, please don't hesitate to ask !
Tuan
Tuan
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc
Support
Documentation
Information
Copyright © 2026 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.