Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

error on the JS Member Map + how to hide super user members on the Map.

6 years 2 months ago
  • yves's Avatar
    Topic Author
  • yves
  • Offline
  • Junior Boarder
  • Posts: 111
  • Thank you received: 5
Licenses:
JomSocial Active

Hi,
1°) error
for info I noted an error when setting the module to display the map of friends:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''user_id' WHERE a.`field_id` = '28' LIMIT 10' at line 6

it occurred on 4.5 version with a user having only 1 friend.
it doesn't make an error if I choose to display the members instead of the friends.
Presently I unpublished the module as it is breaking the page.

2°) If I choose to display the Members, then the super users accounts are displayed (even if the general settings of JS indicates not to show super users in the wall: "Show Administrators in Member's Lists" set to "no").

regards
yves

6 years 2 months ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi

I will need an FTP access to fix that. Also can You please prepare a test page with a module published when broken so I'll be able to check my progress during an attempt to fix? It should be a Special access level page so only users with Super User will be able to see.

6 years 2 months ago
  • yves's Avatar
    Topic Author
  • yves
  • Offline
  • Junior Boarder
  • Posts: 111
  • Thank you received: 5
Licenses:
JomSocial Active

Hi Piotr,
I indicated the FTP access and the test page for you in the private section of the first post.
The test page is located on the English version of the website as a sub-menu under the "Community" main menu.

6 years 2 months ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi

Thank You for the access. I was able to locate the code responsible for events not showing and commented it out for now, but please leave the FTP access since it's not a good solution. I need to consult it with programmers so they can advice a less invasive workaround.

The following user(s) said Thank You: yves
6 years 2 months ago
  • yves's Avatar
    Topic Author
  • yves
  • Offline
  • Junior Boarder
  • Posts: 111
  • Thank you received: 5
Licenses:
JomSocial Active

Thank you Piotr for that already.
I will leave your ftp access open so far (and also for the other ticket and for the point 1° of this ticket).
Kind regards
yves

6 years 2 months ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi

Sorry I missed the first problem with a map. But I cannot see this problem. Can You please prepare it as with the last issue and lead me to where I'll be able to see it ? Thank You in advance.

6 years 2 months ago
  • yves's Avatar
    Topic Author
  • yves
  • Offline
  • Junior Boarder
  • Posts: 111
  • Thank you received: 5
Licenses:
JomSocial Active

Hi,

I modified the settings of the module for mapping the members to show all members instead of friends only.
you can see it on the community test page for you.
If you look on the map in Belgium, you will then see that the pointer is showing an administrator despite the general configuration of JS not to display super users.

6 years 2 months ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi

I've checked and indeed You can see it as long as You are a super user Yourself. I've made a test and a user with a permission lower than that does not see a location of Super Users. I think it's working correctly.

6 years 2 months ago
  • yves's Avatar
    Topic Author
  • yves
  • Offline
  • Junior Boarder
  • Posts: 111
  • Thank you received: 5
Licenses:
JomSocial Active

Hi Piotr,

I just tested also, using another user account which is not a super user, but I can still see the users who are super users on the map.
you can make a test with a user having the same rights as the rights given on the Member map module.
regards
yves

6 years 1 month ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi

I'm very sorry, but I got confused. I've been talking about the first problem mentioned about the syntax error in DB query.

So lets focus on second problem with Super User only. In fact module does not hide any users. By default You can only see Friend or All users despite the fact if such user is a Super User or other.

I've modified /modules/mod_community_membersmap/helper.php starting from line 237 and added this code to remove Super Users from showing on map:

foreach($row as $k=>$m){
$count = 0;
$sql = 'SELECT COUNT(*) FROM '.$db->quoteName('#__user_usergroup_map').' WHERE '.$db->quoteName('group_id').'='.$db->Quote(8).' AND '.$db->quoteName('user_id').'='.$db->Quote($m->user_id);
$db->setQuery($sql);
$count = $db->loadResult();

if($count){
unset($row[$k]);
}
}

The following user(s) said Thank You: yves
6 years 1 month ago
  • yves's Avatar
    Topic Author
  • yves
  • Offline
  • Junior Boarder
  • Posts: 111
  • Thank you received: 5
Licenses:
JomSocial Active

Thank you Piotr.
shall make a copy of that file into a custom code template folder? (will it be overridden in a next update?)

6 years 1 month ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi

I'm afraid it will be overwritten during updates and it's a file which does not support overrides, so it will need to be recreated each time.

6 years 1 month ago
  • yves's Avatar
    Topic Author
  • yves
  • Offline
  • Junior Boarder
  • Posts: 111
  • Thank you received: 5
Licenses:
JomSocial Active

Hi,

Thank you for the precision. I will make a copy of the file to be able to see where you inserted the code.

Have you some feedback about the error on the community page when we choose to display "friends" instead of "all members" on the map module?

6 years 1 month ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi

Of course. Just send You a friend request to have exactly 1 friend so the issue should be visible than. Am I right? Are those the requirements for this bug to show ?

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW