Error on Back End when manually registering a user

When we try to manually register a user to an event on the back end, we get this error

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 'ORDER BY registrant_number DESC LIMIT 0, 1' at line 4 SQL=SELECT price FROM JOM_eb_event_group_prices WHERE event_id = 2 AND registrant_number <= ORDER BY registrant_number DESC LIMIT 0, 1

This started happening after upgrading to 2.0.4


Matt

Hi Matt

I think the reason is because when you create the registration record, you forgot to enter Number Registrants. Please try again, make sure you enter number registrants (for example, enter 1 to that input box)

After that, it should work as expected

Regards,

Tuan

Yes, That did the trick.. Can we default that Box to "1" or throw up an error like "Missing Registration Count"

Yes. Will work on it on tomorrow. When it is empty, I think we can safe set it to 1. You don't have to enter it, so it will save sometime

Tuan

Excellent!

Thanks!!!

Hi Matt

This is now implemented. You can download latest version from My Downloads section, upgrade it to your site to have this option / feature

Tuan