-
Bug
-
Resolution: Fixed
-
Blocker
-
3.0.0
-
None
-
PHP Environment:
Database:
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()