Need help with Joomla? We are available for hire to help with Joomla customization, upgrades, maintenance, and custom development.
Explore our services

registrant bug

More
12 years 10 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.

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

More
12 years 10 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

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

More
12 years 7 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.

More
12 years 7 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

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

More
12 years 6 months ago - 12 years 6 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!
Last edit: 12 years 6 months ago by veganvixen. Reason: I figured this out and edited group/php

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

More
12 years 6 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
The following user(s) said Thank You: Ben, veganvixen

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

More
12 years 6 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.

More
12 years 6 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

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

Moderators: Tuan Pham Ngoc