Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-6913

user permissions

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 3.0.0
    • 3.0.1
    • ACP
    • None
    • PHP Environment:
      Database:

    Description

      When select the permissione this is the error is indifferent only one or more forum. With the previous version no problem. my forum is
      http://www.tuttocaravan.info/forums

      Errore Generale
      SQL ERROR [ mysqli ]

      The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay [1104]

      SQL

      SELECT DISTINCT g.group_type, g.group_name, g.group_id FROM (phpbb_groups g, phpbb_acl_options o, phpbb_acl_groups a) LEFT JOIN phpbb_acl_roles_data r ON (a.auth_role_id = r.role_id) WHERE (a.auth_option_id = o.auth_option_id OR r.auth_option_id = o.auth_option_id) AND o.auth_option LIKE 'f
      _%' AND a.forum_id = '29' AND g.group_id = a.group_id ORDER BY g.group_type DESC, g.group_name ASC

      BACKTRACE

      FILE: includes/db/mysqli.php
      LINE: 143
      CALL: dbal_mysqli->sql_error()

      FILE: includes/acp/acp_permissions.php
      LINE: 1179
      CALL: dbal_mysqli->sql_query()

      FILE: includes/acp/acp_permissions.php
      LINE: 399
      CALL: acp_permissions->retrieve_defined_user_groups()

      FILE: includes/functions_module.php
      LINE: 471
      CALL: acp_permissions->main()

      FILE: adm/index.php
      LINE: 74
      CALL: p_master->load_active()

      Attachments

        Activity

          People

            Acyd Burn Meik Sievertsen [X] (Inactive)
            oldman100 oldman100
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: