Lower level frontend users cant choose location
- Jono
- Topic Author
- Offline
- Premium Member
-
Less
More
10 years 11 months ago #61141
by Jono
Lower level frontend users cant choose location was created by Jono
Hi,
On our web site, we are experiencing that lower level users who have permissions to submit events in the frontend are unable to choose from the list of available locations for the event.
On their screens, the dropdown list of available locations is empty - whereas for higher level users, the dropdown list is populated correctly with the available locations?
We are using version 1.6.3 - but are not in a hurry to upgrade as you have helped us make some customisations.
On our web site, we are experiencing that lower level users who have permissions to submit events in the frontend are unable to choose from the list of available locations for the event.
On their screens, the dropdown list of available locations is empty - whereas for higher level users, the dropdown list is populated correctly with the available locations?
We are using version 1.6.3 - but are not in a hurry to upgrade as you have helped us make some customisations.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
10 years 11 months ago #61157
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
You can upload the file components/com_eventbooking/views/event/view.html.php on your site here. I will help modifying the code for you to make it is possible
Tuan
Tuan
Please Log in or Create an account to join the conversation.
- Jono
- Topic Author
- Offline
- Premium Member
-
10 years 11 months ago #61202
by Jono
Replied by Jono on topic Lower level frontend users cant choose location
Thanks so much Tuan,
I have attached the file
I have attached the file
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
10 years 11 months ago #61203
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
You can get the modified file here, upload it to your site and it should work well
Tuan
Tuan
Please Log in or Create an account to join the conversation.
- Jono
- Topic Author
- Offline
- Premium Member
-
10 years 11 months ago #61213
by Jono
Replied by Jono on topic Lower level frontend users cant choose location
Thanks for your help so far Tuan.
I tested it and for some reason, the same issue remains.
The site does not use cache - so it is not a cache issue.
I logged out and logged in again after uploading the file, but the issue is still the same with no 'location' being selectable when submitting an event as a lowerlevel user.
I tested it and for some reason, the same issue remains.
The site does not use cache - so it is not a cache issue.
I logged out and logged in again after uploading the file, but the issue is still the same with no 'location' being selectable when submitting an event as a lowerlevel user.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
10 years 11 months ago #61218
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
That's strange. You can submit a support ticket sending us super admin account of your site so that I can check and edit the code directly on your site for you.
Regards,
Tuan
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- CCC
- Offline
- New Member
-
Less
More
- Posts: 5
- Thank you received: 0
10 years 11 months ago #61470
by CCC
Replied by CCC on topic Lower level frontend users cant choose location
Was this solved?
I am having the same problem. My front end users did not have any locations to choose from. Even though locations were created in the back end, the drop down for the location says "Select Location". But there are none available.
But I figured out what is happening. The user can only see the locations that they created. This won't work for us as we will have more than one user adding events and would like them to share locations.
Can we get a fix?
Thanks!
I am having the same problem. My front end users did not have any locations to choose from. Even though locations were created in the back end, the drop down for the location says "Select Location". But there are none available.
But I figured out what is happening. The user can only see the locations that they created. This won't work for us as we will have more than one user adding events and would like them to share locations.
Can we get a fix?
Thanks!
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
10 years 11 months ago #61481
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
Hi
Yes. You can edit the code abit to make it work:
1. Open the file components/com_eventbooking/views/event/view.html.php
2. Find these lines of code:
3. Change it to
Then all published locations will be displayed for users to choose for their events
Tuan
Yes. You can edit the code abit to make it work:
1. Open the file components/com_eventbooking/views/event/view.html.php
2. Find these lines of code:
Code:
if ($user->authorise('core.admin', 'com_eventbooking'))
{
$sql = 'SELECT id, name FROM #__eb_locations WHERE published=1 ORDER BY name';
}
else
{
$sql = 'SELECT id, name FROM #__eb_locations WHERE published=1 AND user_id=' . $user->id . ' ORDER BY name ';
}
3. Change it to
Code:
$sql = 'SELECT id, name FROM #__eb_locations WHERE published=1 ORDER BY name';
Then all published locations will be displayed for users to choose for their events
Tuan
The following user(s) said Thank You: CCC
Please Log in or Create an account to join the conversation.
- Jono
- Topic Author
- Offline
- Premium Member
-
10 years 11 months ago #61521
by Jono
Replied by Jono on topic Lower level frontend users cant choose location
Thanks Tuan - I have now got it working. The edited file you provided me with still had "AND user_id=' . $user->id . '" in the sql query - but by following your steps below I got it resolved.
Excellent service - thanks Tuan!
Excellent service - thanks Tuan!
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
10 years 11 months ago #61562
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Lower level frontend users cant choose location
Oh, OK. Don't know why I could make that mistake
.
. 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.