Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Sunday 6:28 am
Add a reply View Replies (2)

Resolved Custom MYSQL Where in ListLayout of UserList Menu causes page not to load.

  1. itadminguy
    itadminguy
  2. General
  3. Monday, April 04 2016, 09:46 PM
I have a problem with the UserList. I have a menu item for the userlist for registered users. The userlist displays all users of all groups. The userlist also displays fields for each user. So far so good. Just one last step. I was testing to see if the My Sql Where could limit the list to a parituclar group or users.

If I put aynthing in the Custom SQL Where in the List Layout area of the User List Menu item, the page doesn't load (just white screen) (for testing I put "group_id IN (13)" in the Custom SQL Where)

I read an earlier support post indicating that easy profile plg_usergroups might be the problem. I tried the custom MySQL Where with the plg_usergroups enabled and disabled, but the same result occurs and the page doesn't load. Maybe there is another conflict? How to diagnose this problem.

I am trying to get logged in users to only see certain groups on their UserList Menu.

See site details for more. Thank You.
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
found the problem, this is due to "Content - RokInjectModule" plugin, now I have disabled and all works.

"Content - RokInjectModule" plugin allow you to insert a module in articles, in Joomla this is already possible with built-in "Content - Load Modules" plugin. So this plugin is not necessary.

Also "RocketTheme" team (developers) say no useless.

Here more info with reference links: https://www.easy-profile.com/support/ongoing-problem-with-excluding-users-or-groups-in-list-for-example-group_id-not-in-6,7,8-or-user_id-not-in-168.html#reply-6347
  1. more than a month ago
  2. General
  3. # 1
itadminguy
itadminguy Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.