Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
3.0.x
-
None
-
PHP Environment: 5.3.0
Database: PostgresQL 8.4
Description
(3.0.6RC4)
In functions_admin.php on line ~2361 need to change:
'FROM' => array(
|
ACL_OPTIONS_TABLE => 'o',
|
USER_GROUP_TABLE => 'ug',
|
ACL_GROUPS_TABLE => 'a',
|
GROUPS_TABLE => 'g',
|
),
|
on this
'FROM' => array(
|
ACL_OPTIONS_TABLE => 'o',
|
USER_GROUP_TABLE => 'ug',
|
GROUPS_TABLE => 'g',
|
ACL_GROUPS_TABLE => 'a',
|
),
|
because:
SQL ERROR [ postgres ]
|
|
|
ERROR: invalid reference to FROM-clause entry for table "a" LINE 1: ... a, pb_groups g LEFT JOIN pb_acl_roles_data r ON (a.auth_rol... ^ HINT: There is an entry for table "a", but it cannot be referenced from this part of the query. []
|
|
|
SQL
|
|
|
SELECT a.forum_id, ug.user_id, g.group_id FROM pb_acl_options o, pb_user_group ug, pb_acl_groups a, pb_groups g LEFT JOIN pb_acl_roles_data r ON (a.auth_role_id = r.role_id) WHERE (o.auth_option_id = a.auth_option_id OR o.auth_option_id = r.auth_option_id) AND ((a.auth_setting = 0 AND r.auth_setting IS NULL) OR r.auth_setting = 0) AND a.group_id = ug.group_id AND g.group_id = ug.group_id AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1) AND ug.user_id = 2 AND ug.user_pending = 0 AND o.auth_option LIKE 'm\\_%'
|
|
|
BACKTRACE
|
|
|
FILE: includes/db/postgres.php
|
LINE: 177
|
CALL: dbal->sql_error()
|
|
|
FILE: includes/functions_admin.php
|
LINE: 2385
|
CALL: dbal_postgres->sql_query()
|
|
|
FILE: includes/acp/acp_main.php
|
LINE: 344
|
CALL: cache_moderators()
|
|
|
FILE: includes/functions_module.php
|
LINE: 507
|
CALL: acp_main->main()
|
|
|
FILE: adm/index.php
|
LINE: 74
|
CALL: p_master->load_active()
|