Select User not working in Registrant manager

So if I try and click on the Select User link I can filter for a user but when I hit their name nothing happens.
Not seeing any javascript errors either.

Hi

It causes by some changes in Joomla 3.5.0. Please get latest version of Events Booking, upgrade it to your site. After that, it should work as expected

Regards.

Tuan

Hi,

I get this error in chrome dev toos.

index.php?option=com_users&view=users&layout=modal&tmpl=component&field=user_id:314 Uncaught TypeError: window.parent.jSelectUser is not a function(…)
onclick @ index.php?option=com_users&view=users&layout=modal&tmpl=component&field=user_id:314

Running Event Booking version 1.7.4 and Joomla 3.6.4 with ISIS admin template version 1.0.

Is there any documented way to manually patch this to fix this issue? I would like to try to patch it if possible. Thanks!

- Chris

Hi Chris

Sorry, we don't have documentation to patch this issue. It requires changes to both administrator/com_eventbooking/view/registrant/tmpl/defaut.php file and a method in components/com_eventbooking/helper/helper.php file (method getUserInput)

If you use Joomla 3.6.4, you really should update to latest version of the extension instead of using old version 1.7.4

Regards,

Tuan

Attached is the two files from latest version in case you want to look at it, compare it and patch it yourself

Tuan

Hi Tuan,

Thank you for trying to help and sending me the files that need to be updated. I was able to patch the files to eliminate the intial javascript error I had regarding the jselectuser function. Now upon selecting the user to be added it gets populated properly into the fields and the modal closes. However when I go to save the record a SQL error happens:

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 1' at line 1 SQL=SELECT price FROM #__eb_event_group_prices WHERE event_id=705 AND registrant_number <= ORDER BY registrant_number DESC LIMIT 1

And the users fields disappear and thus they are not saved and added to the event. Do you know what I could be missing in the patching you provided? Thanks for all your help.

- Chris

Hi Chris

Look at the error message above, it seems you forgot to enter data for Number Registrants field and it causes the error

Try to enter 1 for example, save it and it should work well

Also, you are using very old version which was purchased from 2014, so you should update to latest version to use latest features and continue receiving support from us

Regards,

Tuan

Tuan,

Yes that was the problem. The Number of Registrants field needed to be set, didn't realize it.
We will be considering the upgrade. Thanks for helping me try to temporary fix the issue in the meantime. I appreciate your help very much. Thanks!

OK Chris