Rbx

+Clients
  • Content count

    0
  • Joined

  • Last visited


Rbx's Activity

  1. Rbx added a post in a topic: (RSyvarth) Social Groups   

    [quote name='rsyvarth' timestamp='1345472601' post='2298932']
    social_groups_apps->core_memberList is the template that you are looking for.



    It looks like your server has ONLY_FULL_GROUP_BY turned on so you will either need to disable it or alter the query to include a group by for all of the values being pulled. If you need help altering the query let me know, I can give you some instructions as to what exactly you need to do.

    I checked the server configuration and ONLY_FULL_GROUP_BY is not turned on. Do you have any other idea please?
    Thanx.
  2. Rbx added a post in a topic: (RSyvarth) Social Groups   

    Hello,
    could anybody help us with a problem which i have described above?
    Thank you very mych.
  3. Rbx added a post in a topic: (RSyvarth) Social Groups   

    Hello,
    we've just installed this mod and it looks great, but there appeared an error. If I would like to see Members of a group, it shows a MySQL error. Error log shows this:

    Error: 1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause IP Address: 85.13.108.254 - /groups/1-libusinske-jidelni-orgie/app/core/member/
    mySQL query error:
    SELECT COUNT(g.g_id) as count,m.members_display_name FROM social_group_members g,members m WHERE g.is_approved=1 and g.has_left = 0 and g.g_id=1 AND g.member_id=m.member_id

    admin/applications_addon/other/groups/addons/official/core/section.php [section_core].listMembers line 120 admin/applications_addon/other/groups/modules_public/view/page.php [section_core].doExecute line 222
    admin/applications_addon/other/groups/modules_public/view/page.php [public_groups_view_page].getSection line 170 admin/sources/base/ipsController.php [public_groups_view_page].doExecute line 306

    Could you help us please?
    Thx.
  4. Rbx added a comment on a file: (RSyvarth) Social Groups   

    Hello,
    we've just installed this mod and it looks great, but there appeared an error. If I would like to see Members of a group, it shows a MySQL error. Error log shows this:

    Error: 1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause IP Address: 85.13.108.254 - /groups/1-libusinske-jidelni-orgie/app/core/member/
    mySQL query error:
    SELECT COUNT(g.g_id) as count,m.members_display_name FROM social_group_members g,members m WHERE g.is_approved=1 and g.has_left = 0 and g.g_id=1 AND g.member_id=m.member_id

    admin/applications_addon/other/groups/addons/official/core/section.php [section_core].listMembers line 120 admin/applications_addon/other/groups/modules_public/view/page.php [section_core].doExecute line 222
    admin/applications_addon/other/groups/modules_public/view/page.php [public_groups_view_page].getSection line 170 admin/sources/base/ipsController.php [public_groups_view_page].doExecute line 306

    Could you help us please?
    Thx.

About Me

Status Feed